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 ONE Support launchpad (Login required).

Search for additional results

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