SAP Knowledge Base Article - Preview

3726062 - ABAP short dumps occurring DBSQL_SQL_ERROR with SQL error 30046 occurred while accessing table.

Symptom

  • SAP ABAP Short dump DBSQL_SQL_ERROR receives SAP Adaptive Server Enterprise (ASE) errors: 
             Category              Installation Errors
             Runtime Errors     DBSQL_SQL_ERROR
             Except.                CX_SY_OPEN_SQL_DB
             Short Text: SQL error "SQL code: 30046" occurred while accessing table "WPBHELP_URL".
             What happened?  Database error text: "SQL message: [ASE Error SQL30046:08S01][SAP][ASE ODBC Driver]Connection to the server has been lost. Connection died while             reading from socket. Socket returned error code 10054. ERRNO returned 2. Check the server to determine the status of any open transactions"

  • And From the Dev_W file, noticed the below
    A  ABAP Program WPBHELP_REGISTRATION                    .
    A  Error Code DBSQL_SQL_ERROR.
    A  P1: WPBHELP_URL
    A  P2: SQL code: 30046
    A  P3: SQL message: [ASE Error SQL30046:08S01][SAP][ASE ODBC Driver]Connection to the server has been lost. Connection died while reading from socket. Socket returned error code 10054. ERRNO returned 2. Check the server to determine the status of any open transactions.


  • From the ASE logs:  kernel  network name , interface IPv6, address ::1, type, port 4901, filter NONE 


Read more...

Environment

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

Product

SAP ERP 6.0

Keywords

DBSQL_SQL_ERROR, short dumps, ABAP dump, SQL error, Error 30046, Connection died, socket. , 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.