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 RSA Authentication Manager Web Tier installation fails with the following error: The directory already exists! 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 After deleting a user with Quick Admin the following message appears: refreshinfo: Problem processing request: message is … 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
Trending Articles
Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.9 Release Notes (January 2026) Artifacts to gather in RSA Identity Governance & Lifecycle RSA Governance & Lifecycle 8.0.0 Administrators Guide RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?
