ORA-02291: Integrity Constraint,parent Key Not Found Error Code: 2291 Call: Insert Into MEDIATOR_RE
(Doc ID 2494061.1)
Last updated on MAY 10, 2023
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 |