KNOWLEDGE BASE

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


Published: 11 Jul 2018
Last Modified Date: 12 Jul 2018

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
Did this article resolve the issue?