BPM 12.1.3: ORA-02291: integrity constraint (BPM_SOAINFRA.FI_SCA_ENTITY_FK) violated - parent key not found (Doc ID 2694427.1)

Last updated on MAY 15, 2023

Applies to:

Goal

On : 12.1.3.0.0 version, Orchestration Engine

BPM 12.1.3: Unable to initiate process

Properly working BPM Process suddenly fails to initialize with errors below.

Message handle error.
error while attempting to process the message "com.collaxa.cube.engine.dispatch.message.audit.AbortInstanceItMessage"; the reported exception is: JTA transaction unexpectedly rolled back (maybe due to a timeout); nested exception is weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizationListener@1f12d00a

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (BPM_SOAINFRA.FI_SCA_ENTITY_FK) violated - parent key not found

Error Code: 2291
Call: INSERT INTO SCA_FLOW_INSTANCE (FLOW_ID, ACTIVE_COMPONENT_INSTANCES, ADMIN_STATE, COMPOSITE_SCA_ENTITY_ID, CONVERSATION_ID, FLOW_CORRELATION_ID, CREATED_BY, CREATED_TIME, ECID, PROPERTIES, PURGEABLE, RECOVERABLE_FAULTS, RESEQUENCER, SCA_PARTITION_ID, TENANT_ID, TEST_CASE, TEST_RUN_ID, TEST_RUN_NAME, TEST_SUITE, TITLE, UNHANDLED_FAULTS, UPDATED_BY, UPDATED_TIME, VERSION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [6190016, 0, -1, 10203, null, 0000NDI_dpMCcpm5kr9DiZ1V3jZT00000G, anonymous, 2020-07-15 09:07:49.206, 2daa23cc-8284-4bca-a6d1-b2c6e54d0e28-000042ac, null, null, 0, false, 1, -1, null, null, null, null, null, 0, anonymous, 2020-07-15 09:07:49.222, 1]
 

Solution

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