Workflow Job Fails with ORA-20003 and WFENG_COMMIT_INSIDE

(Doc ID 1604634.1)

Last updated on AUGUST 15, 2017

Applies to:

Oracle Life Sciences Data Hub - Version 2.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Define a Workflow with one PLSQL sub-program.  Within the Workflow, set up Parameter value propagation
so that Parameters contained in the PLSQL sub-program can receive its values automatically from the Workflow.
Submit the workflow job using Message-Triggered Submission.

The Workflow job fails with the following error message in the job log:

Error Code: ORA-20003:: Error Description:  : Error occured during
workflow(1799) Execution. Please check Workflow Monitor for more Details.
DEBUG MESSAGE FROM OWB/CDR DB Server-WF Operator: User defined program
returned Failure...
Execution Status : Failed :: Job Status: Failure :: 08-23-2013 09:32:11

Error Code: ORA-20003:: Error Description:  : Error occured during
workflow(1799) Execution. Please check Workflow Monitor for more Details.

Workflow Monitor shows the following error:

Error Activity ID: 290324
Error Activity Label: 1799:183640001_6
Error Item Type:  1799
Error Item Key: WB_IK_20130813_135536_18005810_1799
Error Message  3146: Commit happened in activity/function
'1799:183640001_6/WB_RT_WORKFLOW_UTIL_11G.EXECUTE_TASK'

Error Name:  WFENG_COMMIT_INSIDE

Error Stack  WB_RT_WORKFLOW_UTIL_11G.Execute_Any_Task(3716,
WB_IK_20130813_135536_18005810_1799, 290324, RUN)
WB_RT_WORKFLOW_UTIL_11G.Execute_Task(1799,
WB_IK_20130813_135536_18005810_1799, 290324, RUN)
Wf_Engine_Util.Function_Call(WB_RT_WORKFLOW_UTIL_11G.EXECUTE_TASK, 1799,
WB_IK_20130813_135536_18005810_1799, 290324, RUN)
 

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