The DeDuplication Matching Process Crashes Around The Call To The Business Service 'XML Hierarchy Converter For DQ' Due To EDQ Rule Names Being Returned In The Match Output Response When Using EDQ 12.2.1.4 Or Later Versions
(Doc ID 2887648.1)
Last updated on SEPTEMBER 12, 2023
Applies to:
Siebel CRM - Version 19.7 to 23.5 [Release V17]Information in this document applies to any platform.
Symptoms
When enabling additional EDQ rules using the EDQ Director's tool, the Siebel application is crashing during the DeDuplication process when creating about 10-15 contact or account records. When reviewing the crash files, the crash appears to be happening around the call to the 'XML Hierarchy Converter For DQ' business service.
The following callstack is observed:
/siebel/mde/siebsrvr/lib/libsslcosd.so( 0x71c5)[0xf7b721c5]
/siebel/mde/siebsrvr/lib/libsslcosd.so( 0x79be)[0xf7b729be]
linux-gate.so.1(__kernel_rt_sigreturn 0x0)[0xf7eeb590]
linux-gate.so.1(__kernel_vsyscall 0x9)[0xf7eeb569]
/usr/lib/libc.so.6(gsignal 0xc6)[0xf631ead6]
/usr/lib/libc.so.6(abort 0xf4)[0xf6304dd4]
/usr/lib/libc.so.6( 0x76e2c)[0xf6362e2c]
/usr/lib/libc.so.6( 0x80c0f)[0xf636cc0f]
/usr/lib/libc.so.6( 0x81403)[0xf636d403]
/usr/lib/libc.so.6( 0x83d9f)[0xf636fd9f]
/usr/lib/libc.so.6(__libc_calloc 0x88)[0xf6371a58]
siebmtshmw(operator new[](unsigned int) 0x25)[0x809b5a5]
/siebel/mde/siebsrvr/lib/libsslcshar.so(CCFDebugInfoImp::GetCallStackDescription(void*, bool) 0xe8)[0xf7ce89f8]
/siebel/mde/siebsrvr/lib/libsslcshar.so(CCFGetCurrentCallStack(SSstring&, int, int, bool) 0x68)[0xf7ca0b88]
/siebel/mde/siebsrvr/lib/libsscfom.so(CSSService::CSSService() 0x196)[0xf2990596]
/siebel/mde/siebsrvr/lib/libsscfxc.so(CSSXMLCnvService::CSSXMLCnvService() 0x22)[0xdbd0a2c2]
/siebel/mde/siebsrvr/lib/libsscfxc.so(CSSXMLCnvService::CreateObject() 0x2d)[0xdbd0a70d]
/siebel/mde/siebsrvr/mw/lib/libmfc400su.so(CRuntimeClass::CreateObject() 0x25)[0xf78f5285]
/siebel/mde/siebsrvr/lib/libsscfom.so(CSSModel::GetService(char16_t const*, CSSService*&, int, bool) 0xb68)[0xf29850a8]
/siebel/mde/siebsrvr/lib/libsscaddsv.so(CSSDeDupService::Match_UC() 0xd0b7)[0xd8192d57]
/siebel/mde/siebsrvr/lib/libsscaddsv.so(CSSDeDupService::DoInvokeMethod(char16_t const*, CCFPropertySet const&, CCFPropertySet&) 0x2005)[0xd81018c5]
/siebel/mde/siebsrvr/lib/libsscfom.so(CSSService::InvokeMethod(char16_t const*, CCFPropertySet const&, CCFPropertySet&) 0x514)[0xf298f1e4]
/siebel/mde/siebsrvr/lib/libsscacmbc.so(CSSBCBase::InvokeKeyGenDDup() 0xfea)[0xe312846a]
/siebel/mde/siebsrvr/lib/libsscacmbc.so(CSSBCBase::SqlWriteRecord() 0x912)[0xe30b2c12]
/siebel/mde/siebsrvr/lib/libsscabcbc.so(CSSBCUser::SqlWriteRecord() 0x900)[0xda89ad40]
/siebel/mde/siebsrvr/lib/libsscfom.so(CSSBusComp::WriteRecord(bool, CSSObjectBase*) 0x3134)[0xf29d3fe4]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSSWEFrame::PostChangesToBC(int, CSSStringList*) 0x1978)[0xe4d377d8]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSSWEFrame::OnActionsWriterecord() 0x313)[0xe4d2cfc3]
/siebel/mde/siebsrvr/lib/libswcacmfr.so(CSSSWEFrameListBase::OnActionsWriterecord() 0xfa)[0xdf2658fa]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSSWEFrame::DoInvokeMethod(char16_t const*, CSSStringArray&, SSstring&) 0xbae)[0xe4d3fe5e]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSSWEFrameList::DoInvokeMethod(char16_t const*, CSSStringArray&, SSstring&) 0x4e)[0xe4e8fa3e]
/siebel/mde/siebsrvr/lib/libswcacmfr.so(CSSSWEFrameListBase::DoInvokeMethod(char16_t const*, CSSStringArray&, SSstring&) 0x696)[0xdf264716]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSSWEFrame::InvokeMethod(char16_t const*, CSSStringArray&, SSstring&) 0x1f5)[0xe4d29bf5]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSSWEFrame::InvokeMethod(char16_t const*, CSSStringArray&, CCFPropertySet&, SSstring&, CSSSWEBindingCtx*) 0x3a)[0xe4d29f6a]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSSWEComponent::InvokeMethod(char16_t const*, CSSStringArray&, CCFPropertySet&, SSstring&) 0x3d)[0xe54168ed]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSSWEFrameMgrInternal::InvokeAppletMethod(CSSSWEHtmlStream*, CSSSWEArgs*, WWEReqModInfo*, WWECbInfo*&, CSSStringArray&) 0x17e4)[0xe4f09a94]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSSWECmdProcessor::InvokeMethod(CSSSWEHtmlStream*, CSSSWEArgs*, WWEReqModInfo*, WWECbInfo*&) 0xd8d)[0xe4eaa4ed]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSSWECmdProcessor::_ProcessCommand(CSSSWEHtmlStream*, WWEReqModInfo*, WWECbInfo*&) 0x19da)[0xe4eaf93a]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSSWECmdProcessor::ProcessCommand(CSSSWEGenericRequest*, CSSSWEGenericResponse*, WWEReqModInfo*&, WWECbInfo*&) 0xc7a)[0xe4eb2c3a]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSSWECmdProcessor::ProcessCommand(CSSSWEHttpRequest*, CSSSWEHttpResponse*, WWECbInfo*&) 0xb7)[0xe4eb44e7]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSServiceSWEIface::Request(CSSSWEReqRec*, CSSSWEResponseRec*) 0x43f)[0xe5359bbf]
/siebel/mde/siebsrvr/lib/libsscaswbc.so(CSSServiceSWEIface::DoInvokeMethod(char16_t const*, CCFPropertySet const&, CCFPropertySet&) 0x4580)[0xe535ea40]
/siebel/mde/siebsrvr/lib/libsscfom.so(CSSService::InvokeMethod(char16_t const*, CCFPropertySet const&, CCFPropertySet&) 0x514)[0xf298f1e4]
/siebel/mde/siebsrvr/lib/libsstcsiom.so(CSSSIOMSession::ServiceInvokeMethod(unsigned long, char16_t const*, char16_t const*, SSstring&) 0xda)[0xf40c4efa]
/siebel/mde/siebsrvr/lib/libsstcsiom.so(CSSSIOMSession::RPCMiscService(SISOMRPCCode, SISOMArgType, unsigned long, CSSSISOMRPCArgList*, CSSSISOMRPCArgList*) 0x2aa)[0xf40c74ba]
/siebel/mde/siebsrvr/lib/libsstcsiom.so(CSSSIOMSession::HandleRPC(SISOMRPCCode, SISOMArgType, unsigned long, CSSSISOMRPCArgList*, CSSSISOMRPCArgList*, int&, void*) 0x653)[0xf40dbe43]
/siebel/mde/siebsrvr/lib/libsssasos.so(CSSClient::HandleOMRPC(CSSClientReq*) 0xb4)[0xf4364a84]
/siebel/mde/siebsrvr/lib/libsssasos.so(CSSClient::HandleRequest(CSSClientReq*) 0xda)[0xf436290a]
/siebel/mde/siebsrvr/lib/libsssasos.so( 0x85c5)[0xf43595c5]
/siebel/mde/siebsrvr/lib/libsssasos.so(SOMMTServer::SessionHandleMsg(smiSisReq*) 0x150)[0xf4359970]
siebmtshmw(smiMainThread::CompSessionHandleMsg(smiSisReq*) 0x55)[0x806e475]
siebmtshmw(_smiMessageQ::ProcessMessage(_smiMsgQItem*, long, int) 0x500)[0x808f950]
siebmtshmw(_smiMessageQ::ProcessRequest(void*, void*, void*&) 0x1c4)[0x80957a4]
siebmtshmw(_smiWorkQueue::ProcessWorkItem(void*, void*, void*&) 0xc8)[0x807ff58]
siebmtshmw(_smiWorkQueue::WorkerTask(void*) 0x311)[0x80848f1]
siebmtshmw(SmiThrdEntryFunc(void*) 0x729)[0x8072869]
/siebel/mde/siebsrvr/lib/libsslcosd.so( 0x14011)[0xf7b7f011]
/siebel/mde/siebsrvr/lib/libsslcwsl.so( 0x225f)[0xf7ee325f]
/siebel/mde/siebsrvr/mw/lib/libmfc400su.so(_AfxThreadEntry(void*) 0xaf)[0xf796aaff]
/siebel/mde/siebsrvr/mw/lib/libkernel32.so(MwThread(void*) 0x136)[0xf6918fe6]
/usr/lib/libpthread.so.0( 0x6ed9)[0xf6710ed9]
/usr/lib/libc.so.6(clone 0x6a)[0xf63090fa]
The following is the corresponding FDR output:
562955 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_SVC_INVOKE Service Invoke Method -703594464 0 XML Hierarchy Converter For DQ #XMLHierToXMLDoc#
562956 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_SVC_DSTR BusSvc Destruction -703594464 0 XML Hierarchy Converter For DQ
562957 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_BC_CNST BusComp Construction -704005520 0 DeDuplication Results (Contact) S_DEDUP_RESULT
562958 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_SQLOBJ_CNST SqlObj Construction -703750784 0 DeDuplication Results (Contact)
562959 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_SQLOBJ_SET_LNK SqlObj Setup the Link -703750784 0 Contact/DeDuplication Results (Contact)
562960 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_SQLOBJ_SET_LNK SqlObj Setup the Link -703750784 -699648192 Contact/DeDuplication Results (Contact)
562961 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_SQLOBJ_SET_VWMD SqlObj Set View Mode -703750784 0 DeDuplication Results (Contact)
562962 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_CACHE_QUERY Cache Query Parse Tree 0 0 DeDuplication Results (Contact):Id = Query No Rows""
562963 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_QUERY_PARSE Query Parse -621776636 0 Id = Query No Rows""
562964 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_BC_EXEC BusComp Execution -704005520 1 DeDuplication Results (Contact) #Execute#
562965 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_BC_EMPTY_WS BusComp Empty WorkSet -704005520 0 DeDuplication Results (Contact)
562966 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_SQLOBJ_SET_LNK SqlObj Setup the Link -703750784 -699648192 Contact/DeDuplication Results (Contact) 1-3BH1IK
562967 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_BC_SET_VWMD BusComp Set View Mode -704005520 6 DeDuplication Results (Contact)
562968 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_SQLOBJ_SET_VWMD SqlObj Set View Mode -703750784 0 DeDuplication Results (Contact)
562969 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_SQLOBJ_EXEC SqlObj Execution -703750784 1 DeDuplication Results (Contact)
562970 1658618101 3601857344 Fdr_DBC Database Connector FdrSub_DBC_CURSOR_CNST Sql Cursor Construction -703594464 -201329472
562971 1658618101 3601857344 Fdr_OBJMGR Object Manager FdrSub_OBJMGR_BC_BEG_CACHE_UPD BusComp Begin Cached Updates -704005520 0 DeDuplication Results (Contact)
562972 1658618101 3601857344 Fdr_FDR Fdr Internal FdrSub_FDR_CRASH ** CRASHING THREAD ** 0 0
Steps to reproduce the issue:
1. Install and integrate Siebel 19.7 or later with EDQ 12.2.1.4 or later for DeDuplication.
2. Enable additional EDQ rules using the following steps:
a. Log into the EDQ Director.
b. Make sure all jobs are stopped.
c. In the Project Explorer, navigate to: Projects > EDQ-CDS > Processes
d. Double-click on 'Match-Individual' under the 'Processes' in the Project Explorer.
e. In the 'Match-Individual' workspace (middle window), double-click on the 'Match Individual' step.
f. Double-click on the 'Match' icon in the new window. This will open up a dialog box.
g. In the dialog box, click on the scoring tab, select overallscore, then add the following rules:
Customstring1exact
Customstring2exact
Customstring3exact
Customstring4exact
Customstring5exact
Customstring6exact
h. Click 'Apply' then 'Ok', and close all the windows.
i. Start the EDQ jobs.
3. Log into the Siebel application and navigate to the Contact or Account views.
4. Create duplicate records to trigger the DeDuplication process. After about 10-15 records, the application crashes.
Due to this issue, users are unable to create any more duplicate records. Even if they log back in and try again, it would crash right away.
Changes
Updated EDQ Product to version 12.2.1.4 or later
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 |