Account Data Collectors (ADC) fail with ORA-00904: "RESOURCE_NAME": invalid identifier after upgrading RSA Identity Governance & Lifecycle to 7.1.1
Originally Published: 2019-06-14
Article Number
Applies To
RSA Version/Condition: 7.1.1
Issue
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
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
Resolution
Workaround
Related Articles
ORA-01403: no data found error in Account Data Collectors (ADC) in RSA Governance & Lifecycle Number of Views How to determine who has created an RSA Identity Governance and Lifecycle Account Data Collector (ADC) Number of Views 'Multi App Collector : 'Admin' privilege does not allow editing of the collector definition as expected in RSA Identity Go… Number of Views How to configure a JSON response in AFX connector capabilities to parse single or multi-valued responses in RSA Identity G… Number of Views ORA-01403 no data found error in Account Data Collectors (ADC) in Step 10/11 in RSA Governance & Lifecycle Number of Views
Trending Articles
RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide View Transfer Tokens to Cloud Jobs How to Upgrade Internal SHA-1 Certificates to SHA-256 in Authentication Manager Using rsautil RSA Release Notes for RSA Authentication Manager 8.8
Don't see what you're looking for?
