Data Quality Manager Error When Processing Batch (Error setting dedup candidates: "Could not connect to database)

(Doc ID 2311426.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

Siebel CRM - Version 8.2.2.4.12 [IP2013] to 16.16 [IP2016] [Release V8 to V16]
Information in this document applies to any platform.

Symptoms

On : 8.2.2.4.12 [IP2013] version, System Admin

When attempting to change the server DQ Batch Manager runs on, the following error occurs.

ERROR
-----------------------
SBL-APS-00118: Data Quality vendor-specific error: An error occurred when calling function 'sdq_set_dedup_candidates ()' in connector 'EDQ': "(-1013) Set dedup candidates problem." Detailed error message: Error setting dedup candidates: "Could not connect to database "oracle:PSBL@xxxx.xxxx.xx.xxx:1526/edqapp/GgBud_97"" (code 234,351)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Change the server from PRD1 to PRD2
2. Start the DQ Batch Manager process for Contacts
3. Error occurs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the DQ Batch Manager Process

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