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

Last updated on AUGUST 25, 2017

Applies to:

Oracle SOA Suite - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms