SAP Knowledge Base Article - Preview

3501700 - Job failing with ST22 on DBSQL_SQL_ERROR and SQL code: 30016 - SAP ASE for Business Suite

Symptom

> Job is failing with ST22 with Runtime Error DBSQL_SQL_ERROR and Short Text "SQL code: 30016" occurred while accessing table "xxxx", followed by this:
    Database error text: "SQL message: [ASE Error SQL30016:08S01][SAP][ASE ODBC            
     Driver]Bad TDS response stream received from server. Unexpected token type                   
     received: 119."                                                                              |

> From related dev_w* trace file for that ST22 dump, the following is reported:

C  ERROR: -1 in function StartSelect (execute) [line 35347]
C  (30016) [08S01] [SAP][ASE ODBC Driver]Bad TDS response stream received from server. Unexpected t
C  oken type received: 133.
C  syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART
C  sql statement is ==> xxxxxxxxx
...
C  ERROR: -1 in function free_curs_stmt (SQLFreeHandle) [line 57541]
C  (30016) [08S01] [SAP][ASE ODBC Driver]Bad TDS response stream received from server. Unexpected t
C  oken type received: 119.
C  syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART
C  ERROR: -1 in function free_curs_stmt (SQLFreeHandle) [line 57541]
C  (30016) [08S01] [SAP][ASE ODBC Driver]Bad TDS response stream received from server. Unexpected t
C  oken type received: 71.
....
B  ***LOG BYM=> severe DB error 30016; work process in reconnect status [dbsh         1205]
B  ***LOG BY4=> sql error 30016  performing PRE on table xxxx [dbdbslst     5138]
B  ***LOG BY0=> [ASE Error SQL30016:08S01][SAP][ASE ODBC Driver]Bad TDS response stream received from server. Unexpected token type received: 119. [dbdbslst     5138]
B  dumping DbDbslStatement ...
B  DBSL_SS(  amode=DBSL_ACC_SL  stmtid_ptr=0   stmt=7f476ce64ad8  nlcb_ptr=0 )
....


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP04 PL04
SAP Netweaver (NW) - all versions

Product

SAP ERP 6.0

Keywords

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.