CleanUp IM submitted task doesn't work
search cancel

CleanUp IM submitted task doesn't work


Article ID: 243683


Updated On:


CA Identity Manager


An issue has been identified when running the CA Identity Manager cleanup submitted task process.

The process appears to work (scheduled every day) however every couple of weeks the following error is logged:

Cleanup Submitted Tasks task: Primary Event. Event ID [90f13f76-7ffefd47-5ce0f5bf-1dc96b49] Task "Cleanup Submitted Tasks": Failed to execute CleanupSubmittedTasksEvent. ERROR MESSAGE: ORA-00001: restricción única (IMOBJSTORE.PK_ARCH_TASKSESSION12_5) violada ORA-06512: en "IMOBJSTORE.ARCHIVEBYTASKID", línea 34 ORA-06512: en "IMOBJSTORE.ARCHIVETASKS", línea 44 ORA-06512: en "IMOBJSTORE.ARCHIVETASKPERSISTENCE", línea 15 ORA-06512: en línea 1

What is the cause of this issue?


Release : 14.3 CP3

Component : IdentityMinder(Identity Manager)


This issue can occur in normal operations and may require a manual cleanup of duplicate items.  Please refer to the following Knowledge Article.


However, in this case, the issue was caused by old stored procedures ("GarbageCollectTasks" and "archiveTasks" procedures) which needed to be updated as below. 


Old Line:

tasksession12_5.state = 16384 -- audit state
     AND last_access_time < 
      LEAST(cutoff_time, SYSDATE - audit_timeout_days)


New : 

tasksession12_5.state = 16384 -- audit state
     AND parent_of_wf_id IS NULL
     AND last_access_time < 
      LEAST(cutoff_time, SYSDATE - audit_timeout_days)


After making the changes the issue was resolved.