My Oracle Support Banner

Error in running "Workflow Upgrade" step in "PostInstallDBSetup" While Applying 20.12 or Above Patch (Doc ID 2747217.1)

Last updated on FEBRUARY 15, 2023

Applies to:

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

Symptoms

When user tried to apply the patch 20.12 on development environment it got failed during PostInstallDBSetup with below error which we can see from command prompt 

Stage 3 of 3: Running WF DR upgrade
Error occurred during execution

The issue can be reproduced at will with the following steps:
1. Try to apply 20.12 patch 
2. Notice PostInstallDBSetup executed properly or not

In WorkflowUpgrade.log we can see below errors

SELECT
T1.CONFLICT_ID,
T1.LAST_UPD,
T1.CREATED,
T1.LAST_UPD_BY,
T1.CREATED_BY,
T1.MODIFICATION_NUM,
T1.ROW_ID,
:1
FROM
SIEBEL.S_CT_ACTION_SET T1
WHERE
(T1.ROW_ID = :2)
ORDER BY
T1.NAME

ObjMgrSqlLog Detail 4 0000000263b704fc:0 2023-01-05 11:02:54 Bind variable 1: ,,,SADMIN,0000000263b704fc:0,,Personalization Action Set,
ObjMgrSqlLog Detail 4 0000000263b704fc:0 2023-01-05 11:02:54 Bind variable 2: 04-BMZUO
ObjMgrSqlLog Debug 5 0000000263b704fc:0 2023-01-05 11:02:54 User search spec: "04-BMZUO" 

ObjMgrLog Error 1 000000025ff34742:0 2021-01-04 06:59:44 (wfadmin.cpp (1851)) SBL-BPR-00115: Cannot register action for runtime event.

We can see below crash during this process

Called from:
/crmapp1/opt/siebel/siebsrvr/lib/libsslcosd.so(+0x71c5)[0xf778e1c5]
/crmapp1/opt/siebel/siebsrvr/lib/libsslcosd.so(+0x79be)[0xf778e9be]
[0xf77b2410]
/crmapp1/opt/siebel/siebsrvr/lib/libsscafwsv.so(CSSWfAdmin::CreateAction(const SSstring&, const SSstring&, const SSstring&, const SSstring&, const SSstring&, const SSstring&, const SSstring&, int&, int)+0x272)[0xd43bb7b2]
/crmapp1/opt/siebel/siebsrvr/lib/libsscafwsv.so(CSSWfAdmin::ActivateEventInBranch(const SSstring&, const CCFPropertySet*, bool, const SSstring&, const SSstring&, const SSstring&, const SSstring&, const SSstring&, const SSstring&, const SSstring&, const SSstring&, int&, int&, int&, int&, const int&)+0x1b94)[0xd43bf7d4]
/crmapp1/opt/siebel/siebsrvr/lib/libsscafwsv.so(CSSWfAdmin::ActivateEventsInBranches(const SSstring&, const CCFPropertySet*, bool, const SSstring&, const SSstring&, const SSstring&, const SSstring&, const SSstring&, const SSstring&, const SSstring&, const SSstring&, int&, int&, int&, int&)+0xfd)[0xd43c182d]
/crmapp1/opt/siebel/siebsrvr/lib/libsscafwsv.so(CSSWfAdmin::ActivateEventsInStep(const SSstring&, const CCFPropertySet*, bool, const SSstring&, const SSstring&, const SSstring&, const SSstring&, int&, int&, int&, int&)+0x1e6)[0xd43c1a26]
/crmapp1/opt/siebel/siebsrvr/lib/libsscafwsv.so(CSSWfAdmin::ActivateEventsInSteps(const SSstring&, const CCFPropertySet*, const CCFPropertySet*, bool, const SSstring&, const SSstring&, const SSstring&)+0x1ec)[0xd43c1cec]
/crmapp1/opt/siebel/siebsrvr/lib/libsscafwsv.so(CSSWfAdmin::ActivateEventsInProcess(const SSstring&, const CCFPropertySet*, bool)+0x280)[0xd43c4800]
/crmapp1/opt/siebel/siebsrvr/lib/libsscafwsv.so(CSSWfAdmin::DeployProcess(const CCFPropertySet&, const SSstring&, bool, SSstring&, const SSstring&, const SSstring&, const SSstring&, const SSstring&, const SSstring&, const*, short, const)+0x15a)[0xd43c678a]
/crmapp1/opt/siebel/siebsrvr/lib/libsscafwsv.so(CSSWfAdmin::ActivateProcess(const CCFPropertySet&, CCFPropertySet&)+0xc01)[0xd43c7e21]
/crmapp1/opt/siebel/siebsrvr/lib/libsscafwsv.so(CSSWfAdmin::DoInvokeMethod(const*, short, const CCFPropertySet&, const*&)+0x1e6)[0xd43cdfd6]
/crmapp1/opt/siebel/siebsrvr/lib/libsscfom.so(CSSService::InvokeMethod(const*, short, const CCFPropertySet&, const*&)+0x514)[0xf74aace4]
/crmapp1/opt/siebel/siebsrvr/lib/libsscompilerutil.so(CSSCompObjType::Write(CObArray&, CObArray&)+0x16e1)[0xd8791111]
/crmapp1/opt/siebel/siebsrvr/lib/libsscompilerutil.so(CSSCompilerEngine::Compile(CSSCompilerUtil*, const SSstring&, CSSStringArray*, const SSstring&, const SSstring&, SSstring, int, const SSstring&, const SSstring&, SSstring)+0xf6d)[0xd879855d]TAG

From FDR file we got action set details:-

690642 1609946592 4112615808 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_QUERY_PARSE Query Parse 679721664 0 [Action Set Id] = 0VH-1ASBFV" AND [BusProc Method] = "RunProcess" AND [Bus"
690643 1609946592 4112615808 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_BC_EXEC BusComp Execution 679918992 0 Personalization Action #Execute#
690644 1609946592 4112615808 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_BC_EMPTY_WS BusComp Empty WorkSet 679918992 0 Personalization Action
690645 1609946592 4112615808 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_BC_EMPTY_WS BusComp Empty WorkSet 679918992 0 Personalization Action
690646 1609946592 4112615808 Fdr_FDR Fdr Internal FdrSub_FDR_CRASH ** CRASHING THREAD ** 0 0

Changes

 

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.