ORA-02291: integrity constraint (IDTMANAGER.FK_EVENT_OBJECT12_5_EVENT12_5) violated - parent key not found

Products

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

Issue/Introduction

IDM has stopped processing requests throwing the below error:

Caused by: Error : 2291, Position : 0, Sql = insert into event_object12_5 (tasksessionid,eventid,object_type,isprimary,object_uniquename)values (:1 ,:2 ,:3 ,:4 ,:5 ), OriginalSql = insert into event_object12_5 (tasksessionid,eventid,object_type,isprimary,object_uniquename)values (?,?,?,?,?), Error Msg = ORA-02291: integrity constraint (IDTMANAGER.FK_EVENT_OBJECT12_5_EVENT12_5) violated - parent key not found

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) [ojdbc8.jar:]
    ... 73 more

12:37:12,750 ERROR [ims.tmt.persistence] (http-/10.202.12.24:8080-7) PersistenceProvider: http-/##.##.###.##:8080-7: saveEvent: exception saving event: ORA-02291: integrity constraint (IDTMANAGER.FK_EVENT_OBJECT12_5_EVENT12_5) violated - parent key not found
: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (IDTMANAGER.FK_EVENT_OBJECT12_5_EVENT12_5) violated - parent key not found

Environment

Release : 14.X

Component : IdentityMinder(Identity Manager)

Cause

The oracle database tables and primary key do not have auto-increment enabled and have completely filled up.

Resolution

Enable more disk space and configure auto-increment against the tables and primary keys.