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
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
