My Oracle Support Banner

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

Last updated on SEPTEMBER 09, 2022

Applies to:

Siebel CRM - Version 19.4 to 19.7 [Release V17]
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

 

The same error: "ORA-01036 - illegal variable name/number" was also seen in the UI after applying 18.12 id Audit Trail is enabled. The doc id : ORA-01036 Error When Trying To Delete A Record With Audit Trail Enabled (Doc ID 2512553.1) can be reviewed as this is an extremely similar issue, with the same solution.

 

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.