Error Invoking Method "ResumeInstance" For Business Service "Workflow Process Manager" (Doc ID 1914513.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Call Center - Version 8.0.0.12[20444] and later
Information in this document applies to any platform.

Symptoms

On : 8.0.0.12[20444] version, Siebel Workflow

The main workflow process has a sub process step that has a Wait step for waiting 5 days:
Step Name: Wait for 5 Days
Business Service: Workflow Utilities
Method: Sleep

When attempting to resume from sub process after waiting for 5 days following is observed:

ObjMgrBusServiceLog InvokeMethod 4 000005bf53490b8c:0 2014-04-23 13:52:17 Begin: Business Service 'Workflow Process Manager' invoke method: 'ResumeInstance' at 12be7008

EngInv EngInv 3 000005bf53490b8c:0 2014-04-23 13:52:17 Workflow engine requested to perform method 'ResumeInstance'.

EngInv Arg 4 000005bf53490b8c:0 2014-04-23 13:52:17 Input: @0*0*1*0*0*0*17*ProcessInstanceId8*1-CICDGG

The Workflow Process Manager component crashes at executing any SQL, not a particular SQL, and fails to resume.

The following errors occur and crash.txt for call stack are generated:

ERROR
-----------------------

ObjMgrSqlLog Detail 4 000005bf53490b8c:0 2014-04-23 13:52:17 SELECT statement with ID: 1166A7E8
SELECT
  T1.CONFLICT_ID,
  T1.LAST_UPD,
  T1.CREATED,
  T1.LAST_UPD_BY,
  T1.CREATED_BY,
  T1.MODIFICATION_NUM,
  T1.ROW_ID,
  T1.EVT_DESCRIPTOR,
  T1.EVT_CORRLATION_VAL,
  T1.TYPE_CD,
  T1.WAIT_ID_VAL
  FROM
  SIEBEL.S_WFA_INST_WAIT T1
  WHERE
  (T1.WAIT_ID_VAL = :1 AND T1.TYPE_CD = :2)

ObjMgrSqlLog Detail 4 000005bf53490b8c:0 2014-04-23 13:52:17 Bind variable 1: 1-CICDGG

ObjMgrSqlLog Detail 4 000005bf53490b8c:0 2014-04-23 13:52:17 Bind variable 2: INST


ObjMgrLog Error 1 000005bf53490b8c:0 2014-04-23 13:52:17 (oracon.cpp (3273)) SBL-DBC-00108: An error has occurred preparing a Sql statement.**Please continue or ask your systems administrator to check your application configuration if the problem persists.

SQLParseAndExecute Execute 5 000005bf53490b8c:0 2014-04-23 13:52:17 ORA-03114: not connected to ORACLE


SQLParseAndExecute Statement 4 000005bf53490b8c:0 2014-04-23 13:52:17

UPDATE SIEBEL.S_WFA_INSTANCE SET
  DB_LAST_UPD_SRC = :1,
  LAST_UPD = :2,
  LAST_UPD_BY = :3,
  MODIFICATION_NUM = :4,
  EXEC_ENGINE_ID_VAL = :5,
  STATUS_CD = :6,
  DB_LAST_UPD = sysdate
  WHERE
  ROW_ID = :7 AND MODIFICATION_NUM = :8


SQLParseAndExecute Bind Vars 4 000005bf53490b8c:0 2014-04-23 13:52:17 1: Object Manager - Default

SQLParseAndExecute Bind Vars 4 000005bf53490b8c:0 2014-04-23 13:52:17 2: 04/23/2014 13:52:17

SQLParseAndExecute Bind Vars 4 000005bf53490b8c:0 2014-04-23 13:52:17 3: 0-1

SQLParseAndExecute Bind Vars 4 000005bf53490b8c:0 2014-04-23 13:52:17 4: 2

SQLParseAndExecute Bind Vars 4 000005bf53490b8c:0 2014-04-23 13:52:17 5: 1-CIJUNT

SQLParseAndExecute Bind Vars 4 000005bf53490b8c:0 2014-04-23 13:52:17 6: ACTIVE

SQLParseAndExecute Bind Vars 4 000005bf53490b8c:0 2014-04-23 13:52:17 7: 1-CICDGI

SQLParseAndExecute Bind Vars 4 000005bf53490b8c:0 2014-04-23 13:52:17 8: 1

SQLParseAndExecute Execute 5 000005bf53490b8c:0 2014-04-23 13:52:38 OCIStmtExecute: DML error or affected 0 rows

ObjMgrBusCompLog Error 1 000005bf53490b8c:0 2014-04-23 13:52:38 (oracon.cpp (3273)) SBL-DBC-00111: An error has occurred writing to a record.**Please continue or ask your systems administrator to check your application configuration if the problem persists.

SQLParseAndExecute Execute 5 000005bf53490b8c:0 2014-04-23 13:52:38 ORA-03135: connection lost contact


ObjMgrBusServiceLog InvokeMethod 4 000005bf53490b8c:0 2014-04-23 13:52:39 Business Service 'Workflow Process Manager' invoke method 'ResumeInstance' Execute Time: 22.191 seconds.

ObjMgrBusServiceLog InvokeMethod 4 000005bf53490b8c:0 2014-04-23 13:52:39 End: Business Service 'Workflow Process Manager' invoke method: 'ResumeInstance' at 12be7008

GenericLog GenericError 1 000005bf53490b8c:0 2014-04-23 13:52:39 Object manager error: ([0] An error has occurred writing to a record.

Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111) (0x76006f))

