[314]: numeric overflow ?

[Former Member]

Hi,

I try to understand ...

I want to aggregate some values, but i've got this error message :

[314]: numeric overflow: search table error:  [6944] AttributeEngine: overflow in numeric calculation;JEAggregate pop1(setIndex('TEST:F_EXPORT','en'),setAttribute('MT_VALEUR'),setAggregationTypes(1))

SQL is :

SQL
select cd_pays,sum(mt_valeur) from f_export group by cd_pays

I work with AWS

max() returns values..

[Former Member]

It looks like a real overflow issue. The numeric data types on HANA do have limits - apparently those limits also apply to an aggregation function such as sum(). You find the maximum values for the supported data types on http://help.sap.com/hana/html/_csql_data_types.html

Just choose a data type that can hold bigger values. I'll contact development to check if that limitation is intentional, because it looks like a bug to me...

--juergen