My Oracle Support Banner

DB Connection Pooling Causing Inactive Blocking Database Sessions and Application CRASH (Doc ID 1421011.1)

Last updated on APRIL 30, 2018

Applies to:

Siebel CRM - Version 8.2.2.3 SIA [23021] and later
Information in this document applies to any platform.

Symptoms

---------------
Some INSERT INTO statements executed on Siebel CRM tables (e.g. the S_AUDIT_ITEM table) are taking too much time to complete, this is an intermitent issue since not all INSERT INTO statements executed on this table show poor performance.

In certain cases Siebel Object Manager crashes.

Example of the call stack at the crash (Windows OS, EAI Object Manager task was executing Integration Workflow Process that implements   a Siebel Inbound Web Service of Siebel Loyalty ):

- CALL STACK -
ntdll +0xb3d6f = RtlpNotOwnerCriticalSection() +0x83
ntdll +0x4a14 = RtlFindMessage() +0x312
sscfcmn +0x8f4a = CSSInternetFile::SetOption() +0x3ca
sscfdm +0xd1bdb = CSSDbLock::~CSSDbLock() +0x1b
sscfdm +0xcf533 = CSSSqlCursor::Close() +0x263
sscfdm +0xcf705 = CSSDbConn::CacheSqlCursor() +0x175
sscfdm +0xd120a = CSSDbConn::TryCacheSqlCursor() +0x2a
sscfdm +0xe8985 = CSSSqlObj::CacheSqlCursor() +0x215
sscfdm +0x10c771 = CSSSqlObj::Release() +0x391
sscfom +0x5298f = CSSBusComp::~CSSBusComp() +0x61f
SSCACMBC +0x14b27 = CSSBCBase::~CSSBCBase() +0x857
sscalyapbc +0x29120 = CSSBCLOYBase::~CSSBCLOYBase() +0xc0
sscalyapbc +0x36aa5 = CSSBCLOYBase::SqlSetFieldValue() +0xa25
sscfom +0x1ead8 = CSSBusComp::Release() +0x28
sscafwsv +0x27ac5 = CSSWfTaskLocalVsnCache::~CSSWfTaskLocalVsnCache() +0x165
sscafwsv +0x1af74 = CSSWfEngine::DoInvokeMethod() +0x26c4
sscafwsv +0x11649 = CSSWfEngine::DelProcInst() +0xe9
sscafwsv +0x119ce = CSSWfEngine::FreePrcInstLst() +0x1be
sscafwsv +0x14dc1 = CSSWfEngine::PostCleanup() +0x141
sscafwsv +0x17d96 = CSSWfEngine::RunSingleProcess() +0x766
sscafwsv +0x181f4 = CSSWfEngine::StartProcess() +0x3e4
sscafwsv +0x1aa12 = CSSWfEngine::DoInvokeMethod() +0x2162
sscfom +0x18c7c = CSSService::InvokeMethod() +0x24c
sscaeiwm +0x11c9e = siebel_webservices::Operation::Process() +0x40e
sscaeiwm +0x11943 = siebel_webservices::Operation::Process() +0xb3
sscaeiwm +0xdeac = siebel_webservices::InboundPort::ExecuteSoapRequest() +0x20c
SSCAEIWD +0x77d3 = CSSWSInboundDispatcher::DoInvokeMethod() +0x4d3
sscfom +0x18c7c = CSSService::InvokeMethod() +0x24c
sscaeitd +0x25c5 = EAITranspDispatcher::Invoke() +0x2a5
SSCAEIRD +0x24b8 = CSSEAITransDispatchService::GenericDispatch() +0x118
SSCAEIRD +0x2760 = CSSEAITransDispatchService::DoInvokeMethod() +0x70
sscfom +0x18c7c = CSSService::InvokeMethod() +0x24c
SSCASWBC +0x242f50 = CSSSWEExtServiceMgr::ProcessRequest() +0xc0
SSCASWBC +0x24ca96 = CSSServiceSWEIface::ProcessExtSRequest() +0x336
SSCASWBC +0x24de8c = CSSServiceSWEIface::DoInvokeMethod() +0xe0c
sscfom +0x18c7c = CSSService::InvokeMethod() +0x24c
sstcsiom +0x6d6a = CSSSIOMSession::ModInvokeSrvcMethod() +0x10a
sstcsiom +0x7613 = CSSSIOMSession::RPCMiscModel() +0x513
sstcsiom +0xe859 = CSSSIOMSession::HandleRPC() +0x369
sssasos +0x65e6 = CompCleanup() +0x3bb6
sssasos +0x5a95 = CompCleanup() +0x3065
sssasos +0x1a35 = CSSSISObject::operator=() +0x9f5
sssasos +0x2135 = CompHandleMsg() +0x485
siebmtshmw +0x494e
siebmtshmw +0x20051 = GetSmiTaskAPI() +0x6d21
siebmtshmw +0x239d1 = SmiInProcMsgHandler() +0x2051
siebmtshmw +0x15f15 = SmiBeginTrace() +0x3195
siebmtshmw +0x174cf = GetSmiWorkQObj() +0x148f
siebmtshmw +0xc7f7 = SmiCleanupDetTask() +0x3be7
sslcosd +0x2132 = OSDThreadPrivIsInit() +0x1d2

 

