SAP Knowledge Base Article - Preview

2511564 - DBSQL_SQL_ERROR SQL30294 connectivity errors - SAP ASE for BS

Symptom

  • Receiving DBSQL_SQL_ERROR dump.
  • Database error text: "SQL message: [ASE Error SQL30294:HY000][SAP][ASE ODBC Driver] There is no server listening at HOSTNAME:PORT#."
  • The work processes keep dying, it is necessary to restart SAP to logon
  • ASE bootup log shows that the server is listening on multiple listeners where IPV4 is static but IPV6 is dynamic (keeps changing) at each reboot:
     
    server will listen on all networks present on host
    network name HOSTNAME, interface IPv4, address 99.99.99.95, type nlwnsck, port 4901, filter NONE
    network name HOSTNAME, interface IPv6, address 2222:0:ipv6:9e76:1cf3:fa73:ipv6.ipv6, type nlwnsck, port 4901, filter NONE <===

    server will listen on all networks present on host
    network name HOSTNAME, interface IPv4, address 99.99.99.95, type nlwnsck, port 4901, filter NONE
    network name HOSTNAME, interface IPv6, address 2222:0:ipv6:90d7:1cfb:f9f7:ipv6.ipv6, type nlwnsck, port 4901, filter NONE <====

    server will listen on all networks present on host
    network name HOSTNAME, interface IPv4, address 99.99.99.95, type nlwnsck, port 4901, filter NONE
    network name HOSTNAME, interface IPv6, address 2222:0:ipv6:9ef2:34ad:f97a:ipv6.ipv6, type nlwnsck, port 4901, filter NONE <===


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions
  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

SQL 30294, Error 30294, frequent disconnects, DHCP, IPV6, listener, dynamic IP , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.