Object Manager Crash in CSSSQLCURSOR::CLOSE() (Doc ID 1327335.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel System Software - Version 8.1.1.1 SIA [21211] to 8.1.1.6 SIA [21233] [Release V8]
Siebel CRM - Version 8.1.1.1 [21211] and later
Information in this document applies to any platform.

Symptoms

Object manager is crashing with the following consistent call stack:

/app/siebel/siebsrvr/lib/libsscfdm.so(CSSSqlCursor::Close()+0x27a)[0x4448336a]
/app/siebel/siebsrvr/lib/libsscfdm.so(CSSDbConn::CacheSqlCursor(CSSSqlCursor*)+0x383)[0x44477cb3]
/app/siebel/siebsrvr/lib/libsscfdm.so(CSSDbConn::CachePendingCursors()+0x150)[0x44478ec0]
/app/siebel/siebsrvr/lib/libsscfdm.so(CSSLockDbConn::Unlock(CSSModelPhysDef*)+0x8d)[0x44472d3d]
/app/siebel/siebsrvr/lib/libsscfdm.so(CSSDbLock::Unlock()+0x43)[0x44472313]
/app/siebel/siebsrvr/lib/libsscfdm.so(CSSDbLock::~CSSDbLock()+0x1f)[0x4447222f]
/app/siebel/siebsrvr/lib/libsscfdm.so(CSSLockSqlCursor::DoExecuteStmt(CSSBindVarArray*)+0x111)[0x444822d1]
/app/siebel/siebsrvr/lib/libsscfdm.so(CSSSqlCursor::Execute(CSSBindVarArray*)+0xbd)[0x4448356d]
/app/siebel/siebsrvr/lib/libsscfdm.so(CSSSqlObj::Execute(int, int, int)+0x1832)[0x44508732]
/app/siebel/siebsrvr/lib/libsscfom.so(CSSBusComp::SqlExecute(int, int, int)+0x4e)[0x440e842e]

 
In the detailed object manager log file, the following information is logged:
 

ObjMgrSqlCursorLog Trace 5 000000584dd6151e:0 2011-05-20 12:26:12 SQL cursor cache: Removed cursor from cache: Database connection ID:A383E10 Cursor ID: 74C990D8 Current number of cursors in cache: 15 Maximum number of cursors allowed in cache: 16
ObjMgrSqlCursorLog Trace 5 000000584dd6151e:0 2011-05-20 12:26:12 SQL cursor cache: Added cursor to cache: Database connection ID:A383E10 Cursor ID: C1EE2F8 Current number of cursors in cache: 16 Maximum number of cursors allowed in cache: 16
ObjMgrSqlCursorLog Delete 5 000000584dd6151e:0 2011-05-20 12:26:12 Sql Cursor Object was deleted at 74c990d8
ObjMgrSqlCursorLog Trace 5 000000584dd6151e:0 2011-05-20 12:26:12 End: Cache Sql Cursor at c1ee2f8
ObjMgrSqlCursorLog Trace 5 000000584dd6151e:0 2011-05-20 12:26:12 Begin: Cache Sql Cursor at baa33e0
ObjMgrSqlCursorLog Close 5 000000584dd6151e:0 2011-05-20 12:26:12 Begin: Close Sql Cursor at baa33e0
Removed cursor from cache: Database connection ID:A383E10 Cursor ID: 74C990D8 Current number of cursors in cache: 15 Maximum number of cursors allowed in cache: 16
ObjMgrSqlCursorLog Trace 5 000000584dd6151e:0 2011-05-20 12:26:12 SQL cursor cache: Added cursor to cache: Database connection ID:A383E10 Cursor ID: C1EE2F8 Current number of cursors in cache: 16 Maximum number of cursors allowed in cache: 16
ObjMgrSqlCursorLog Delete 5 000000584dd6151e:0 2011-05-20 12:26:12 Sql Cursor Object was deleted at 74c990d8
ObjMgrSqlCursorLog Trace 5 000000584dd6151e:0 2011-05-20 12:26:12 End: Cache Sql Cursor at c1ee2f8
ObjMgrSqlCursorLog Trace 5 000000584dd6151e:0 2011-05-20 12:26:12 Begin: Cache Sql Cursor at baa33e0
ObjMgrSqlCursorLog Close 5 000000584dd6151e:0 2011-05-20 12:26:12 Begin: Close Sql Cursor at baa33e0

 

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