SAP Knowledge Base Article - Preview

2908209 - SQL Error 30046 returned error code 10054 in ST22

Symptom

  • Lots of dumps in ST22:

        "SQL message: [ASE Error SQL30046:08S01][SAP][ASE ODBC Driver]Connection to the server has been lost. Connection died while writing to socket. Socket returned error code 10054. Check the server to determine the status of any open transactions."

  • Following information in ASE error log, SAP ASE recognizes it as an IPV6 listener: 

        00:0002:00000:00016:2019/12/11 09:30:59.35 kernel network name ********, interface IPv6, address ************, type nlwnsck, port 4901, filter NONE
        00:0002:00000:00016:2019/12/11 09:30:59.35 kernel network name ********, interface IPv4, address ***********, type nlwnsck, port 4901, filter NONE
        00:0002:00000:00016:2019/12/11 09:30:59.35 kernel network name ********, interface IPv6, address ************, type nlwnsck, port 4901, filter NONE

  • Checking the listening ports information in OS side: There are also ESTABLISHED connections using IPV6


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Solution Manager 7.2

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.2

Keywords

ODCB, SQL30046, 30046, returned error code 10054, 10054, DBSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.