GenericLog GenericError 1 000005bf53490b8c:0 2014-04-23 13:52:39 Object manager error: ([1] ORA-03135: connection lost contact
(0x76006b))

GenericLog GenericError 1 000005bf53490b8c:0 2014-04-23 13:52:39 ( (0) err=2818155 sys=7733355) SBL-OMS-00107: Object manager error: ([1] ORA-03135: connection lost contact
(0x76006b))

GenericLog GenericError 1 000005bf53490b8c:0 2014-04-23 13:52:39 ( (0) err=2818155 sys=7733359) SBL-OMS-00107: Object manager error: ([0] An error has occurred writing to a record.

Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111) (0x76006f))

GenericLog GenericError 1 000005bf53490b8c:0 2014-04-23 13:52:39 (bsvcmgr.cpp (1356) err=2818251 sys=0) SBL-OMS-00203: Error 7733359 invoking method "ResumeInstance" for Business Service "Workflow Process Manager"

GenericLog GenericError 1 000005bf53490b8c:0 2014-04-23 13:52:39 (bsvcmgr.cpp (1224) err=2818251 sys=0) SBL-OMS-00203: Error 7733359 invoking method "ResumeInstance" for Business Service "Workflow Process Manager"


Crash call stack
-----------------------
Exception 0xc0000005 at 0x0c8644ac
Thread: 0x00001704, Process 0x00001650

- CONTEXT -
EIP: 0x00000000, EFL: 0x00010246, FS: 0x0000003b, GS: 0x00000000
CS: 0x0000001b, DS: 0x00000023, SS: 0x00000023, ES: 0x00000023
EAX: 0x004fc110, EBX: 0x00000000, ECX: 0x004fc10c, EDX: 0x03d8e160
ESI: 0x00000000, EDI: 0x00000001, EBP: 0x00000000, ESP: 0x03d8fff4

- CALL STACK -
sscafwsv +0x344ac = CSSWfStateBase::lfValidate() +0x2c
sscafwsv +0x10821 = CSSWfEngine::MaintainExcptnState() +0x221
sscafwsv +0x162d8 = CSSWfEngine::ResumeInstance() +0x888
sscafwsv +0x18e45 = CSSWfEngine::DoInvokeMethod() +0x875
sscfom +0x19583 = CSSService::InvokeMethod() +0x203
sssabsvm +0x29e2 = LessComparison::operator()() +0x1342
sssabsvm +0x414e = CreateSmiMThreadObj() +0xaae
siebmtshmw +0x1b8e9 = GetSmiTaskAPI() +0x1059
siebmtshmw +0x1bf83 = GetSmiTaskAPI() +0x16f3
siebmtshmw +0x1ca53 = GetSmiTaskAPI() +0x21c3
siebmtshmw +0x1db04 = GetSmiTaskAPI() +0x3274
siebmtshmw +0x1dec1 = GetSmiTaskAPI() +0x3631
siebmtshmw +0x172ac = SmiBeginTrace() +0x31cc
siebmtshmw +0x189eb = GetSmiWorkQObj() +0x15fb
siebmtshmw +0xd667 = SmiCleanupDetTask() +0x3d87
sslcosd +0x2152 = OSDThreadPrivIsInit() +0x1d2
sslcosd +0x21dc = OSDThreadPrivIsInit() +0x25c
MSVCR71 +0x9565 = endthreadex() +0xa0
kernel32 +0x2481f = GetModuleHandleA() +0xdf

This happens very frequently, over hundreds of failures a day.

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