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
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.