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
Last Modified: 2023-11-30
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
Assign a Workflow Policy to a Security Domain Number of Views Tables embedded in workflow email nodes are malformed after upgrading to version 7.1.1 of RSA Identity Governance & Lifecycle Number of Views SQL Server data collectors in RSA Identity Governance & Lifecycle periodically fail with connection timed out errors Number of Views In Rest Web Service Node, the Response Variables does not appear to accept Integer or Boolean values in RSA Governance & L… Number of Views AFX Server fails to start in a WebSphere deployment after upgrading to 7.0.x or higher of RSA Identity Governance & Lifecycle Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
