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 laterInformation 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
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
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
/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 |