Demantra Workflow With Procedure Step and Recovery Abort Took 3 Hours To Terminate Upon A Failed Step
Last updated on MAY 08, 2017
Applies to:Oracle Demantra Predictive Trade Planning - Version 12.2.4 and later
Information in this document applies to any platform.
Customer is looking for a way to set the timeout for a workflow that has a stored procedure step and fails due to a legitimate error
Customer had a situation that one of the settlement with split had a value with 257 characters on one of the field and the workflow returned with the following error.
FATAL workflow.general: ORA-12899: value too large for column "DEMANTRA"."CSTM_TPR_DEDUCTION_BRAND"."SETTLEMENTKEY" (actual: 257, maximum: 255)
The above was a legitimate error
The issue was that the Workflow has Recovery option as Abort but did not terminate the workflow. Instead it took 3 hours to terminate. Is there a way to set the workflow configuration on timeout to end the workflow step within 5 minutes or as soon as the step fails.
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