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
Custom State button is not displayed in a Review in RSA Governance & Lifecycle Number of Views enVision: Reports are not seeing current dates Number of Views Intermittently SQL select node queries are seen in runtime in RSA Identity Governance & Lifecycle Number of Views Warning message "WARN Unable to find an Attribute length for : business_unit_id or supervisor" logging after installation… Number of Views As of 9.0 p3 the icap server will replace sensitive content in blocked email and send the replacement text to the recipien… Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
