000037632 - Account Data Collectors (ADC) fail with ORA-00904: "RESOURCE_NAME": invalid identifier after upgrading RSA Identity Governance & Lifecycle from 7.0.2 to 7.1.1

Document created by RSA Customer Support Employee on Jun 14, 2019Last modified by RSA Customer Support Employee on Jun 28, 2019
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000037632
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.1.1
IssueThe Account Data Collectors (ADCs) fail with the following error after upgrading RSA Identity Governance & Lifecycle from 7.0.2 to 7.1.1. 
ORA-00904: "RESOURCE_NAME": invalid identifier

The following errors are seen in the aveksaServer.log:

03/22/2019 13:48:42.480 WARN (Exec Task Consumer#0 - Accounts Sequence) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 904,
SQLState: 42000 03/22/2019 13:48:42.481 ERROR (Exec Task Consumer#0 - Accounts Sequence) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper]
ORA-00904: "RESOURCE_NAME": invalid identifier
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 197
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 477
ORA-06512: at line 1

The aveksaServer.log reference above is for a standalone WildFly deployment.  If you have RSA Identity Governance & Lifecycle deployed on a different platform or on a WildFly cluster, please refer to 000030327 - Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the aveksaServer.log for your deployment.

CauseThis is a known issue reported in engineering ticket ACM-98919.
ResolutionFixed in RSA Identity Governance & Lifecycle 7.1.1 P01.
WorkaroundRecreate the database schema, import the metadata and re-run collections. Data prior to the upgrade will be lost.