SAP Knowledge Base Article - Preview

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


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



SAP Application Server based on MS SQL Server Alwayson


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.