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

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

book

Article ID: 250926

calendar_today

Updated On:

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 enviroment

Resolution

Recreate the archive DB