ORA-02291: Integrity Constraint (OTC_SOAINFRA.MEDIATOR_GROUP_STATUS_FK1) Violated (Doc ID 2584560.1)

Last updated on MAY 15, 2023

Applies to:

Symptoms

On : 12.2.1.1.0 version, Fabric

ORA-02291: integrity constraint (SOAINFRA.MEDIATOR_GROUP_STATUS_FK1) violated


ERROR
-----------------------

Error Log:
Message failed to post default/UpdateItemEbizEventConsumer!1.0/UpdateItemEbizEventConsumer_RS/DEQUEUE
Supplemental Detail oracle.tip.resequencer.infra.exception.ResequencerException: ORARES-04001:[Error persisting resequencer message due to internal Error.]Error persisting resequencer message,"default/UpdateItemEbizEventConsumer!1.0/UpdateItemEbizEventConsumer_RS/DEQUEUE" , due to internal Error.. Reason : {1}Possible Fix:Check log file for any exceptions and contact Oracle Support Services for further help.


nternal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (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.