SAP Knowledge Base Article - Preview

2999740 - ST22 dump during data load reporting "Attempting to read past stream EOM" - SAP BW on SAP ASE

Symptom

  • BW load data job ends with ST22 dump with Runtime Errors  DBIF_SETG_SQL_ERROR and the following messages:

----------------------------------------------------------------------------------------------------
|Short text                                                                                       
|    SQL error 30292 while accessing a table.                                                     
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|What happened?                                                                                    
|    Database error text: "[ASE Error SQL30292:HY000][SAP][ASE ODBC                                
|     Driver]Attempting to read past stream EOM."

  • Checking the developper trace file we can see that the error is reported always for the same table: RSHASHDATA


C  ERROR: -1 in function RefillBuffer (fetch) [line 26422]
C  (30292) [HY000] [SAP][ASE ODBC Driver]Attempting to read past stream EOM.
C  statement id is ==> [3 RSHASHDATA                               1635778696 20101013151701]
B  ***LOG BY4=> sql error 30292  performing SEL on table RSHASHDATA                     [dbtrtab      3800]
B  ***LOG BY0=> [ASE Error SQL30292:HY000][SAP][ASE ODBC Driver]Attempting to read past stream EOM. [dbtrtab      3800]
A  TH VERBOSE LEVEL FULL

  • Data table is accessed without any issue (thru SE16 or doing a "select * from.." from isql session).
  • The dbs/syb/cancel_open_cursor DBSL parameter is enabled (configured to 1). 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - 7.30 

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.3

Keywords

cancel_open_cursor, load, SQL30292, EOM, cursor, DBSL , KBA , BW-SYS-DB-SYB , BW 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.