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.
SAP Knowledge Base Article - Preview