2016 Jun 07 2:13 PM
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
2016 Jun 07 3:06 PM
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
2016 Jun 07 3:39 PM
Hi,
no, it is not an external view. This is normal table (with storage type: column store):
2016 Jun 08 12:57 PM
Sounds strange. Better create a CSS ticket on component BC-ABA-LA.
Best Regards, Thomas
2016 Jun 08 5:43 PM
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
2016 Jun 08 6:27 PM
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