My Oracle Support Banner

Workflow Is Ended From Workflow Manager But Wf_process_log Is Not Updated Shows Status of 1 (Doc ID 2416810.1)

Last updated on JUNE 28, 2018

Applies to:

Oracle Demantra Demand Management - Version 12.2.6.2 and later
Information in this document applies to any platform.

Symptoms

Customer has upgraded to 12.2.6.2
Post upgrade they see that some workflows are completing on the front end but not in backend as the wf_process_log shows the staus of 1 They are submitting a particular method from Worksheet and this method is launching a wrapper Workflow from their main Workflow
The Main Workflow and the wrapper one is completed from front end after few minutes but in wf_process_log for the particular process_id status remain 1. The workflow manager shows it as completed. The workflow also is doing what it is supposed to do.

Verified that the following parameters are correct

AppServerURL

server.generalurl

All queues are valid

  OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY NAMESPACE EDITION_NAME SHARING EDITIONABLE ORACLE_MAINTAINED
1 DEM_APPSERV_IN 4117082 4117082 TABLE 12/20/2017 17:31 12/20/2017 17:31 2017-12-20:17:31:16 VALID N N N 1 NONE N
2 DEM_APPSERV_OUT 4117104 4117104 TABLE 12/20/2017 17:31 12/20/2017 17:31 2017-12-20:17:31:18 VALID N N N 1 NONE N
3 DEM_APPSERV_IN_Q_R 4117102 RULE SET 12/20/2017 17:31 12/20/2017 17:31 2017-12-20:17:31:18 VALID N N N 23 NONE N
4 DEM_APPSERV_IN_Q_N 4117103 RULE SET 12/20/2017 17:31 12/20/2017 17:31 2017-12-20:17:31:18 VALID N N N 23 NONE N
5 DEM_APPSERV_IN_Q 4117101 QUEUE 12/20/2017 17:31 1/12/2018 17:21 2018-01-12:17:21:10 VALID N N N 10 NONE N
6 DEM_APPSERV_OUT_Q_R 4117124 RULE SET 12/20/2017 17:31 12/20/2017 17:31 2017-12-20:17:31:19 VALID N N N 23 NONE N
7 DEM_APPSERV_OUT_Q_N 4117125 RULE SET 12/20/2017 17:31 12/20/2017 17:31 2017-12-20:17:31:19 VALID N N N 23 NONE N
8 DEM_APPSERV_OUT_Q 4117123 QUEUE 12/20/2017 17:31 1/12/2018 17:21 2018-01-12:17:21:10 VALID N N N 10 NONE N

No errors in the collaborator logs


Have also truncated the wf_process_log. Bounced the application
But the issue persists

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.