RSA Identity Governance and Lifecycle 7.0 identity collector fails with error ORA-01422: exact fetch returns more than requested number of rows
Originally Published: 2016-12-12
Last Modified: 2023-11-30
Article Number
000043018
Applies To
RSA Product Set: Identity Governance and Lifecycle
RSA Version/Condition: 7.0
 
Issue
The 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)
Cause
The 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.
Resolution
This issue has been fixed in RSA Identity Governance and Lifecycle 7.0 P05.

Related Articles

Trending Articles

Don't see what you're looking for?