WSAGetLastError is received when trying to test the CA Business Intelligence (CABI) ODBC Connection

Article Id: 36923

Status: Published

Updated On: 14-02-2018 07:37

Legacy Id: TEC1255586

Products:

SUPPORT AUTOMATION- SERVER , CA Service Desk Manager - Unified Self Service , KNOWLEDGE TOOLS , CA Service Management - Asset Portfolio Management , CA Service Management - Service Desk Manager

Issue/Introduction:

Issue

When testing the CA Business Intelligence (CABI) - CA Service Desk Manager (CA SDM) ODBC connection from within the CABI Universe Designer, receive the following error:

[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Enginer]

connect() WSAGetLastError = 10061

Unable to connect: Socket open error on pdmweb.exe - 0

Environment

CA Service Desk Manager 14.x

CA Business Intelligence 4.1.x

Cause

This issue is usually related to some services/processes on the CA Service Desk Manager server being down or not running. Basically, CABI can not communicate properly with the CA Service Desk Manager server.

Resolution

Restart the CA Service Desk Manager services and the CA SDM ODBC services. Also, run a pdm_status and ensure that all processes are running. Then try testing the CABI-SDM ODBC connection again.

Environment:

Release:
Component: SDBOXI