Symptom
A numeric overflow error occurs and produces an ABAP short dump in ST22, when a HANA DML statement attempts to insert data into a table object using the Integer data type :
Category Installation error
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 25.02.2023 14:38:52
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Short Text |
| SQL error "SQL code: 314" occurred while accessing table "BCA_PRENOTE_NT". |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|What happened? |
| Database error text: "SQL message: numeric overflow: |
| "SAPABAP1"."Table_Name": line 14 col 5 (at pos 986): convert |
| from 2147575996 to Integer type" |
----------------------------------------------------------------------------------------------------
.....
----------------------------------------------------------------------------------------------------
|Database Interface Information |
----------------------------------------------------------------------------------------------------
|C|E|status of row 1/6, status=-2, rc=314 [/bas/749_REL/src/dbs/hdb/dbsdbsql.cpp#2067] |
|C|E| execute() of C_0433, #rec=0, rc=1, rcSQL=314 [/bas/749_REL/src/dbs/hdb/dbsdbsql.cpp#2090] |
|C|E|EXECUTE C_0433 on connection 0, rc=314 [/bas/749_REL/src/dbs/hdb/dbslsdb.cpp#10030] |
|C|1|SQLCODE : 314 [/bas/749_REL/src/dbs/hdb/dbsdbtrc.cpp#443] |
|C|1|SQLERRTEXT : numeric overflow: "SAPABAP1"."Table_Name": line 14 col 5 (at pos 98|
|C|1| 47575996 to Integer type [/bas/749_REL/src/dbs/hdb/dbsdbtrc.cpp#450] |
|C|1|sc_p=7f066dbc2ca8,no=433,idc_p=7f066dc23900,con=0,act=1,slen=60,smax=256,#vars=6,stmt=7f066de3|
|C|1|stmtid = <13/BCA_PRENOTE_NT /33280/20170325144029> [/bas/749_REL/src/|
|C|1|INSERT INTO "BCA_PRENOTE_NT" VALUES( ? , ? , ? , ? , ? , ? ); [/bas/749_REL/src/dbs/dbfun/dbsc|
|B|E|***LOG BY4=> sql error 314 performing INS on table BCA_PRENOTE_NT [dbdbslst#4663] |
|B|E|***LOG BY0=> numeric overflow: "SAPABAP1"."Table_Name": line 14 col 5 (at pos 98|
Read more...
Environment
SAP HANA Platform Edition 2.0
Product
SAP HANA, platform edition 2.0
Keywords
KBA , HAN-DB-ENG , SAP HANA DB Engines , 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