SBL-APS-00118: Data Quality vendor-specific error: An error occurred when calling function 'sdq_set_parameter() ' in connector 'ISS': "(2) parse_local_parms failed." (Doc ID 1498632.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Siebel Data Quality Matching - Version 8.2.2 SIA[22320] and later
Information in this document applies to any platform.
”Checked for Relevance on 03-08-2014”

Symptoms

On : 8.2.2 SIA[22320] version, System Admin

When attempting to add or edit an account, the application fails with:

ERROR
-----------------------
ObjMgrBusServiceLog InvokeMethod 4 000002234f9e1690:0 2012-04-30 15:04:28 Begin: Business Service 'XML Hierarchy Converter For DQ' invoke method: 'XMLHierToXMLDoc' at 1b02e310
EAIFileAttachments EAIFileAttachmentDebug 5 000002234f9e1690:0 2012-04-30 15:04:28 Getting file reference manager Session Global by key 'FileReferenceManager'
XMLConversion XMLCnvDetail 4 000002234f9e1690:0 2012-04-30 15:04:28 XML document will be generated with 'UTF-8' character encoding
XMLConversion XMLCnvArgTracing 5 000002234f9e1690:0 2012-04-30 15:04:28 XML conversion output tracing, creating a dump file containing target XML document.
ObjMgrBusServiceLog InvokeMethod 4 000002234f9e1690:0 2012-04-30 15:04:28 Business Service 'XML Hierarchy Converter For DQ' invoke method 'XMLHierToXMLDoc' Execute Time: 0.000 seconds.
ObjMgrBusServiceLog InvokeMethod 4 000002234f9e1690:0 2012-04-30 15:04:28 End: Business Service 'XML Hierarchy Converter For DQ' invoke method: 'XMLHierToXMLDoc' at 1b02e310
ObjMgrBusServiceLog Delete 4 000002234f9e1690:0 2012-04-30 15:04:28 Business Service 'XML Hierarchy Converter For DQ' (address: '1b02e310')was unregsitered at model '133b2700' for session ''
ObjMgrBusServiceLog Delete 4 000002234f9e1690:0 2012-04-30 15:04:28 Business Service 'XML Hierarchy Converter For DQ' was deleted at 1b02e310
ObjMgrBusServiceLog Error 1 000002234f9e1690:0 2012-04-30 15:04:28 (dedupsvc2.cpp (3441)) SBL-APS-00118: Data Quality vendor-specific error: An error occurred when calling function 'sdq_set_parameter() ' in connector 'ISS': "(2) parse_local_parms failed." Detailed error message: [430150428 0] iodll> It is now 20120430150428
[430150428 0] ssadqsea.c 998 rc 17
[430150428 0] Hash 22 is NULL

 

DataQuality DataQualityDebug 5 0000024d4fa12344:0 2012-05-02 12:02:06 MatchWithoutCandidates: sdq_set_parameter() - ParameterList :

DataQuality DataQualityDebug 5 0000024d4fa12344:0 2012-05-02 12:02:06 <Data><Parameter><Name>RECORD_TYPE</Name><Value>Canadian</Value></Parameter><Parameter><Name>THRESHOLD</Name><Value>70</Value></Parameter></Data>

Changes

<Parameter><Name>RECORD_TYPE</Name><Value>Canadian</Value>
This should have been set to Account.

select * from S_DQ_PARAM;

ROW_ID CREATED CREATED_BY LAST_UPD LAST_UPD_BY MODIFICATION_NUM CONFLICT_ID PARAM_NAME PARAM_VALUE PROCESS_CD DB_LAST_UPD COMMENTS DB_LAST_UPD_SRC
1-NS0Z 2012-05-02 18:56:30.000 0-1 2012-05-02 18:56:30.000 0-1 0 0 Account Match Against Primary Address DQ 2012-05-02 18:56:41.147 NULL User
1-NS10 2012-05-02 18:56:41.000 0-1 2012-05-02 18:56:41.000 0-1 0 0 Enable DQ Multiple Addresses No DQ 2012-05-02 18:56:51.823 NULL User
1-NS11 2012-05-02 18:56:51.000 0-1 2012-05-02 18:56:51.000 0-1 0 0 Enable DQ Multiple Languages No DQ 2012-05-02 18:56:58.710 NULL User
1-NS12 2012-05-02 18:57:00.000 0-1 2012-05-02 18:57:00.000 0-1 0 0 Enable DQ Sync Yes DQ 2012-05-02 18:57:08.007 NULL User
1-NS13 2012-05-02 18:57:09.000 0-1 2012-05-02 18:57:09.000 0-1 0 0 Enable DeDuplication Yes DQ 2012-05-02 18:57:18.833 NULL User
1-NS14 2012-05-02 18:57:20.000 0-1 2012-05-02 18:57:20.000 0-1 0 0 Force User DeDupe - Account Yes DQ 2012-05-02 18:57:28.240 NULL User
1-NS15 2012-05-02 18:57:29.000 0-1 2012-05-02 18:57:29.000 0-1 0 0 Fuzzy Query - Max Returned 100 DQ 2012-05-02 18:57:42.570 NULL User
1-NS16 2012-05-02 18:57:43.000 0-1 2012-05-02 18:57:43.000 0-1 0 0 Fuzzy Query Enabled Yes DQ 2012-05-02 18:57:52.850 NULL User
1-NS17 2012-05-02 18:57:54.000 0-1 2012-05-02 18:57:54.000 0-1 0 0 Match Threshold 70 DQ 2012-05-02 18:58:08.713 NULL User
1-NS18 2012-05-02 18:58:10.000 0-1 2012-05-02 18:58:10.000 0-1 0 0 Search Type Typical DQ 2012-05-02 18:58:29.497 NULL UserIt turned out to be that the value

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