Sorting on Certification Action Column throws Popup ERROR: ORA-00904" "DELEGATED_REVIEWER_ID": invalid identifier (Doc ID 2249519.1)

Last updated on APRIL 03, 2017

Applies to:

Identity Manager - Version 11.1.2.2.0 to 11.1.2.2.5 [Release 11g]
Information in this document applies to any platform.

Symptoms

Sorting on the "Action" column within a Certification item results in a popup Error window with:

Messages for this page are listed below.
Unexpected exception caught: {0}, msg={1}
Error returned is: Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904" "DELEGATED_REVIEWER_ID": invalid identifier
Error Code: 904
Error returned is: ORA-00904: "DELEGATED_REVIEWER_ID": invalid identifier

 

The corresponding $DOMAIN_HOME/servers/oim_serverX/logs/oim_serverX-diagnostic.log file shows the following WARNING messages:

[2017-03-27T15:38:59.774-04:00] [oim_serverX] [WARNING] [] [oracle.adf.controller.faces.lifecycle.Utils] [tid: [ACTIVE].ExecuteThread: '20' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: userA] [ecid: abc123] [APP: oracle.iam.console.identity.self-service.ear#V2.0] [DSID: def456] ADF: Adding the following JSF error message: Unexpected exception caught: {0}, msg={1}[[
oracle.iam.ui.platform.exception.OIMRuntimeException: JBO-29000: Unexpected exception caught: org.eclipse.persistence.exceptions.DatabaseException, msg=
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "DELEGATED_REVIEWER_ID": invalid identifier

Error Code: 904
at oracle.iam.ui.platform.exception.OIMRuntimeException.wrap(OIMRuntimeException.java:62)
at oracle.iam.ui.platform.model.common.OIMProgrammaticVO.executeQueryForCollection(OIMProgrammaticVO.java:451)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1257)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1449)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1355)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1340)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:7236)
at oracle.adf.model.bc4j.DCJboDataControl.executeIteratorBinding(DCJboDataControl.java:1329)
....
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "DELEGATED_REVIEWER_ID": invalid identifier

Error Code: 904
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:246)
at org.eclipse.persistence.queries.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:192)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1463)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:485)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:742)
at oracle.iam.certification.dao.jpa.JpaUserCertificationDaoImpl.getIDCAccountAttributesFlatByCertificationAndUser(JpaUserCertificationDaoImpl.java:3829)
at oracle.iam.certification.manager.impl.UserCertificationManagerImpl.loadBatchUserEntitlements(UserCertificationManagerImpl.java:3773)
at oracle.iam.certification.impl.CertificationServiceImpl.loadBatchUserEntitlements(CertificationServiceImpl.java:2450)
....
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "DELEGATED_REVIEWER_ID": invalid identifier
...
## Detail 0 ##
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "DELEGATED_REVIEWER_ID": invalid identifier

Error Code: 904
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
...
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "DELEGATED_REVIEWER_ID": invalid identifier
....

]]
[2017-03-27T15:38:59.776-04:00] [oim_serverX] [WARNING] [] [oracle.adf.controller.faces.lifecycle.Utils] [tid: [ACTIVE].ExecuteThread: '20' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: userA] [ecid: abc123] [APP: oracle.iam.console.identity.self-service.ear#V2.0] [DSID: def456] ADF: Adding the following JSF error message: Error returned is: [[
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "DELEGATED_REVIEWER_ID": invalid identifier

Error Code: 904 Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "DELEGATED_REVIEWER_ID": invalid identifier

Error Code: 904

 

 

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