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]
C (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 */
C
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
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.