SAP Knowledge Base Article - Preview

2279972 - SQL error "SQL code: 0" occurred while accessing table - SAP ASE BW

Symptom

  • "DBSQL_SQL_ERROR" occured in your system (can be APO system) during run of process chains:

Category               Installation Errors
Runtime Errors      DBSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB
Date and Time          <datetime_here>
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Short Text                                                                                                              
|    SQL error "SQL code: 0" occurred while accessing table "<F/E tablename_here>".   
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|What happened?              
|    Database error text: "SQL message: "                                                                 
----------------------------------------------------------------------------------------------------

Error returned on this Source Code Extract line:

|>>>>>|    INSERT (l_facttab) FROM TABLE g_t_u ACCEPTING DUPLICATE KEYS.

  • In the dev_w* trace file you identified this error message:

C  ERROR: -1 in function ExeNormalModify (execute) [line 26447]
(30292) [HY000] [SAP][ASE ODBC Driver]Attempting to read past stream EOM.
C  sql statement is ==> INSERT INTO "<F/E_tablename_here>" VALUES( ? , ? , ? , ? , ? )  plan '(use ins_by_bulk
C   on)'
C  /* R3:GP4SJ8MTKQ7A23JANQUEBKY3OUX:1387 T:<F/E_tablename_here>M:750 */

B  ***LOG BY4=> sql error 0      performing INS on table <F/E_tablename_here>  [dbdbslst     3779]
B  ***LOG BY0=> <message text not available> [dbdbslst     3779]

  • You have the last BW Correction Collection implemented on your system.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Business Warehouse (BW)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions

Keywords

process chain, DTP, APO, CR780373, 780373, CR#780373, insert, 30292 , KBA , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , 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.