Article Content
Article Number | 000037632 |
Applies To | RSA Product Set: RSA Identity Governance & Lifecycle RSA Version/Condition: 7.1.1 |
Issue | The 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.SOURCEDATATABLES", line 142 ORA-06512: at "AVUSER.SOURCEDATATABLES", line 810 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. |
Cause | This is a known issue reported in engineering ticket ACM-98919. |
Resolution | This issue is resolved in RSA Identity Governance & Lifecycle 7.1.1 P01. |
Workaround | As a workaround, follow the steps below:
NOTE: Data prior to the upgrade will be lost. |