My Oracle Support Banner

Object Manager Crashing In Production After 19.4 Patch Installation (Doc ID 2596320.1)

Last updated on JANUARY 25, 2020

Applies to:

Siebel CRM - Version 19.4 and later
Information in this document applies to any platform.

Symptoms

On :  19.4 version, System Admin

ACTUAL BEHAVIOR  
---------------
Object Manager Crashing in Production after 19.4 Patch installation  

We installed the 19.4 patch to our Production environment last night, and multiple OM crashes with following callstack

 

 KERNELBASE!RaiseException+0x48
 msvcr110!_CxxThrowException+0x57
mfc110u!AfxThrowInvalidArgException+0x19
 sscdo90!CSSOraSqlObj::DoWriteRecordArray+0x46a [m:\siebel\src\core\dbconn\oracon\ora90\oracon.cpp @ 1427]
 sscdo90!CSSOraSqlObj::DoWriteRecord+0x9f [m:\siebel\src\core\dbconn\oracon\ora90\oracon.cpp @ 1155]
 sscdo90!CSSOraSqlObj::DoWriteRecordArray+0x795 [m:\siebel\src\core\dbconn\oracon\ora90\oracon.cpp @ 2861]
 sscfdm!CSSSqlObj::WriteRecordArray+0x383 [m:\siebel\src\core\datasvc\ssa\util\sqlobj.cpp @ 55171]
sscfdm!CSSSqlObj::DeleteRecord+0xec6 [m:\siebel\src\core\datasvc\ssa\util\sqlobj.cpp @ 19028]
sscfom!CSSBusComp::SqlDeleteRecord+0xd5 [m:\siebel\src\core\datasvc\ssa\objmgr\buscomp.cpp @ 28883]
sscacmbc!CSSBCBase::SqlDeleteRecord+0x5d6 [m:\siebel\src\core\services\clients\common\bc\bcbase.cpp @ 4448]
sscacmbc!CSSBCFile::SqlDeleteRecord+0x40 [m:\siebel\src\core\services\clients\common\bc\bcfile.cpp @ 3010]
sscadcbc!CSSBCFulfillment::SqlDeleteRecord+0x178 [m:\siebel\src\apps\edocument\document\bc\bcfulfil.cpp @ 1088]
sscfom!CSSBusComp::WriteRecord+0x814 [m:\siebel\src\core\datasvc\ssa\objmgr\buscomp.cpp @ 34850]
 sscaswbc!CSSSWEFrame::OnActionsWriterecord+0


From OM log, it was found there was DELETE statement firing and was getting error "ORA-01036: illegal variable name/number"

ObjMgrSqlLog Detail 4 000009c55d08142c:0 2019-06-24 16:30:35 INSERT/UPDATE statement with ID: Unknown
DELETE FROM SIEBEL.S_ACT_FUL_REQ

  WHERE  FUL_REQ_ID = :1


ObjMgrSqlLog Detail 4 000009c55d08142c:0 2019-06-24 16:30:35 Bind variable 1: 8-2GDZJT7

ObjMgrSqlLog Debug 5 000009c55d08142c:0 2019-06-24 16:30:35

DBCLog DBCLogError 1 000009c55d08142c:0 2019-06-24 16:30:35 OCIBindByPos: param# 91, data <?STR?>, bytes 32,

ObjMgrBusCompLog Error 1 000009c55d08142c:0 2019-06-24 16:30:35 (oracon.cpp (4826)) 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 000009c55d08142c:0 2019-06-24 16:30:35 ORA-01036: illegal variable name/number

Changes

 Siebel 19.4 Patch was applied on siebel 18.12

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.