Clear up submitted task fail with error Violation of PRIMARY KEY constraint 'PK_archive_runtimeStatusDetail12

Products

• CA Identity Manager

Issue/Introduction

Seeing the following error when executing clear up submitted tasks.

Task "Cleanup Submitted Tasks": Failed to execute CleanupSubmittedTasksEvent. ERROR MESSAGE: Violation of PRIMARY KEY constraint 'PK_archive_runtimeStatusDetail12'. Cannot insert duplicate key in object 'dbo.archive_runtimeStatusDetail12'. The duplicate key value is (322291).

 

Environment

Release : 14.4

Component : Identity Manager

Cause

Due to migrating old archive data to new IDM environment

Resolution

If the Archive information is not needed, for example shortly after the initial installation, or in non-production environments, drop the archive tables, denoted by the ARCHIVE_ in the database and restart Identity Manager to recreate those tables. 


If the Archive information is needed, for example in Production environments, please see KB 44246 How to find duplicates for IM tasksession12_5 and archive_tasksession12_5__clean_up for information on how to locate and cleanup the duplicate information.