My Oracle Support Banner

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

Last updated on MARCH 01, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.