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

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