SAP Knowledge Base Article - Preview

2372059 - Work process in reconnect status during SQL Server alwayson failover

Symptom

If a work process is running during SQL Server alwayson failover, the work process will get a short dump, saying the connection to DB fails.

Looking at the trace file of the work process in ST11, named dev_w(n), log entries like below can be seen:

[HYooo] [Microsoft] [SQL Server Native Client 11.0] Unspecified error occurred on SQL Server. Connection may have been terminated by the server.
(10054) [08S01] [Microsoft] [SQL Server Native Client 11.0] TCP Provider: An existing connection was forcibly closed by the remote host.
(10054) [08S01] [Microsoft] [SQL Server Native Client 11.0] Communication link failure
Rollback Work (99)
LOG BYM=> severe DB error 10054; work process in reconnect status
Reconnect state is entered by connection


Read more...

Environment

SAP Application Server based on MS SQL Server Alwayson

Keywords

Alwayson
failover
10054
DB error 10054
reconnect status , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.