Strange SQL error -10811 Numeric overflow for parameter/column

[rafal_matuszewski2]

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

[amol_samte]

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

[rafal_matuszewski2]

Hi,

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

[thomasgauweiler]

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

Best Regards, Thomas

[Former Member]

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

[thomasgauweiler]

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