Exception inserting into imsAuditEvent12: Event: ViewUserEvent message: ORA-00001: unique constraint (IAMAUDIT.PK_01_EVTOBJ12) violated

Products

• CA Identity Manager

Issue/Introduction

The following messages are seen in the Identity Manager application server log.

Exception inserting into imsAuditEvent12: Event: ViewUserEvent message: ORA-00001: unique constraint (IAMAUDIT.PK_01_EVTOBJ12) violated.

09:08:37,235 ERROR [ims.audit] Exception inserting into imsAuditEvent12: Event: ViewUserEvent message: ORA-00001: unique constraint (IAMAUDIT.PK_01_EVTOBJ12) violated
ORA-06512: at "IAMAUDIT.INSERTIMSAUDITEVENTOBJECT125", line 11
ORA-06512: at line 1
 
09:08:37,235 ERROR [ims.audit] Auditing failed with exception [ ORA-00001: unique constraint (IAMAUDIT.PK_01_EVTOBJ12) violated
ORA-06512: at "IAMAUDIT.INSERTIMSAUDITEVENTOBJECT125", line 11
ORA-06512: at line 1

 

Cause

The constraint PK_01_EVTOBJ12 is the Primary Key for the imsAuditEventObject12 table (often residing in the IAMAUDIT schema). This error occurs when the sequence used to generate IDs for new audit events has fallen behind the actual maximum ID in the table, leading to attempts to insert duplicate primary keys.

The sequence  hit its maximim value and then tries to recycle the sequence number by starting over again.

However, the number it was trying to use was already in use and returns the error.

Resolution

Contact your database administrator to investigate the above errors.

The issue can be resolved by resetting the appropriate sequence value.