How to find duplicates for IM tasksession12_5 and archive_tasksession12_5__clean_up

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

See how to find duplicate entries in table tasksession12_5 and archive_tasksession_12_5

Cleanup Submitted Tasks task: Primary Event. Event ID [a1a644d0-0aec8087-40973d53-807f42fe] Task "Cleanup Submitted Tasks": Failed to execute CleanupSubmittedTasksEvent. ERROR MESSAGE: Violation of PRIMARY KEY constraint 'PK_archive_tasksession12_5'. Cannot insert duplicate key in object 'dbo.archive_tasksession12_5'. The duplicate key value is (851752e9-0aec8091-2be1c165-d540f8a8|1 4 2126:WPDS).

Environment

Release: CA Identity Manager 14.1, 14.2,14.3, 14.4
Component:

Resolution

Instructions: 

How to find duplicates for IM tasksession12_5 and archive_tasksession12_5

Example of data in the ARCHIVE_TASKSESSION12_5 Table Note: Primary Key is TASKSESSIONID

Example of data in the TASKSESSION12_5 Table Note: Primary Key is TASKSESSIONID

Find Duplicates with SQL Query

SELECT a.TASKSESSIONID, b.TASKSESSIONID FROM ARCHIVE_TASKSESSION12_5 a, TASKSESSION12_5 b where a.TASKSESSIONID=b.TASKSESSIONID;

For comparison: An example of reverse  query; tasksessionid that do not match

 

Additional Information

Before do changes in DB ask help from DBA to backup and help with SQL commands.