My Oracle Support Banner

ORA-02291: Integrity Constraint,parent Key Not Found Error Code: 2291 Call: Insert Into MEDIATOR_RE (Doc ID 2494061.1)

Last updated on JUNE 15, 2020

Applies to:

Oracle SOA Suite - Version 12.2.1.3.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

On : 12.2.1.3.0 version, Fabric

While using a composite with mediator, execution after running a purge is throwing the error as below.
ORA-02291: integrity constraint (OPS_SOAINFRA.MEDIATOR_GROUP_STATUS_FK1) violated - parent key not found


ERROR
-----------------------
Got an exception: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (OPS_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 = 4

Changes

 

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
Changes
Cause
Solution
References


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