CleanUp IM submitted task doesn't work

Products

• CA Identity Manager

Issue/Introduction

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?

Environment

Release : 14.3 CP3

Component : IdentityMinder(Identity Manager)

Resolution

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

 

https://knowledge.broadcom.com/external/article?articleId=144688

 

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.