000035105 - RSA Identity Governance and Lifecycle Identity Data Collector (IDC) collection fails with the error:  "ORA-00918: column ambiguously defined" during the Identity Data Collection/Identity Data Unification step

Document created by RSA Customer Support Employee on May 9, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000035105
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0.0, 7.0.1 ,7.0.2
 
IssueRSA Identity Governance and 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 Driectory, 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 and Lifecycle:
  • RSA Identity Governance and Lifecycle 7.0.0 P04
  • RSA Identity Governance and Lifecycle 7.0.1 P01
  • RSA Identity Governance and 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 and 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 and Lifecycle versions:
  • RSA Identity Governance and Lifecycle 7.0.1 P03
  • RSA Identity Governance and 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. 

Attachments

    Outcomes