BPEL Flow Results In A Unique Constraint (FTCA_SCA_ENTITY_FK) Violated - Parent Key Not Found

(Doc ID 2322471.1)

Last updated on NOVEMBER 03, 2017

Applies to:

Oracle SOA Suite - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

Goal

QUESTION#1

BPEL is failing with ORA-02291: integrity constraint (SIT2_SOAINFRA.FTCA_SCA_ENTITY_FK) violated - parent key not found error.

#### <WLS_SOA1> <[ACTIVE] ExecuteThread: '43' for queue: 'weblogic.
kernel.Default (self-tuning)'> <> <> <[severity-value: 32
] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > TA transaction unexpectedly rolled back (maybe due to a timeout); nested exception is weblogic.transaction.RollbackException: Unexpe
cted exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizationListener@feebc01

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (SIT2_SOAINFRA.FTCA_SCA_ENTIT
Y_FK) violated - parent key not found

Error Code: 2291
Call: INSERT INTO SCA_FLOW_TO_CPST (COMPOSITE_ID, ACTIVE_COMPONENT_INSTANCES, ADMIN_STATE, COMPOSITE_SCA_ENTITY_ID, CREATED_TIME, FL
OW_ID, PARTITION_DATE, SCA_PARTITION_ID, TENANT_ID, TITLE, UPDATED_TIME, VERSION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  bind => [3861318, 0, -1, 86, 2017-10-25 16:33:38.365, 34002, 2017-10-15 16:17:13.775, 6, 0, null, 2017-10-25 16:33:38.365, 1
]>
 QUESTION#1

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms