Siebel UCMBatchProcess task is is losing connection to ODQ/IIR during execution with error "Failed to connect to IIR Host"

(Doc ID 1914040.1)

Last updated on MARCH 01, 2017

Applies to:

Siebel Universal Customer Master - Version 8.1.1.11 [IP2013] and later
Siebel CRM - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.
*** Checked for currency on MAR-01-2017 ***

Symptoms

SIEBEL VERSION:
---------------
Siebel 8.1.1.11 SIA [23030]

ISSUE STATEMENT:
----------------
Customer recently upgraded to Siebel 8.1.1.11 and ODQ to 9.5.3. When running the Siebel UCM BDM job, the BDM job would encounter the following error message:

ObjMgrBusServiceLog Error 1 0000000a53952dfb:0 2014-06-09 04:01:45 (dataclnssvc.cpp (606)) SBL-APS-00118: Data Quality vendor-specific error: An error occurred when calling function 'sdq_set_parameter ()' in connector 'ASM': "(2) ids_connect failed." Detailed error message: sdq_set_parameter(1219): Failed to connect to IIR Host '********' on port 1666

When customer just restart the Siebel UCM BDM job/task without bouncing any Siebel server component/server services nor ODQ/IIR services, the task continues and does not generate the error anymore.

Customer performed more tests and and found that when data cleansing was disabled, the UCMBatchProcess tasks were no longer encountering the connectivity issue/errors.  Thus, the behaviour was related to having cleansing enabled.


WHERE IT HAPPENED:
-------------------------------
The issue happens in customer's test environment.

STEPS TO REPRODUCE:
-------------------------------
The behaviour occurs as follows:

1. Upgrade Siebel to 8.1.1.11 and ODQ to 9.5.3.
2. Run the Siebel UCM BDM job, the BDM job would encounter the following error message:

ObjMgrBusServiceLog Error 1 0000000a53952dfb:0 2014-06-09 04:01:45 (dataclnssvc.cpp (606)) SBL-APS-00118: Data Quality vendor-specific error: An error occurred when calling function 'sdq_set_parameter ()' in connector 'ASM': "(2) ids_connect failed." Detailed error message: sdq_set_parameter(1219): Failed to connect to IIR Host '********' on port 1666

3. Restart the Siebel UCM BDM job without bouncing any Siebel server or ODQ/IIR services, the task continues and does not generate the error anymore.

LOSS OF FUNCTIONALITY / BUSINESS IMPACT:
------------------------------
Due to the connection error, Siebel application was not able to connect to ODQ/IIR to perform data cleansing and matching.

ERROR MESSAGE:
-------------------
The error message that occurs with this issue is:

ObjMgrBusServiceLog Error 1 0000000a53952dfb:0 2014-06-09 04:01:45 (dataclnssvc.cpp (606)) SBL-APS-00118: Data Quality vendor-specific error: An error occurred when calling function 'sdq_set_parameter ()' in connector 'ASM': "(2) ids_connect failed." Detailed error message: sdq_set_parameter(1219): Failed to connect to IIR Host '********' on port 1666

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