Sample FDR traces to the crash/call stack from above:

...,"AreaSymbol","AreaDesc","SubAreaSymbol","SubAreaDesc","UserInt1","UserInt2","UserStr1","UserStr2"

...,Fdr_DBC,Database Connector,FdrSub_DBC_CURSOR_CNST,Sql Cursor Construction,470406984,98748568,"",""

...,Fdr_WORKFLOW,WorkFlow,FdrSub_WORKFLOW_STEP_NAME,Step Name,0,0,"End 0","#WF Step Name#"
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_SVC_DSTR,BusSvc Destruction,430035000,0,"FINS Industry XML Query Service",""
...,Fdr_SCRIPT,Generic Scripting Engine,FdrSub_SCRIPT_FREE,Object Deallocation,269265784,469936200,"",""

...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_BC_DSTR,BusComp Destruction,480335360,0,"Order Entry - Orders",""
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_BC_EMPTY_WS,BusComp Empty WorkSet,480335360,0,"Order Entry - Orders",""
...
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_CACHE_SQLOBJ,Cache SqlObj,546980440,0,"Order Entry - Line Items",""
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_DATA_LST_DSTR,Data List Destruction,472945432,1,"",""
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_CACHE_SQLOBJ,Cache SqlObj,546986088,0,"Order Entry - Orders",""
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_BO_DSTR,BusObj Destruction,563821264,0,"Order Entry",""
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_BC_DSTR,BusComp Destruction,480336840,0,"rder Entry - Line Items",""
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_BC_EMPTY_WS,BusComp Empty WorkSet,480336840,0,"Order Entry - Line Items",""
...,,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_SQLOBJ_RELEASE,SqlObj Release,547000208,0,"Order Entry - Line Items",""
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_DATA_LST_DSTR,Data List Destruction,472949240,0,"",""
...,Fdr_DBC,Database Connector,FdrSub_DBC_CURSOR_DSTR,Sql Cursor Destruction,432493592,0,"",""
...
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_SVC_INVOKE,Service Invoke Method,563808944,0,"State Model Cache","#UnLoad#"
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_BC_DSTR,BusComp Destruction,553103432,0,"LOY Transaction",""
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_BC_EMPTY_WS,BusComp Empty WorkSet,553103432,0,"LOY Transaction",""
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_BC_REC_DSTR,WorkSet Record Destruction,553103432,377927600,"LOY Transaction",""
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_SQLOBJ_RELEASE,SqlObj Release,429047984,0,"LOY Transaction",""
...,Fdr_OBJMGR,Object Manager,FdrSub_OBJMGR_DATA_LST_DSTR,Data List Destruction,387875616,1,"",""
...,Fdr_FDR,Fdr Internal,FdrSub_FDR_CRASH,** CRASHING THREAD **,0,0,"",""

 


EXPECTED BEHAVIOR
-----------------------
All INSERT INTO statements executed on Siebel CRM Tables table should show a consistent and acceptable performance.

No Siebel Object Manager crashes occur.

Changes

Siebel DB Connection Pooling was enabled in the customer's environment

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.