OIA The First Reminder Email Does Not Trigger With SQL Error "returned too many results" (Doc ID 2205473.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Identity Analytics - Version 11.1.1.5.3 and later
Information in this document applies to any platform.

Symptoms

OIA throws an error while triggering the first reminder email as seen below:


01:30:24,471 ERROR [JobRunShell] Job SYSTEM.Certification Reminder threw an unhandled Exception:
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error: executeQueryForObject returned too many results.; nested exception is java.sql.SQLException: Error: executeQueryForObject returned too many results.
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271)
at com.vaau.rbacx.dao.ibatis.SqlMapParameterDao.getParameter(SqlMapParameterDao.java:27)
at com.vaau.rbacx.service.impl.RbacxServiceImpl.getParameter(RbacxServiceImpl.java:1149)
at sun.reflect.GeneratedMethodAccessor709.invoke(Unknown Source)


and the email does not get sent.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms