Masking Job fails with SQL State 08S01 SQL Code 0

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

A very large masking jobs failed with SQL State 08S01 SQL Code 0

Environment

TDM Version: 4.10.221.0

FDM Version: 4.10.535.0

Cause

SQL State:08S01
SQL Error Code:0
Connection reset

SqlExceptionHelper: SQL Error: 0, SQLState: 08S01
SqlExceptionHelper: The TCP/IP connection to the host <hostname>, port <port> has failed. Error: "<hostname>. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

 

Resolution

As the error message indicates, this type of error is typically a network-related issue, causing the SQL Server to drop and reset the network connection. It is recommended to work with the SQL Server DBA and Network team to help identify the reason that the connection was reset.

Additional Information

For more information, see https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7bcc671a-595b-43f0-af7d-6d501c18a85c/8220error-08s01-microsoftsql-native-clientcommunication-link-failure8221?forum=sqldatabaseengine