Object Manager Crashes While Creating A Large String Query in Dispatch Board (Doc ID 1633400.1)

Last updated on JANUARY 30, 2017

Applies to:

Siebel Field Service - Version 8.1.1.8 SIA [23012] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.8 SIA [23012] version, eMediaObjMgr_esn, platform: Linux x86-64

ACTUAL BEHAVIOR

We have a custom Dispatch Boarch UI.
When attempting to load parent service region that has 1034 child service regions in Dispatch Board, the application crashed with a segment violation and core dump (no fdrs no crash.txt) after trying to build a query which contains a large string. Here is extracted from eMediaObjMgr_esn log:

ObjMgrSqlCursorLog Trace 5 000000bf512523f4:0 2013-02-21 06:47:19 SQL Cursor with ID 6FC7A630 Buscomp: Service Region Hierarchy Relationship, Forward Only: 0, Fetch Rows: 1034, Fetch All Time: 0.056 seconds.
ObjMgrSqlCursorLog Close 5 000000bf512523f4:0 2013-02-21 06:47:19 End: Close Sql Cursor at 6fc7a630
ObjMgrSqlCursorLog Fetch 5 000000bf512523f4:0 2013-02-21 06:47:19 End: Fetch for Sql Cursor 6fc7a630
ObjMgrSqlObjLog NamedSearch 5 000000bf512523f4:0 2013-02-21 06:47:19 Begin: SetNamedSearch for SqlObj 'Employee' at 6d987850, Named Search: 'Service Region Constraint Named Search' - '([Service Region Id] = '1-147-1' OR [Service Region Id] = '1-147-10' OR [Service Region Id] = '1-147-100' OR [Service Region Id] = '1-147-101' OR [Service Region Id] = '1-147-102' OR [Service Region Id] = '1-147-1024' OR [Service Region Id] = '1-147-1025' OR [Service Region Id] = '1-147-1026' OR [Service Region Id] = '1-147-1027' OR [Service Region Id] = '1-147-1028' OR [Service Region Id] = '1-147-1029' OR [Service Region Id] = '1-147-103' OR [Service Region Id] = '1-147-1030' OR [Service Region Id] = '1-147-1031' OR [Service Region Id] = '1-147-1032' OR [Service Region Id] = '1-147-1033' OR [Service Region Id] = '1-147-1034' OR [Service Region Id] = '1-147-1035' OR [Service Region Id] = '1-147-1038' OR [Service Region Id] = '1-147-1039' OR [Service Region Id] = '1-147-104' OR [Service Region Id] = '1-147-1040' OR [Service Region Id] = '1-147-1041' OR [Service Region Id] = '1-147-1042' OR [Service Region Id] = '1-147-1043' OR [Service Region Id] = '1-147-1044' OR [Service Region Id] = '1-147-1045' OR [Service Region Id] = '1-147-1046' OR [Service Region Id] = '1-147-105' OR [Service Region Id] = '1-147-1052' OR [Service Region Id] = '1-147-1053' OR [Service Region Id] = '1-147-1054' OR [Service Region Id] = '1-147-1055' OR [Service Region Id] = '1-147-1056' OR [Service Region Id] = '1-147-1057' OR [Service Region Id] = '1-147-1058' OR [Service Region Id] = '1-147-1059' OR [Service Region Id] = '1-147-106' OR [Service Region Id] = '1-147-1061' OR [Service Region Id] = '1-147-1062' OR [Service Region Id] = '1-147-1063' OR [Service Region Id] = '1-147-1064' OR [Service Region Id] = '1-147-1065' OR [Service Region Id] = '1-147-1066' OR [Service Region Id] = '1-147-1067' OR [Service Region Id] = '1-147-1068' OR [Service Region Id] = '1-147-1069' OR [Service Region Id] = '1-147-107' OR [Service Region Id] = '1-147-1070' OR [Service Region Id] = '1-147-1071' OR [Service Region Id] = '1-147-1072' OR [Service Region Id] = '1-147-1073' OR [Service Region Id] = '1-147-1074' OR [Service Region Id] = '1-147-1075' OR [Service Region Id] = '1-147-1076' OR [Service Region Id] = '1-147-1077' OR [Service Region Id] = '1-147-1078' OR [Service Region Id] = '1-147-1079' OR [Service Region Id] = '1-147-108' OR [Service Region Id] = '1-147-1080' OR [Service Region Id] = '1-147-1081' OR [Service Region Id] = '1-147-1082' OR [Service Region Id] = '1-147-1083' OR [Service Region Id] = '1-147-1084' OR [Service Region Id] = '1-147-1085' OR [Service Region Id] = '1-147-1086' OR [Service Region Id] = '1-147-1087' OR [Service Region Id] = '1-147-1088' OR [Service Region Id] = '1-147-1089' OR [Service Region Id] = '1-147-109' OR [Service Region Id] = '1-147-1090' OR [Service Region Id] = '1-147-1091' OR [Service Region Id] = '1-147-1092' OR [Service Region Id] = '1-147-1093' OR [Service Region Id] = '1-147-1094' OR [Service Region Id] = '1-147-1095' OR [Service Region Id] = '1-147-1096' OR [Service Region Id] = '1-147-1097' OR [Service Region Id] = '1-147-1098' OR [Service Region Id] = '1-147-1099' OR [Service Region Id] = '1-147-11' OR [Service Region Id] = '1-147-110' OR [Service Region Id] = '1-147-1100' OR [Service Region Id] = '1-147-1101' OR [Service Region Id] = '1-147-1102' OR [Service Region Id] = '1-147-1103' OR [Service Region Id] = '1-147-1104' OR [Service Region Id] = '1-147-1105' OR [Service Region Id] = '1-147-1106' OR [Service Region Id] = '1-147-1107' OR [Service Region Id] = '1-147-1108' OR [Service Region Id] = '1-147-1109' OR [Service Region Id] = '1-147-111' OR [Service Region Id] = '1-147-1110' OR [Service Region Id] = '1-147-1111' OR [Service Region Id] = '1-147-1112' OR [Service Region Id] = '1-147-1113' OR [Service Region Id] = '1-147-1114' OR [Service Region Id] = '1-147-1115' OR [Service Region Id] = '1-147-1116' OR [Service Region Id] = '1-147-1117' OR [Service Region Id] = '1-147-1118' OR [Service Region Id] = '1-147-1119' OR [Service Region Id] = '1-147-112' OR [Service Region Id] = '1-147-1120' OR [Service
ObjMgrQueryLog Cache 5 000000bf512523f4:0 2013-02-21 06:47:19 Created Cached Query: Employee:([Service Region Id] = '1-147-1' OR [Service Region Id] = '1-147-10' OR [Service Region Id] = '1-147-100' OR [Service Region Id] = '1-147-101' OR [Service Region Id] = '1-147-102' OR [Service Region Id] = '1-147-1024' OR [Service Region Id] = '1-147-1025' OR [Service Region Id] = '1-147-1026' OR [Service Region Id] = '1-147-1027' OR [Service Region Id] = '1-147-1028' OR [Service Region Id] = '1-147-1029' OR [Service Region Id] = '1-147-103' OR [Service Region Id] = '1-147-1030' OR [Service Region Id] = '1-147-1031' OR [Service Region Id] = '1-147-1032' OR [Service Region Id] = '1-147-1033' OR [Service Region Id] = '1-147-1034' OR [Service Region Id] = '1-147-1035' OR [Service Region Id] = '1-147-1038' OR [Service Region Id] = '1-147-1039' OR [Service Region Id] = '1-147-104' OR [Service Region Id] = '1-147-1040' OR [Service Region Id] = '1-147-1041' OR [Service Region Id] = '1-147-1042' OR [Service Region Id] = '1-147-1043' OR [Service Region Id] = '1-147-1044' OR [Service Region Id] = '1-147-1045' OR [Service Region Id] = '1-147-1046' OR [Service Region Id] = '1-147-105' OR [Service Region Id] = '1-147-1052' OR [Service Region Id] = '1-147-1053' OR [Service Region Id] = '1-147-1054' OR [Service Region Id] = '1-147-1055' OR [Service Region Id] = '1-147-1056' OR [Service Region Id] = '1-147-1057' OR [Service Region Id] = '1-147-1058' OR [Service Region Id] = '1-147-1059' OR [Service Region Id] = '1-147-106' OR [Service Region Id] = '1-147-1061' OR [Service Region Id] = '1-147-1062' OR [Service Region Id] = '1-147-1063' OR [Service Region Id] = '1-147-1064' OR [Service Region Id] = '1-147-1065' OR [Service Region Id] = '1-147-1066' OR [Service Region Id] = '1-147-1067' OR [Service Region Id] = '1-147-1068' OR [Service Region Id] = '1-147-1069' OR [Service Region Id] = '1-147-107' OR [Service Region Id] = '1-147-1070' OR [Service Region Id] = '1-147-1071' OR [Service Region Id] = '1-147-1072' OR [Service Region Id] = '1-147-1073' OR [Service Region Id] = '1-147-1074' OR [Service Region Id] = '1-147-1075' OR [Service Region Id] = '1-147-1076' OR [Service Region Id] = '1-147-1077' OR [Service Region Id] = '1-147-1078' OR [Service Region Id] = '1-147-1079' OR [Service Region Id] = '1-147-108' OR [Service Region Id] = '1-147-1080' OR [Service Region Id] = '1-147-1081' OR [Service Region Id] = '1-147-1082' OR [Service Region Id] = '1-147-1083' OR [Service Region Id] = '1-147-1084' OR [Service Region Id] = '1-147-1085' OR [Service Region Id] = '1-147-1086' OR [Service Region Id] = '1-147-1087' OR [Service Region Id] = '1-147-1088' OR [Service Region Id] = '1-147-1089' OR [Service Region Id] = '1-147-109' OR [Service Region Id] = '1-147-1090' OR [Service Region Id] = '1-147-1091' OR [Service Region Id] = '1-147-1092' OR [Service Region Id] = '1-147-1093' OR [Service Region Id] = '1-147-1094' OR [Service Region Id] = '1-147-1095' OR [Service Region Id] = '1-147-1096' OR [Service Region Id] = '1-147-1097' OR [Service Region Id] = '1-147-1098' OR [Service Region Id] = '1-147-1099' OR [Service Region Id] = '1-147-11' OR [Service Region Id] = '1-147-110' OR [Service Region Id] = '1-147-1100' OR [Service Region Id] = '1-147-1101' OR [Service Region Id] = '1-147-1102' OR [Service Region Id] = '1-147-1103' OR [Service Region Id] = '1-147-1104' OR [Service Region Id] = '1-147-1105' OR [Service Region Id] = '1-147-1106' OR [Service Region Id] = '1-147-1107' OR [Service Region Id] = '1-147-1108' OR [Service Region Id] = '1-147-1109' OR [Service Region Id] = '1-147-111' OR [Service Region Id] = '1-147-1110' OR [Service Region Id] = '1-147-1111' OR [Service Region Id] = '1-147-1112' OR [Service Region Id] = '1-147-1113' OR [Service Region Id] = '1-147-1114' OR [Service Region Id] = '1-147-1115' OR [Service Region Id] = '1-147-1116' OR [Service Region Id] = '1-147-1117' OR [Service Region Id] = '1-147-1118' OR [Service Region Id] = '1-147-1119' OR [Service Region Id] = '1-147-112' OR [Service Region Id] = '1-147-1120' OR [Service Region Id] = '1-147-1121' OR [Service Region Id] = '1-147-1122' OR [Service Region I
ObjMgrSqlObjLog NamedSearch 5 000000bf512523f4:0 2013-02-21 06:47:19 End: SetNamedSearch for SqlObject at 6d987850
ObjMgrSqlObjLog NamedSearch 5 000000bf512523f4:0 2013-02-21 06:47:19 Begin: SetNamedSearch for SqlObj 'Employee' at 6d987850, Named Search: 'Optional Constraint Named Search' - '[Employee Type Code] = 'Cuadrilla''
ObjMgrQueryLog Cache 5 0

Apparently the query never gets to run in the database as we couldn't find any executions in the database instance. According to the core dump:

Core was generated by `siebmtshmw /u01/app/siebel/siebsrvr/admin/SBA81SUAT.SUATAOM1.shm 12 0 1 5 0 enu'.
Program terminated with signal 11, Segmentation fault.
#0 0x5991de21 in CSSBinOpNode::DoBldQueryText(SSstring&, CSSBindVarArray*&, int, int, unsigned short, int, int, SSstring const*) () from /u01/app/siebel/siebsrvr/lib/libsscfdm.so

it seems that DoBldQueryText function is causing the crash

EXPECTED BEHAVIOR

Load the parent service region in Dispatch Board without the crash.

STEPS

The issue can be reproduced by customer at will with the following steps in Siebel vanilla:

1. Login with SADMIN
2. Go to Site Map and navigate to Administration - Scheduling.
2.1. Create a parent service region. Organization must be Default
Organization. Enter any value to the other required fields. (Name, Timezone
populated; rest are blank)
2.2. Create 740 child service region. Organization must be Default
Organization. Enter any value to the other required fields. (Name, Timezone
populated; rest are blank)
3. Go to Site Map and navigate to Dispatch Board.
4. Click "Select Service Region" button.
5. Select the parent service region and click "Ok"




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms