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

Document ID : KB000102724
Last Modified Date : 20/06/2018
Show Technical Document Details
Issue:
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)

 
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)
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.




 
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.
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