TM 'Alignment - Periodic Runs' Workflow - Constant 10 Sec gap In Constructing 'Batch Job' BusComp (Doc ID 1624419.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Territory Management - Version 8.1.1.5 SIA [21229] and later
Information in this document applies to any platform.

Goal

We set up to run vanilla 'Alignment - Periodic Runs' workflow process as RCRs.
The alignments have Affiliation Object.

While running 'Alignment - Periodic Runs' workflow, we are facing very slow performance. 6-7 hours are taken by one recurring job to complete one instance for a small set of records.

The WfProcMgr log for 'Alignment - Periodic Runs' constants 10 Sec jumps/gaps in constructing 'Batch Job' BusComp:

StpExec Task 4 0000028c52314001:0 2013-09-12 14:50:25 Invoking method 'Update Tasks Status' on business service 'Alignment Management Service'.
StpExec TaskArg 4 0000028c52314001:0 2013-09-12 14:50:25 Input: @0*1*1*1*0*0*10*Sleep Time1*14*0*12*TOS Task Ids0*8*1-1NG7MR6*ACTIVE8*1-1NG7LB6*ACTIVE8*1-1NG7L96*ACTIVE8*1-1NG7MT7*SUCCESS
ObjMgrBusServiceLog InvokeMethod 4 0000028c52314001:0 2013-09-12 14:50:25 Begin: Business Service 'Alignment Management Service' invoke method: 'Update Tasks Status' at c1e3b70
ObjMgrBusCompLog Create 4 0000028c52314001:0 2013-09-12 14:50:35 Begin: construct BusComp "Batch Job" at 8f9b5b0
ObjMgrBusCompLog Create 4 0000028c52314001:0 2013-09-12 14:50:35 End: construct BusComp "Batch Job" at 8f9b5b0
ObjMgrSqlObjLog Search 5 0000028c52314001:0 2013-09-12 14:50:35 Beg


StpExec Create 4 0000028c52314001:0 2013-09-12 14:50:35 Instantiating step definition 'Get TOS Tasks Status'.
StpExec Task 4 0000028c52314001:0 2013-09-12 14:50:35 Invoking method 'Update Tasks Status' on business service 'Alignment Management Service'.
StpExec TaskArg 4 0000028c52314001:0 2013-09-12 14:50:35 Input: @0*1*1*1*0*0*10*Sleep Time1*14*0*12*TOS Task Ids0*8*1-1NG7MR6*ACTIVE8*1-1NG7LB7*SUCCESS8*1-1NG7L97*SUCCESS8*1-1NG7MT7*SUCCESS
ObjMgrBusServiceLog InvokeMethod 4 0000028c52314001:0 2013-09-12 14:50:35 Begin: Business Service 'Alignment Management Service' invoke method: 'Update Tasks Status' at c1e3b70
ObjMgrBusCompLog Create 4 0000028c52314001:0 2013-09-12 14:50:45 Begin: construct BusComp "Batch Job" at 8f9b5b0
ObjMgrBusCompLog Create 4 0000028c52314001:0 2013-09-12 14:50:45 End: construct BusComp "Batch Job" at 8f9b5b0
ObjMgrSqlObjLog Search 5 0000028c52314001:0 2013-09-12 14:50:45 Begin: SetSearchSpec for SqlObj 'Batch Job' at 98d0118, Search Spec: ''
ObjMgrSqlObjLog Search 5 0000028c52314001:0 2013-09-12 14:50:45 End: Se

Note, there are 10 second gaps between 2013-09-12 14:50:25 and 2013-09-12 14:50:35, 2013-09-12 14:50:35 and 2013-09-12 14:50:45 in the above.

Require your support to identify the root cause and resolution.
 

Solution

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