Error: RegQueryValueEx Unable to connect: Socket open error on pdmweb.exe - (605), (IES 10901) (Error; INF)

book

Article ID: 102724

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

The following error appears after testing CA Business Intelligence (CABI) ODBC connection to CA Service Desk Manager (CA SDM) or trying to execute a Report from SDM in CABI:

Error in Database [DataDirect][ODBCOpenAccess SDK driver] [ODBCOpenAccess SDK Engine] Error: RergQueryValueEx Unable to connect: Socket open error on pdmweb.exe -0 (605) Error: RegQueryValueEx Unable to connect: Socket open error on pdmweb.exe - (605), (IES 10901) (Error; INF)

 

Cause

The .exe extension in the URL used to access the Service Desk web interface have been changed and is no longer pdmweb.exe

When the CABI tries to find the pdbweb.exe, that no longer exist and the @NX_PDMWEB_RENAMED_TO and @NX_EXE_EXCLUDE variables do not exist in the NX_ROOT\NX.env file on the CA SDM server containing the new variable for the 'pdmweb.exe' that was replaced, then shows the ODBC connection error.



From 17.3 release onward, the original ODBC services that facilitate the usage the above ODBC Client / CABI Report, those are not supported any more and have been deprecated since. 

Environment

CA Service Desk Manager 12.9,14.1 and later

CA Business Intelligence 3.x (for CA SDM 12.9) or 4.x (for CA SDM 14.1)

Resolution


1. Install 'NX_PDMWEB_RENAMED_TO' variable within the NX.ENV file by running the following on the CA SDM server:

pdm_options_mgr -c -s PDMWEB_RENAMED_TO -v <XXX> -a pdm_option.inst

Where <XXX> is the input name used instead of pdmweb

Run the following command to add the variable to the NX.env template file so it is not lost during CA SDM pdm_configure:

pdm_options_mgr -c -s PDMWEB_RENAMED_TO -v <XXX> -a pdm_option.inst -t

2. Install 'NX_EXE_EXCLUDE' variable within the NX.ENV file by running the following on the CA SDM server:

pdm_options_mgr -c -s EXE_EXCLUDE -v <XXX> -a pdm_option.inst

Where <XXX> is set to Yes.

Run the following command to add the variable to the NX.env template file so it is not lost during CA SDM pdm_configure:

pdm_options_mgr -c -s EXE_EXCLUDE -v <XXX> -a pdm_option.inst -t

Where, <XXX> is set to Yes.




NOTE: 
From 17.3 release onward, the original ODBC services that facilitate the usage the above ODBC Client / CABI Report, those are not supported any more and have been deprecated since.  Reports / APIs created using this old architecture need to be moved to supported newer architecture (Example: CABI JasperServer Reports)

Additional Information

How to rename the pdmweb.exe so that is does not use the .exe extension in the URL:
https://comm.support.ca.com/kb/is-it-possible-to-rename-the-pdmwebexe-so-that-it-does-not-use-the-exe-extension/kb000055086