We are running MS SQL Server with Availability Groups and UMP won't start and some probes are in error state

book

Article ID: 38695

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

Symptoms:

 

We are running MS SQL Server with Availability Groups

The wasp and the data_engine probe are green and connected. However, the UMP is not reachable and sla_engine, ace, discovery_server, and other db connected probes are in error state:

 

Error:

[main, sla_engine] Exception occurs in createConnection com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host 10.2.4.11, named instance AVG-SQL-INFRA has failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names, check that no firewall is blocking UDP traffic to port 1434, and for SQL Server 2005 or later verify that the SQL Server Browser Service is running on the host. Trace: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host 10.2.4.11, named instance AVG-SQL-INFRA has failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names, check that no firewall is blocking UDP traffic to port 1434, and for SQL Server 2005 or later verify that the SQL Server Browser Service is running on the host.

 

 

Environment: 

 

CA UIM 8.3.1.

MS SQL 2012r2 – (MS SQL Server with Availability Groups)

 

Cause:

 

When using MS SQL Server with Availability Groups, only the server name is needed as the connection string in the data_engine, and no instance name should be added since there is only one database running behind the IP and the default port.

 

Resolution/Workaround:

 

To resolve this correct the connection string in data_engine:

Include only the server name, restart the data engine and this should solve the issue.

 

 

Additional Information:  

  

SQL Server Parameters (GUI/Console) https://docops.ca.com/display/UIM83/Installation+Parameters#InstallationParameters-SQLServerParameters(GUI/Console)

Environment

Release: CNMSPP99000-8.4-Unified Infrastructure Mgmt-Server Pack-- On Prem
Component: