My Oracle Support Banner

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

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

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


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