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 pageThis 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.