ORA-02291 Error During Execution of BPEL Workflows

(Doc ID 1277951.1)

Last updated on JULY 28, 2016

Applies to:

Oracle SOA Platform - Version 11.1.1.3.0 and later
Oracle WebCenter Content: Imaging - Version 11.1.1.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 16-August-2013***

Symptoms

You have implemented a BPEL process which initiates a BPM Human Task. But during the execution of this BPEL process, you see the following fault when the human task is initiated:

<bpelFault>
   <faultType>1</faultType>
   <operationErroredFault xmlns="http://xmlns.oracle.com/bpel/workflow/taskService">
      <part name="payload">
         <operationErroredFault xmlns="http://xmlns.oracle.com/bpel/workflow/taskService">    <faultInfo>java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (xxx_SOAINFRA.SYS_C0011588) violated - parent key not found </faultInfo>
         </operationErroredFault>
      </part>
   </operationErroredFault>
</bpelFault>


The full text of the error seen in the soa_server log files is as follows:

[2010-12-06T01:45:01.436-08:00] [soa_server1] [ERROR] [] [oracle.soa.services.workflow.common] [tid: orabpel.invoke.pool-4.thread-1] [userId: <anonymous>] [ecid: 0000ImiL6dL5Qd^5xVS4yW1CxV1I000^IU,0:7:0x5f5e100:68:3:0x5f5e101:131:3:100000120] [APP: soa-infra] [composite_name: InvoiceProcessing] [component_name: InvoiceProcessing_HumanTask] [component_instance_id: 200118] [composite_instance_id: 3] <.> Error while updating task .[[
Error while updating task {0}.
Check the underlying exception and the database connection information. If the error persists, contact Oracle Support Services.
ORABPEL-10101

Error while updating task .
Error while updating task {0}.
Check the underlying exception and the database connection information. If the error persists, contact Oracle Support Services.
...
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (AP_SOAINFRA.SYS_C0011588) violated - parent key not found
...
[2010-12-06T01:45:01.452-08:00] [soa_server1] [ERROR] [] [oracle.soa.services.workflow.soa] [tid: orabpel.invoke.pool-4.thread-1] [userId: <anonymous>] [ecid: 0000ImiL6dL5Qd^5xVS4yW1CxV1I000^IU,0:7:0x5f5e100:68:3:0x5f5e101:131:3:100000120] [APP: soa-infra] [composite_name: InvoiceProcessing] [component_name: InvoiceProcessing_HumanTask] [component_instance_id: ] [composite_instance_id: 3] <WorkflowServiceEngine.request> Operation 'initiateTask' failed with WorkflowException 'Error while updating task .[[
Error while updating task {0}.
Check the underlying exception and the database connection information. If the error persists, contact Oracle Support Services.
', throwing BusinessFault with message:
---------------------------------------------------------------
NormalizedMessage Headers:

---------------------------------------------------------------
NormalizedMessage Properties:

---------------------------------------------------------------
NormalizedMessage Payload:
payload:
<operationErroredFault xmlns="http://xmlns.oracle.com/bpel/workflow/taskService">
<faultInfo>java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (AP_SOAINFRA.SYS_C0011588) violated - parent key not found
</faultInfo>
</operationErroredFault>

xxx_SOAINFRA is the SOA schema created using RCU 11.1.1.3.

It should be noted that this issue was seen during execution of BPEL Workflows (eg. InvoiceProcessing) in the AP Solution Accelerator.  But the issue could be seen with any BPEL process initiating a BPM Human Task.

Cause

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