topic Strange SQL error -10811 Numeric overflow for parameter/column in Application Development and Automation Discussions

Strange SQL error -10811 Numeric overflow for parameter/column

rafal_matuszewski2 — Tue, 07 Jun 2016 13:13:32 GMT

Dear Experts,

today we got a few ABAP short dumps:


SQL error "SQL code: -10811" occurred while accessing table "Z079_CV_LOG".


Database error text: "SQL message: Numeric overflow for parameter/column (32)
source type DECIMAL, target type UCS2 (LE), value
'0.974204418927118174949782384017408E25'"

An exception has occurred which is explained in more detail below. The
exception is assigned to class 'CX_SY_OPEN_SQL_DB' and was not caught in
procedure
"READ_Z079_CV_LOG" "(METHOD)", nor was it propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated this
exception, the current program was terminated.

The reason for the exception is:
Database error text: SQL message: Numeric overflow for parameter/column (32)
source type DECIMAL, target type UCS2 (LE), value
'0.974204418927118174949782384017408E25'
Return value of the database layer: "SQL dbsl rc: 99"

It is very strange because the select is very simple, there is no SUM or any possibility to value conversion. It has to put all fields into structure of the same type as DB table. The table Z079_CV_LOG is a transparent table.

data LS_Z079_CV_LOG TYPE Z079_CV_LOG.

SELECT SINGLE *
       INTO ls_z079_cv_log
       FROM z079_cv_log
       WHERE cv_type = iv_cv_type
         AND key_ref = iv_key_ref.

When I try to reproduce the error, everything is ok. There is no strange values in the table shown in SE16N nor in Hana Studio.

We work on HANA DB version 1.00.097.03.1443520413

The column no. 32 in the table is of type Decimal 9,5:

Have you heard about such problem?

Best regards

Rafal

Re: Strange SQL error -10811 Numeric overflow for parameter/column

amol_samte — Tue, 07 Jun 2016 14:06:46 GMT

Hi,

I am assuming this is not a table, this should be external view....

Increase length of field in HANA view then sync and activate the external view....

e.g 23.9

In case to avoid dump you can use exception like CX_SY_OPEN_SQL_DB

Cheers,

-Amol S

Re: Strange SQL error -10811 Numeric overflow for parameter/column

rafal_matuszewski2 — Tue, 07 Jun 2016 14:39:31 GMT

Hi,

no, it is not an external view. This is normal table (with storage type: column store):

Re: Strange SQL error -10811 Numeric overflow for parameter/column

thomasgauweiler — Wed, 08 Jun 2016 11:57:10 GMT

Sounds strange. Better create a CSS ticket on component BC-ABA-LA.

Best Regards, Thomas

Re: Strange SQL error -10811 Numeric overflow for parameter/column

Former Member — Wed, 08 Jun 2016 16:43:00 GMT

Rafal,

Try se14->enter the table name->edit-> activate and adjust database (with the direct radio button selected, and the save data radio button selected)

Thanks,

Jacob Levinson

Re: Strange SQL error -10811 Numeric overflow for parameter/column

thomasgauweiler — Wed, 08 Jun 2016 17:27:24 GMT

Good idea,

but before adjusting the database table, please have a look at SE11 and check if Runtime Object and Database Object are in sync.

Regards, Thomas