During an upgrade of RSA Identity Governance and Lifecycle from 6.9.0 to 6.9.1 the following error is seen: ORA-00904: "SUPERVISOR": invalid identifier on V_DC_SOURCEDATA_USER
Originally Published: 2016-09-08
Article Number
Applies To
RSA Version/Condition: 6.9.1
Issue
ORA-00904: "SUPERVISOR": invalid identifier
The error is seen in the aveksaServer.log as:
09/06/2016 09:39:41.482 INFO (ApplyChangesRegularThread-64) [com.aveksa.client.component.DefaultComponentManager] DCM132: Ignoring Event: com.aveksa.client.component.event.CollectionRequestEvent[source=com.aveksa.client.component.communication.DefaultCommunicationManager@6cc61a22]
09/06/2016 09:39:41.483 INFO (ApplyChangesRegularThread-64) [com.aveksa.client.datacollector.framework.DataCollectorManager] STARTING method=Collect CollectionMetaInfo[{ID=5, run_id=9759, collector_id=3, test-run=false, collector_name=Identity Warehouse IDC}]
09/06/2016 09:49:05.070 ERROR (http-0.0.0.0-8443-7) [com.aveksa.gui.components.table.special.SQLTable] SELECT COUNT(*) AS NUM_ROWS FROM (select * from (select * from V_DC_SOURCEDATA_USER where run_id in ( 9759, -9759) and dc_id = 3 and is_deleted = 0) X WHERE ((lower(IS_REJECTED) like '%44213%') OR (lower(USER_ID) like '%44213%') OR (lower(UNIQUE_ID) like '%44213%') OR (lower(FIRST_NAME) like '%44213%') OR (lower(LAST_NAME) like '%44213%') OR (lower(EMAIL_ADDRESS) like '%44213%') OR (lower(BUSINESS_UNIT) like '%44213%') OR (lower(DEPARTMENT) like '%44213%') OR (lower(TITLE) like '%44213%') OR (lower(JOB_STATUS) like '%44213%') OR (lower(IS_TERMINATED) like '%44213%') OR (lower(TERMINATION_DATE) like '%44213%') OR (lower(SUPERVISOR) like '%44213%')))
09/06/2016 09:49:05.071 ERROR (http-0.0.0.0-8443-7) [com.aveksa.UI] com.aveksa.gui.components.table.core.DefaultTableModel.getNumRows(DefaultTableModel.java:58) - java.lang.RuntimeException: com.aveksa.server.db.PersistenceException: Executing JDBC query failed [SELECT COUNT(*) AS NUM_ROWS FROM (select * from (select * from V_DC_SOURCEDATA_USER where run_id in ( 9759, -9759) and dc_id = 3 and is_deleted = 0) X WHERE ((lower(IS_REJECTED) like '%44213%') OR (lower(USER_ID) like '%44213%') OR (lower(UNIQUE_ID) like '%44213%') OR (lower(FIRST_NAME) like '%44213%') OR (lower(LAST_NAME) like '%44213%') OR (lower(EMAIL_ADDRESS) like '%44213%') OR (lower(BUSINESS_UNIT) like '%44213%') OR (lower(DEPARTMENT) like '%44213%') OR (lower(TITLE) like '%44213%') OR (lower(JOB_STATUS) like '%44213%') OR (lower(IS_TERMINATED) like '%44213%') OR (lower(TERMINATION_DATE) like '%44213%') OR (lower(SUPERVISOR) like '%44213%')))]
at com.aveksa.gui.components.table.special.SQLTable.getObjectCount(SQLTable.java:345)
at com.aveksa.gui.components.table.special.SQLTable.getObjectCount(SQLTable.java:320)
at com.aveksa.gui.components.table.core.DefaultTableModel.getNumRows(DefaultTableModel.java:56)
...
Caused by: com.aveksa.server.db.PersistenceException: Executing JDBC query failed [SELECT COUNT(*) AS NUM_ROWS FROM (select * from (select * from V_DC_SOURCEDATA_USER where run_id in ( 9759, -9759) and dc_id = 3 and is_deleted = 0) X WHERE ((lower(IS_REJECTED) like '%44213%') OR (lower(USER_ID) like '%44213%') OR (lower(UNIQUE_ID) like '%44213%') OR (lower(FIRST_NAME) like '%44213%') OR (lower(LAST_NAME) like '%44213%') OR (lower(EMAIL_ADDRESS) like '%44213%') OR (lower(BUSINESS_UNIT) like '%44213%') OR (lower(DEPARTMENT) like '%44213%') OR (lower(TITLE) like '%44213%') OR (lower(JOB_STATUS) like '%44213%') OR (lower(IS_TERMINATED) like '%44213%') OR (lower(TERMINATION_DATE) like '%44213%') OR (lower(SUPERVISOR) like '%44213%')))]
...
Caused by: java.sql.SQLException: ORA-00904: "SUPERVISOR": invalid identifier
09/06/2016 09:39:41.483 INFO (ApplyChangesRegularThread-64) [com.aveksa.client.datacollector.framework.DataCollectorManager] STARTING method=Collect CollectionMetaInfo[{ID=5, run_id=9759, collector_id=3, test-run=false, collector_name=Identity Warehouse IDC}]
09/06/2016 09:49:05.070 ERROR (http-0.0.0.0-8443-7) [com.aveksa.gui.components.table.special.SQLTable] SELECT COUNT(*) AS NUM_ROWS FROM (select * from (select * from V_DC_SOURCEDATA_USER where run_id in ( 9759, -9759) and dc_id = 3 and is_deleted = 0) X WHERE ((lower(IS_REJECTED) like '%44213%') OR (lower(USER_ID) like '%44213%') OR (lower(UNIQUE_ID) like '%44213%') OR (lower(FIRST_NAME) like '%44213%') OR (lower(LAST_NAME) like '%44213%') OR (lower(EMAIL_ADDRESS) like '%44213%') OR (lower(BUSINESS_UNIT) like '%44213%') OR (lower(DEPARTMENT) like '%44213%') OR (lower(TITLE) like '%44213%') OR (lower(JOB_STATUS) like '%44213%') OR (lower(IS_TERMINATED) like '%44213%') OR (lower(TERMINATION_DATE) like '%44213%') OR (lower(SUPERVISOR) like '%44213%')))
09/06/2016 09:49:05.071 ERROR (http-0.0.0.0-8443-7) [com.aveksa.UI] com.aveksa.gui.components.table.core.DefaultTableModel.getNumRows(DefaultTableModel.java:58) - java.lang.RuntimeException: com.aveksa.server.db.PersistenceException: Executing JDBC query failed [SELECT COUNT(*) AS NUM_ROWS FROM (select * from (select * from V_DC_SOURCEDATA_USER where run_id in ( 9759, -9759) and dc_id = 3 and is_deleted = 0) X WHERE ((lower(IS_REJECTED) like '%44213%') OR (lower(USER_ID) like '%44213%') OR (lower(UNIQUE_ID) like '%44213%') OR (lower(FIRST_NAME) like '%44213%') OR (lower(LAST_NAME) like '%44213%') OR (lower(EMAIL_ADDRESS) like '%44213%') OR (lower(BUSINESS_UNIT) like '%44213%') OR (lower(DEPARTMENT) like '%44213%') OR (lower(TITLE) like '%44213%') OR (lower(JOB_STATUS) like '%44213%') OR (lower(IS_TERMINATED) like '%44213%') OR (lower(TERMINATION_DATE) like '%44213%') OR (lower(SUPERVISOR) like '%44213%')))]
at com.aveksa.gui.components.table.special.SQLTable.getObjectCount(SQLTable.java:345)
at com.aveksa.gui.components.table.special.SQLTable.getObjectCount(SQLTable.java:320)
at com.aveksa.gui.components.table.core.DefaultTableModel.getNumRows(DefaultTableModel.java:56)
...
Caused by: com.aveksa.server.db.PersistenceException: Executing JDBC query failed [SELECT COUNT(*) AS NUM_ROWS FROM (select * from (select * from V_DC_SOURCEDATA_USER where run_id in ( 9759, -9759) and dc_id = 3 and is_deleted = 0) X WHERE ((lower(IS_REJECTED) like '%44213%') OR (lower(USER_ID) like '%44213%') OR (lower(UNIQUE_ID) like '%44213%') OR (lower(FIRST_NAME) like '%44213%') OR (lower(LAST_NAME) like '%44213%') OR (lower(EMAIL_ADDRESS) like '%44213%') OR (lower(BUSINESS_UNIT) like '%44213%') OR (lower(DEPARTMENT) like '%44213%') OR (lower(TITLE) like '%44213%') OR (lower(JOB_STATUS) like '%44213%') OR (lower(IS_TERMINATED) like '%44213%') OR (lower(TERMINATION_DATE) like '%44213%') OR (lower(SUPERVISOR) like '%44213%')))]
...
Caused by: java.sql.SQLException: ORA-00904: "SUPERVISOR": invalid identifier
Cause
Resolution
Related Articles
RSA Identity Governance & Lifecycle 7.0.0 installation fails with the following error: JBAS014653: Composite operation fa… Number of Views When running PL/SQL block in RSA Identity Governance and Lifecycle, the following error occurs: ORA-01471: cannot create … Number of Views On database startup for RSA Identity Governance and Lifecycle the following error is seen: CRS-2501: Resource 'ora.avdb.d… Number of Views After deleting a user with Quick Admin the following message appears: refreshinfo: Problem processing request: message is … Number of Views RSA Authentication Manager Web Tier installation fails with the following error: The directory already exists! Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Governance & Lifecycle 8.0.0 Administrators Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory
Don't see what you're looking for?
