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

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

Article Content

Article Number000037632
Applies ToRSA Product Set: RSA 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 to 7.1.1. 
ORA-00904: "RESOURCE_NAME": invalid identifier

The following errors are seen in the aveksaServer.log file ($AVEKSA_HOME/wildfly/standalone/log/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

Please refer to RSA Knowledge Base Article 000030327 -- Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the aveksaServer.log for your specific deployment if you are on a WildFly cluster or a non-WildFly platform.

CauseThis is a known issue reported in engineering ticket ACM-98919.
ResolutionThis issue is resolved in RSA Identity Governance & Lifecycle 7.1.1 P01.
WorkaroundAs a workaround, follow the steps below:
  1. Recreate the database schema.
  2. import the metadata.
  3. Re-run collections.

NOTE: Data prior to the upgrade will be lost.