SAP Knowledge Base Article - Preview

2908209 - SQL Error 30046 returned error code 10054 in ST22 - SAP ASE for BS

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 NetWeaver (NW) - All versions
  • 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 for Me (Login required).

Search for additional results

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