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
Last Modified: 2023-12-01
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
On database startup for RSA Identity Governance and Lifecycle the following error is seen: CRS-2501: Resource 'ora.avdb.d… Number of Views RSA Authentication Manager On-Demand Authentication (ODA) failing with the following error: User provided incorrect On-De… Number of Views RSA Identity Governance & Lifecycle 7.0.0 installation fails with the following error: JBAS014653: Composite operation fa… Number of Views Qualys Enterprise TruRisk - SAML My Page SSO Configuration - RSA Ready Implementation Guide Number of Views enVision: Reports are not seeing current dates Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Manual synchronization introduced in RSA Authentication Manager 8.2 Service Pack 1 patch 6 Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to verify NTP server synchronization is not working in RSA Authentication Manager 8.x RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?
