ORA-02291 Error During Execution of BPEL Workflows (Doc ID 1277951.1)

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:

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 server] [ERROR] [] [oracle.soa.services.workflow.common] [tid: orabpel.invoke.pool-4.thread-1] [userId: <anonymous>] [ecid: ] [APP: soa-infra] [composite_name: <name>] [component_name:<name>] [component_instance_id: nnnnn] [composite_instance_id: nn] <.> 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 (schema.SYS_Cnnnnn) violated - parent key not found
...
[2010-12-06T01:45:01.452-08:00] [soa server] [ERROR] [] [oracle.soa.services.workflow.soa] [tid: orabpel.invoke.pool-4.thread-1] [userId: <anonymous>] [ecid:  ] [APP: soa-infra] [composite_name: <name>] [component_name:<name>_HumanTask] [component_instance_id: ] [composite_instance_id: nn] <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 (xxx_SOAINFRA.SYS_Cnnnnn) 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 in the AP Solution Accelerator.  But the issue could be seen with any BPEL process initiating a BPM Human Task.

Changes

Cause

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