Identity Data Collector (IDC) collection fails with the error: "ORA-00918: column ambiguously defined" during the Identity Data Collection/Identity Data Unification step in RSA Identity Governance & Lifecycle
Originally Published: 2017-04-27
Last Modified: 2022-06-20
Article Number
Applies To
RSA Version/Condition: 7.0.0, 7.0.1 ,7.0.2
Issue
Under Details for Run, if you select Admin Errors, the detailed failure shows:
EC[918] Context[RunID=30947, IDC(Name=Active Directory, ID=5)}
Message[Unknown error code]
The aveksaServer.log file (/home/oracle/wildfly-8.2.0.Final/standalone/log/aveksaServer.log) shows the error ORA-00918: column ambiguously defined:
com.aveksa.server.xfw.ExecutionException: com.aveksa.server.collector.DataProcessorException: com.aveksa.server.db.PersistenceException: java.sql.SQLSyntaxErrorException:
ORA-00918: column ambiguously defined
ORA-06512: at "AVUSER.IDC_NORMALIZE", line 220
ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 105
ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 195
ORA-06512: at line 1Cause
- RSA Identity Governance & Lifecycle 7.0.0 P04
- RSA Identity Governance & Lifecycle 7.0.1 P01
- RSA Identity Governance & Lifecycle 7.0.2 GA version
This issue may occur during upgrade or patch when the customer has existing unified users that contains duplicates. If more than one IDC is defined, and the original attribute used to define the join criteria for the unification was not unique the unification may fail. Note that if a new unification is defined RSA Identity Governance & Lifecycle now prevents the unification from being defined in a manner that might lead to duplicate users.
Resolution
- RSA Identity Governance & Lifecycle 7.0.1 P03
- RSA Identity Governance & Lifecycle 7.0.2 P01
Workaround
Related Articles
Termination rule intermittently fails to delete or disable accounts in RSA Identity Governance & Lifecycle 58Number of Views Account column missing under Available Columns in Review display view in RSA Identity Governance & Lifecycle 22Number of Views Unification slow and identity collections show users in reprocessed state in RSA Identity Governance & Lifecycle 72Number of Views Unification fails at Step 7/11 with 'ORA-54017: UPDATE operation disallowed on virtual columns' in RSA Identity Governance… 91Number of Views How to collect data from a .csv file on a password protected FTP server in RSA Identity Governance and Lifecycle 7.0.0 66Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager Patch Updates RSA Authentication Manager Upgrade Process RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities
Don't see what you're looking for?