000034544 - RSA Identity Governance and Lifecycle 7.0 identity collector fails with error ORA-01422: exact fetch returns more than requested number of rows

Document created by RSA Customer Support Employee on Dec 19, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000034544
Applies ToRSA Product Set: Identity Governance and Lifecycle
RSA Version/Condition: 7.0
 
IssueThe RSA Identity Governance and Lifecycle Active Directory Identity Data Collector (AD IDC) is failing while running step 4/6: Object Processing: Normalize Objects, as shown here:
 
User-added image

The following event is logged in the respective aveksaServer.log file of the implementation.
05/11/2016 13:04:15.803 ERROR (Exec Task Consumer#3) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute 
ExecutionTask[TaskID=25205 RunID=11518 Source=48 Type=DataObjectProcessing Status=InProgress] 
com.aveksa.server.xfw.ExecutionException: com.aveksa.server.collector.DataProcessorException:
com.aveksa.server.db.PersistenceException:
java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows 
ORA-06512: at "AVUSER.USER_MEUID", line 725 
ORA-06512: at "AVUSER.IDC_NORMALIZE", line 145 
ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 72 
ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 161 
ORA-06512: at line 1 
at com.aveksa.server.xfw.DataObjectProcessingExecutor.executeFullTask(DataObjectProcessingExecutor.java:119) 
at com.aveksa.server.xfw.DataObjectProcessingExecutor.executeTask(DataObjectProcessingExecutor.java:58) 
at com.aveksa.server.xfw.TaskExecutor.execute(TaskExecutor.java:99) 
at com.aveksa.server.xfw.ExecutionTaskQueue$Worker.run(ExecutionTaskQueue.java:116) 
at java.lang.Thread.run(Thread.java:745)
CauseThe problem occurs in RSA Identity Governance and Lifecycle 7.0 because IDC collection data was being rejected when participating in unification joined on non-unique attributes.
ResolutionThis issue has been fixed in RSA Identity Governance and Lifecycle 7.0 P05.

Attachments

    Outcomes