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
MultiApp collector is failing at task 3 with ORA-01400 error in RSA Governance & Lifecycle Number of Views RSA Identity Governance & Lifecycle authentication fails if the authentication sources uses Aveksa Data Collector (ADC) an… Number of Views RSA Identity Governance and Lifecycle Account Data Collector (ADC) and Entitlement Data Collectors (EDC) are slow in step … Number of Views How to determine who has created an RSA Identity Governance and Lifecycle Account Data Collector (ADC) Number of Views Workday ADC "Test Collector'" gets Workday webservice exception Number of Views
Trending Articles
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA MFA Agent 2.4 for Microsoft Windows Installation and Administration Guide Downloading RSA Authentication Manager license files or RSA Software token seed records Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
