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.

Alternatively the dump shows the following error:

SQL error "SQL code: 2601" occurred while accessing table "/BIC/F<CUBE>".
Database error text: "SQL message: [ASE Error SQL2601:23000]Attempt to insert
duplicate key row in object '/BIC/F<CUBE>' with unique index
'/BIC/F<CUBE>~P'"

  • 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 Adaptive Server Enterprise , BW-WHM-DBA-ICUB , InfoCubes , 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.