IDC unification runs into an error called by by webservice call in RSA Identity Governance & Lifecycle
2 years ago
Originally Published: 2018-05-22
Article Number
000060587
Applies To
RSA Version/Condition: 7.0.2 P05
Issue
Unification fails if the unification is started automatically by webservice call

Below error can be seen in aveksaServer.log
 
03/22/2018 02:28:41.322 INFO (Exec Task Consumer#6) [com.aveksa.server.xfw.UnificationExecutor] Failed method=Process subTask=CompleteMergeTasks Default User Population, 1230
com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-01423: error encountered while checking for extra rows in exact fetch
ORA-08103: object no longer exists
ORA-06512: at "AVUSER.UNFC_PROCESSOR", line 47
ORA-06512: at line 1





 
Resolution
Need to increase the sleep time before the unification and add a sleep time after unificaiton like below

curl -k -d "cmd=collectIdentities&unify=false" $URL/aveksa/command.submit
sleep 120
curl -k -d "cmd=unify" $URL/aveksa/command.submit
sleep 120