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
Objects previously collected by Account Collectors and Entitlement Collectors in 6.x are rejected in 7.x of RSA Identity G… Number of Views RSA Identity Governance and Lifecycle 7.1.0.8 Release Notes Number of Views Change Request generated by Role Review shows as Rejected in RSA Identity Governance & Lifecycle Number of Views Why automatically generated revocation requests do not add back revoked requests on a revocation date in RSA Identity Gove… Number of Views RSA Identity Governance and Lifecycle 7.1.0.1 Release Notes Number of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Mandatory Certificate Upgrade Required by 6th October 2025 for RSA MFA Agent for PAM, RSA MFA Agent for Apache, and Third … RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
