Cleanup Submitted Tasks fail to move tasks to archive DB

Products

• CA Identity Manager

Issue/Introduction

Getting the following error while running cleanup submitted tasks

Error during CleanupSubmittedTasksEvent.longRunningEventExecute: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (IAMARCHIVE.PK_ARCH_RUNTIMESTATUSDETAIL12) violated

 

Environment

Standalone Identity Manager 14.5.1 CHF2

Cause

Duplicated ID between table runtimestatusdetail12  and archive_runtimestatusdetail12

Resolution

1) DELETE FROM archive_runtimestatusdetail12 WHERE id = DuplicatedIDFound;

2) Rerun Cleanup Submitted Tasks