SAP Knowledge Base Article - Preview

3307561 - numeric overflow: "Schema"."Table": line x col y (at pos 000): convert from 2147483648 to Integer type"

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.