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

Document created by RSA Customer Support Employee on May 9, 2017Last modified by RSA Customer Support on Jun 10, 2019
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000035105
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0.0, 7.0.1 ,7.0.2
IssueRSA Identity Governance & Lifecycle Identity Data Collector (IDC) collection shows status of Failed during the Identity Data Collection/Identity Data Unification step, as shown:
User-added image

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 1
CauseThis is a known issue in  in the following versions of RSA Identity Governance & Lifecycle:
  • 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.
ResolutionThis issue is resolved in the following RSA Identity Governance & Lifecycle versions:
  • RSA Identity Governance & Lifecycle 7.0.1 P03
  • RSA Identity Governance & Lifecycle 7.0.2 P01
Customers using 7.0.0 P04 should upgrade to the latest patch on the 7.0.1 or 7.0.2 versions.
WorkaroundThere is no practicable work around for this issue.   Contact RSA customer support for additional guidance if you are unable to patch to a version where this issue is resolved.