T3: AIA 12C: Integrity Constraint Error On MEDIATOR_RESEQUENCER_MESSAGE (Doc ID 2301126.1)

Last updated on MAY 25, 2019

Applies to:

Symptoms

Resequencer failed to store the messages in MEDIATOR_RESEQUENCER_MESSAGE table due to the following exception:

============================
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160526-8f41838): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (SA_SOAINFRA.MEDIATOR_GROUP_STATUS_FK1) violated - parent key not found

Error Code: 2291
Call: Insert into MEDIATOR_RESEQUENCER_MESSAGE (ID,OWNER_ID,COMPONENT_DN,OPERATION,LEVEL_DETAIL2,GROUP_ID,SEQUENCE_ID, CREATION_DATE,NEXT_SEQUENCE_ID, SOURCE_URI,STANDARD_SEQUENCE_ID,STATUS,INSTANCE_CREATED,property1,property2,DUMMY1,FLOW_ID,SCA_PARTITION_ID,PARTITION_DATE) values (?,?,?,?,?,?,?, systimestamp at time zone 'UTC',?,?,?,?,?,?,?,?,?,?,?)
bind => [18 parameters bound]
Query: DataModifyQuery(name="InsertMediatorResequencerMessageObject" sql="Insert into MEDIATOR_RESEQUENCER_MESSAGE (ID,OWNER_ID,COMPONENT_DN,OPERATION,LEVEL_DETAIL2,GROUP_ID,SEQUENCE_ID, CREATION_DATE,NEXT_SEQUENCE_ID, SOURCE_URI,STANDARD_SEQUENCE_ID,STATUS,INSTANCE_CREATED,property1,property2,DUMMY1,FLOW_ID,SCA_PARTITION_ID,PARTITION_DATE) values (?,?,?,?,?,?,?, systimestamp at time zone 'UTC',?,?,?,?,?,?,?,?,?,?,?)")
===================

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.