Siebel Object Manager Crashes When Doing Drilldown On A Repeating Calendar Event
(Doc ID 2975518.1)
Last updated on NOVEMBER 22, 2023
Applies to:
Siebel CRM - Version 23.1 to 23.9 [Release V17]Information in this document applies to any platform.
Symptoms
When attempting to drill down from Calendar activity on a repetitive event the object manager is crashing with the following call stack:
- CALL STACK -
sslcshar +0x25e59 = CCFFileReferenceMgr::GetFileNameInArr() +0x59
sslcshar +0x2532d = CCFPropertySet::GetELCookie() +0x8d
sslcshar +0x25e7d = CCFFileReferenceMgr::GetFileNameInArr() +0x7d
sslcshar +0x248aa = CCFPropertySet::~CCFPropertySet() +0xa
SWCACAFR +0x550aa = CSSSWEFrameActHICalGrid::SendEmailNotification() +0xfc0a
swcabcfr +0x32804 = CSSSWEFrameGantt::CreatePropertySet() +0x3e4
SWCACAFR +0x5386f = CSSSWEFrameActHICalGrid::SendEmailNotification() +0xe3cf
swcabcfr +0x32d83 = CSSSWEFrameGantt::GetControlDefinition() +0x2d3
SWCACAFR +0x547bc = CSSSWEFrameActHICalGrid::SendEmailNotification() +0xf31c
swcabcfr +0x31d8c = CSSSWEFrameGantt::GetCustomCtrlInfo() +0xdc
sscaswbc +0xf46a = CSSSWEFrame::GetControlUIProperties() +0x8fa
sscaswbc +0x1504f = CSSSWEFrame::GetControlsObjInfo() +0x36f
sscaswbc +0xd6308 = CSSSWEFrameList::GetControlsObjInfo() +0xe8
sscaswbc +0x14c62 = CSSSWEFrame::GetUIObjInfo() +0x322
sscaswbc +0xb372 = CSSSWEFrame::GetObjectInfo() +0xb82
sscaswbc +0x32ca70 = CSSSWEComponent::Execute() +0x140
sscaswbc +0x32ad3f = CSSSWEComponent::PostExecute() +0xcf
sscaswbc +0x32ca7d = CSSSWEComponent::Execute() +0x14d
sscaswbc +0x32ad3f = CSSSWEComponent::PostExecute() +0xcf
sscaswbc +0x32ca7d = CSSSWEComponent::Execute() +0x14d
sscaswbc +0x131be1 = CSSSWEHtmlContentHandler::GetRPCReturnPropSetStr() +0x311
sscaswbc +0x14bb3a = CSSSWEHtmlPUIContentHandler::DoShowView() +0x42a
sscaswbc +0x12b28d = CSSSWEContentHandler::CS_ShowView() +0x3bd
sscaswbc +0x1294ea = CSSSWEContentHandler::ShowView() +0x43a
sscaswbc +0xd9f0f = CSSSWEActionMgr::ActionBuildViewAsync() +0xb1f
sscaswbc +0xde2c5 = CSSSWEActionMgr::DoPostedAction() +0xd5
sscaswbc +0xddd9b = CSSSWEActionMgr::CheckPostedActions() +0x16b
sscaswbc +0x10aec4 = CSSSWEFrameMgrInternal::InvokeAppletMethod() +0x13b4
sscaswbc +0xe19ee = CSSSWECmdProcessor::InvokeMethod() +0x82e
sscaswbc +0xe0188 = CSSSWECmdProcessor::_ProcessCommand() +0xd98
sscaswbc +0xe4dad = CSSSWECmdProcessor::ProcessCommand() +0xd2d
sscaswbc +0xe535b = CSSSWECmdProcessor::ProcessCommand() +0x10b
sscaswbc +0x2c4981 = CSSServiceSWEIface::Request() +0x361
sscaswbc +0x2c6d60 = CSSServiceSWEIface::DoInvokeMethod() +0xff0
sscfom +0x1b97d = CSSService::InvokeMethod() +0x2cd
sstcsiom +0xd81b = CSSSIOMSession::ServiceInvokeMethod() +0xab
sstcsiom +0xcfa4 = CSSSIOMSession::RPCMiscService() +0xb4
sstcsiom +0x1895 = CSSSIOMSession::HandleRPC() +0x425
sssasos +0x7480 = CSSSISObject::HasErrors() +0x47f0
sssasos +0x5be1 = CSSSISObject::HasErrors() +0x2f51
sssasos +0x17c7
sssasos +0x2231 = CompHandleMsg() +0x591
siebmtshmw +0xaa39
siebmtshmw +0x2543a = GetSmiTaskAPI() +0x8daa
siebmtshmw +0x24a67 = GetSmiTaskAPI() +0x83d7
siebmtshmw +0x1a3f3 = SmiBeginTrace() +0x5c63
siebmtshmw +0x1a056 = SmiBeginTrace() +0x58c6
siebmtshmw +0xe823 = SmiCleanupDetTask() +0x3483
sslcosd +0x2443 = OSDThreadPrivIsInit() +0x273
sslcosd +0x24db = OSDThreadPrivIsInit() +0x30
sslcshar +0x25e59 = CCFFileReferenceMgr::GetFileNameInArr() +0x59
sslcshar +0x2532d = CCFPropertySet::GetELCookie() +0x8d
sslcshar +0x25e7d = CCFFileReferenceMgr::GetFileNameInArr() +0x7d
sslcshar +0x248aa = CCFPropertySet::~CCFPropertySet() +0xa
SWCACAFR +0x550aa = CSSSWEFrameActHICalGrid::SendEmailNotification() +0xfc0a
swcabcfr +0x32804 = CSSSWEFrameGantt::CreatePropertySet() +0x3e4
SWCACAFR +0x5386f = CSSSWEFrameActHICalGrid::SendEmailNotification() +0xe3cf
swcabcfr +0x32d83 = CSSSWEFrameGantt::GetControlDefinition() +0x2d3
SWCACAFR +0x547bc = CSSSWEFrameActHICalGrid::SendEmailNotification() +0xf31c
swcabcfr +0x31d8c = CSSSWEFrameGantt::GetCustomCtrlInfo() +0xdc
sscaswbc +0xf46a = CSSSWEFrame::GetControlUIProperties() +0x8fa
sscaswbc +0x1504f = CSSSWEFrame::GetControlsObjInfo() +0x36f
sscaswbc +0xd6308 = CSSSWEFrameList::GetControlsObjInfo() +0xe8
sscaswbc +0x14c62 = CSSSWEFrame::GetUIObjInfo() +0x322
sscaswbc +0xb372 = CSSSWEFrame::GetObjectInfo() +0xb82
sscaswbc +0x32ca70 = CSSSWEComponent::Execute() +0x140
sscaswbc +0x32ad3f = CSSSWEComponent::PostExecute() +0xcf
sscaswbc +0x32ca7d = CSSSWEComponent::Execute() +0x14d
sscaswbc +0x32ad3f = CSSSWEComponent::PostExecute() +0xcf
sscaswbc +0x32ca7d = CSSSWEComponent::Execute() +0x14d
sscaswbc +0x131be1 = CSSSWEHtmlContentHandler::GetRPCReturnPropSetStr() +0x311
sscaswbc +0x14bb3a = CSSSWEHtmlPUIContentHandler::DoShowView() +0x42a
sscaswbc +0x12b28d = CSSSWEContentHandler::CS_ShowView() +0x3bd
sscaswbc +0x1294ea = CSSSWEContentHandler::ShowView() +0x43a
sscaswbc +0xd9f0f = CSSSWEActionMgr::ActionBuildViewAsync() +0xb1f
sscaswbc +0xde2c5 = CSSSWEActionMgr::DoPostedAction() +0xd5
sscaswbc +0xddd9b = CSSSWEActionMgr::CheckPostedActions() +0x16b
sscaswbc +0x10aec4 = CSSSWEFrameMgrInternal::InvokeAppletMethod() +0x13b4
sscaswbc +0xe19ee = CSSSWECmdProcessor::InvokeMethod() +0x82e
sscaswbc +0xe0188 = CSSSWECmdProcessor::_ProcessCommand() +0xd98
sscaswbc +0xe4dad = CSSSWECmdProcessor::ProcessCommand() +0xd2d
sscaswbc +0xe535b = CSSSWECmdProcessor::ProcessCommand() +0x10b
sscaswbc +0x2c4981 = CSSServiceSWEIface::Request() +0x361
sscaswbc +0x2c6d60 = CSSServiceSWEIface::DoInvokeMethod() +0xff0
sscfom +0x1b97d = CSSService::InvokeMethod() +0x2cd
sstcsiom +0xd81b = CSSSIOMSession::ServiceInvokeMethod() +0xab
sstcsiom +0xcfa4 = CSSSIOMSession::RPCMiscService() +0xb4
sstcsiom +0x1895 = CSSSIOMSession::HandleRPC() +0x425
sssasos +0x7480 = CSSSISObject::HasErrors() +0x47f0
sssasos +0x5be1 = CSSSISObject::HasErrors() +0x2f51
sssasos +0x17c7
sssasos +0x2231 = CompHandleMsg() +0x591
siebmtshmw +0xaa39
siebmtshmw +0x2543a = GetSmiTaskAPI() +0x8daa
siebmtshmw +0x24a67 = GetSmiTaskAPI() +0x83d7
siebmtshmw +0x1a3f3 = SmiBeginTrace() +0x5c63
siebmtshmw +0x1a056 = SmiBeginTrace() +0x58c6
siebmtshmw +0xe823 = SmiCleanupDetTask() +0x3483
sslcosd +0x2443 = OSDThreadPrivIsInit() +0x273
sslcosd +0x24db = OSDThreadPrivIsInit() +0x30
The following query is executed when the drill down is executed:
ObjMgrSqlLog Detail 4 0000005d64bf2560:0 2023-07-26 02:14:11 SELECT statement with ID: 1DEEA8D0
SELECT
T5.CONFLICT_ID,
T5.LAST_UPD,
T5.CREATED,
T5.LAST_UPD_BY,
T5.CREATED_BY,
T5.MODIFICATION_NUM,
T5.ROW_ID,
T3.TARGET_OU_ID,
T3.NAME,
T3.APPT_DURATION_MIN,
T3.CL_PTCL_ST_ID,
T5.PAR_REPTEVT_MST_ID,
T5.REI_TS,
T5.REI_END_TS,
T5.PARENT_ACTIVITY_ID,
T5.CAL_SEQ,
T3.ROW_ID,
T2.REPT_END_CD,
T3.APPT_REPT_FRI_FLG,
T3.APPT_REPT_MON_FLG,
T3.APPT_REPT_SAT_FLG,
T3.APPT_REPT_SUN_FLG,
T3.APPT_REPT_THU_FLG,
T3.APPT_REPT_TUE_FLG,
T3.APPT_REPT_TYPE,
T3.APPT_REPT_WED_FLG,
:1
FROM
SIEBEL.S_OPTY_POSTN T1,
SIEBEL.S_EVT_ACT_CAL T2,
SIEBEL.S_EVT_ACT T3,
SIEBEL.S_OPTY T4,
SIEBEL.S_CAL_REPT_EVT T5
WHERE
T5.PARENT_ACTIVITY_ID = T2.PAR_REPTEVT_MST_ID (+) AND
T5.PAR_REPTEVT_MST_ID = T3.ROW_ID (+) AND
T3.OPTY_ID = T4.ROW_ID (+) AND
T3.OPTY_ID = T1.ROW_ID (+) AND
((T3.TEMPLATE_FLG != 'Y' AND T3.TEMPLATE_FLG != 'P' OR T3.TEMPLATE_FLG IS NULL) AND (T3.OPTY_ID IS NULL OR T4.SECURE_FLG = 'N' OR T1.OPTY_ID IS NOT NULL)) AND
(T5.REI_TS < TO_DATE(:2,'MM/DD/YYYY HH24:MI:SS') AND T5.REI_END_TS >= TO_DATE(:3,'MM/DD/YYYY HH24:MI:SS') AND T5.PAR_REPTEVT_MST_ID IN (
SELECT SQ1_T1.ACTIVITY_ID
FROM SIEBEL.S_ACT_EMP SQ1_T1
WHERE (SQ1_T1.EMP_ID = :4)))
ORDER BY
T3.TODO_PLAN_START_DT
ObjMgrSqlLog Detail 4 0000005d64bf2560:0 2023-07-26 02:14:11 Bind variable 1: FINSObjMgr_SSO_enu,SS_PRD_O6,661651467,L184002,0000005d64bf2560:0,,Calendar REI,eCalendar Detail View
ObjMgrSqlLog Detail 4 0000005d64bf2560:0 2023-07-26 02:14:11 Bind variable 2: 07/28/2023 00:00:00
ObjMgrSqlLog Detail 4 0000005d64bf2560:0 2023-07-26 02:14:11 Bind variable 3: 07/23/2023 00:00:00
ObjMgrSqlLog Detail 4 0000005d64bf2560:0 2023-07-26 02:14:11 Bind variable 4: 1-4BSBM0
ObjMgrSqlLog Debug 5 0000005d64bf2560:0 2023-07-26 02:14:11 User search spec: [REI Event Date]<"07/28/2023" AND [REI Event End Date]>="07/23/2023" AND EXISTS ([Employee Id]="1-4BSBM0")
ObjMgrSqlLog Debug 5 0000005d64bf2560:0 2023-07-26 02:14:11 Named search [System Search]: ((([Template Flag] <> 'Y' AND [Template Flag] <> 'P') OR [Template Flag] IS NULL)) AND ([Opportunity Id] IS NULL OR [Opportunity Secure Flag] = 'N' or [Secure Opty Id] IS NOT NULL)
ObjMgrSqlLog Debug 5 0000005d64bf2560:0 2023-07-26 02:14:11 User sort spec: Planned
ObjMgrSqlLog Debug 5 0000005d64bf2560:0 2023-07-26 02:14:11 System sort spec:
ObjMgrSqlLog Debug 5 0000005d64bf2560:0 2023-07-26 02:14:11
SELECT
T5.CONFLICT_ID,
T5.LAST_UPD,
T5.CREATED,
T5.LAST_UPD_BY,
T5.CREATED_BY,
T5.MODIFICATION_NUM,
T5.ROW_ID,
T3.TARGET_OU_ID,
T3.NAME,
T3.APPT_DURATION_MIN,
T3.CL_PTCL_ST_ID,
T5.PAR_REPTEVT_MST_ID,
T5.REI_TS,
T5.REI_END_TS,
T5.PARENT_ACTIVITY_ID,
T5.CAL_SEQ,
T3.ROW_ID,
T2.REPT_END_CD,
T3.APPT_REPT_FRI_FLG,
T3.APPT_REPT_MON_FLG,
T3.APPT_REPT_SAT_FLG,
T3.APPT_REPT_SUN_FLG,
T3.APPT_REPT_THU_FLG,
T3.APPT_REPT_TUE_FLG,
T3.APPT_REPT_TYPE,
T3.APPT_REPT_WED_FLG,
:1
FROM
SIEBEL.S_OPTY_POSTN T1,
SIEBEL.S_EVT_ACT_CAL T2,
SIEBEL.S_EVT_ACT T3,
SIEBEL.S_OPTY T4,
SIEBEL.S_CAL_REPT_EVT T5
WHERE
T5.PARENT_ACTIVITY_ID = T2.PAR_REPTEVT_MST_ID (+) AND
T5.PAR_REPTEVT_MST_ID = T3.ROW_ID (+) AND
T3.OPTY_ID = T4.ROW_ID (+) AND
T3.OPTY_ID = T1.ROW_ID (+) AND
((T3.TEMPLATE_FLG != 'Y' AND T3.TEMPLATE_FLG != 'P' OR T3.TEMPLATE_FLG IS NULL) AND (T3.OPTY_ID IS NULL OR T4.SECURE_FLG = 'N' OR T1.OPTY_ID IS NOT NULL)) AND
(T5.REI_TS < TO_DATE(:2,'MM/DD/YYYY HH24:MI:SS') AND T5.REI_END_TS >= TO_DATE(:3,'MM/DD/YYYY HH24:MI:SS') AND T5.PAR_REPTEVT_MST_ID IN (
SELECT SQ1_T1.ACTIVITY_ID
FROM SIEBEL.S_ACT_EMP SQ1_T1
WHERE (SQ1_T1.EMP_ID = :4)))
ORDER BY
T3.TODO_PLAN_START_DT
ObjMgrSqlLog Detail 4 0000005d64bf2560:0 2023-07-26 02:14:11 Bind variable 1: FINSObjMgr_SSO_enu,SS_PRD_O6,661651467,L184002,0000005d64bf2560:0,,Calendar REI,eCalendar Detail View
ObjMgrSqlLog Detail 4 0000005d64bf2560:0 2023-07-26 02:14:11 Bind variable 2: 07/28/2023 00:00:00
ObjMgrSqlLog Detail 4 0000005d64bf2560:0 2023-07-26 02:14:11 Bind variable 3: 07/23/2023 00:00:00
ObjMgrSqlLog Detail 4 0000005d64bf2560:0 2023-07-26 02:14:11 Bind variable 4: 1-4BSBM0
ObjMgrSqlLog Debug 5 0000005d64bf2560:0 2023-07-26 02:14:11 User search spec: [REI Event Date]<"07/28/2023" AND [REI Event End Date]>="07/23/2023" AND EXISTS ([Employee Id]="1-4BSBM0")
ObjMgrSqlLog Debug 5 0000005d64bf2560:0 2023-07-26 02:14:11 Named search [System Search]: ((([Template Flag] <> 'Y' AND [Template Flag] <> 'P') OR [Template Flag] IS NULL)) AND ([Opportunity Id] IS NULL OR [Opportunity Secure Flag] = 'N' or [Secure Opty Id] IS NOT NULL)
ObjMgrSqlLog Debug 5 0000005d64bf2560:0 2023-07-26 02:14:11 User sort spec: Planned
ObjMgrSqlLog Debug 5 0000005d64bf2560:0 2023-07-26 02:14:11 System sort spec:
ObjMgrSqlLog Debug 5 0000005d64bf2560:0 2023-07-26 02:14:11
The issue can be replicated following the steps listed below:
1. Login to the Siebel application
2. Navigate to HI Activity Calendar View
3. Drill down to a repetitive event
4. The above crash is observed
Changes
N/A
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 |