Error "Overflow in Numeric Calculation" When Loading a Worksheet SAP HANA Data Source

Issue

When loading a worksheet connected to SAP HANA, the following error may occur:

[SAP AG][LIBODBCHDB DLL][HDBODBC] General error; 314 numeric overflow: search table error: numeric overflow: search table error: [6944] AttributeEngine: overflow in numeric calculation;

Environment

Tableau Desktop
SAP HANA

Resolution

In the database itself, determine the data type of any measure that is being aggregated in the workbook. If possible change the data types of those measures in the database for a type with a larger range.

Cause

Aggregations in SAP databases are limited by the same data type restrictions as the columns themselves. A measure being used on a worksheet is being aggregated to the point where the aggregation value (e.g. SUM) exceeds the range of the data type

Additional Information

For more information about SAP data types and their respective ranges, see: Data Types in the ABAP Dictionary in the SAP Documentation.

Discuss this article... Feedback Forum