000033975 - 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

Document created by RSA Customer Support Employee on Mar 10, 2017Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000033975
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 6.9.1
 
IssueDuring an upgrade of RSA Identity Governance and Lifecycle from  6.9.0 to 6.9.1, the following error may occur:
 
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
CauseIn RSA RSA Identity Management and Governance 6.9.0, the view AVUSER.V_DC_SOURCEDATA_USER has the column SUPERVISOR. However, in RSA Identity Management and Governance version 6.9.1, the column name has been changed to SUPERVISOR_ID.
 

 
ResolutionNo action is necessary. This is a transitory error during the upgrade process, and may be safely ignored.

Attachments

    Outcomes