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