TCP/IP Connections Not Getting Closed Between Siebel & EDQ when Parameter Remote Mode is On (Doc ID 2386558.1)

Last updated on JULY 07, 2020

Applies to:

Symptoms

TCP/IP Connections not getting close between Siebel and EDQ and causes jobs to fail when we set remote=True in dnd.properties file

Steps to reproduce the issue

=================

Triggering 'UCM Batch Process' workflow to insert records into Account BC in Siebel UCM Application with matching turned ON.
Siebel UCM system is connected with OEDQ using the latest version of connector, Siebel version(16.4.0.0) and OEDQ version - 12.2.1.3.0(376).

Below are the 'UCM Batch Process' input parameters -

1) UCM Search Spec to return 1000 records.
2) 1 record per page in Siebel EAI Query Page Business service.

Ran about 20 batches, with above inputs 5 to 7 batches successfully processed then server becomes unresponsive. Remaining batches did not process.

DQ log reported with below error

GenericLog GenericError 1 000000205a2512bc:0 2017-12-05 15:11:34 Object manager error: ([1] Data Quality vendor-specific error: An error occurred when calling function 'sdq_init_session ()' in connector 'EDQ': "(-11) error connecting." Detailed error message: error connecting socket to remote host(SBL-APS-00118) (0x650076))

Cause

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