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