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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.