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 for Business Suite
  • SAP Netweaver (NW) - all versions

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

SQL30016, 7332, 509, TDS, CR821263, 821263, CR#821263 , 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.