Why does numeric overflow occur after SP 7 upgrade to SP 10?

[Former Member]

I migrated from HANA SP 7 to SP 10 and began receiving the following error when running queries:

[314]: numeric overflow:  search table error:  [6944] AttributeEngine: overflow in numeric calculation; fixed8_18 …

The error was mitigated by casting aggregated data to big integer format (i.e. using TO_BIGINT).  However, this error did not occur prior to the upgrade.

What has changed in the SP 10 revisions to generate this error?

-KS

[Former Member]

Hi Simpson,

Was there any data change in the tables of the view after the upgrade?

Also, there is a note which mentions a similar issue as http://saphanawiki.com/2015/10/2220948-sap-hana-sps-10-database-maintenance-revision-102-01/2/

You can check if yours is also a similar error.

Thank you.

Best Regards,

Anjali.

[Former Member]

No, I have the same data sets and the same queries.

[Ibrahem]

I faced this error before while trying divide number by 0, just use if ( denominator != 0 , ... , 0)

and I'm using SP09

[Former Member]

I have a simple SUM() function that I successfully executed prior to the upgrade.