T3: AIA 12C: Integrity Constraint Error On MEDIATOR_RESEQUENCER_MESSAGE
(Doc ID 2301126.1)
Last updated on MAY 25, 2019
Applies to:
Oracle SOA Suite - Version 12.2.1.1.0 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |