Cleanup Submitted Tasks task: Primary Event. Event ID [############-##########-#############] Task "Cleanup Submitted Tasks": Failed to execute CleanupSubmittedTasksEvent.
ERROR MESSAGE:
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "IAPP_IMSTORE_MGR.ARCHIVECOMPLETEDEVENTSBYID", line 15
ORA-06512: at "IAPP_IMSTORE_MGR.ARCHIVECOMPLETEDTASKSBYID", line 33
ORA-06512: at "IAPP_IMSTORE_MGR.ARCHIVECOMPLETEDTASKS", line 28
ORA-06512: at "IAPP_IMSTORE_MGR.ARCHIVETASKPERSISTENCE", line 15
ORA-06512: at line 1
23:58:31,355 ERROR [ims.tmt.persistence.cleanup] (Thread-12114) cleanupTaskPersistence >> ORA-00001: unique constraint (IAPS_IMSTORE_MGR.PK_ARCH_TASKSESSION12_5) violated
ORA-06512: at "IAPS_IMSTORE_MGR.ARCHIVEBYTASKID", line 34
ORA-06512: at "IAPS_IMSTORE_MGR.ARCHIVETASKS", line 44
ORA-06512: at "IAPS_IMSTORE_MGR.ARCHIVETASKPERSISTENCE", line 19
ORA-06512: at line 1
: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (IAPS_IMSTORE_MGR.PK_ARCH_TASKSESSION12_5) violated
ORA-06512: at "IAPS_IMSTORE_MGR.ARCHIVEBYTASKID", line 34
ORA-06512: at "IAPS_IMSTORE_MGR.ARCHIVETASKS", line 44
ORA-06512: at "IAPS_IMSTORE_MGR.ARCHIVETASKPERSISTENCE", line 19
ORA-06512: at line 1
Release : 14.1
Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)
If IM taskpersistance and archive are using separate DB's you will need to switch the operation a bit:
This select will need to be split into two:
select tasksessionid from tasksession12_5 where tasksessionid in (select tasksessionid from archive_tasksession12_5);
so:
select tasksessionid from archive_tasksession12_5;
save result to a file, move file to second database.
select tasksessionid from tasksession12_5 where tasksessionid in <file from previous step>;
this will give you list of duplicated tasks you can apply step 3 on to in taskpersistance database.