KNOWLEDGE BASE

[SQLSTATE:22003] numeric overflow when loading workbook in Tableau Desktop


Published: 20 May 2022
Last Modified Date: 20 May 2022

Issue

When opening the workbook connected to MySQL in Tableau Desktop, the following error may occur 

Error occurred while communicating with data source "..." 
 error code: A88FA7AA 
 [SQLSTATE:22003] numeric overflow

Environment

  • Tableau Desktop 2021.4.6
  • Windows 10
  • MySQL

Resolution

Change the affected field's data type from Number(Whole) to Number(Decimal).

Cause

The "Numeric overflow" exception is expected when the value in the data field is greater than the maximum value that an eight-bytes signed integer can present (-9223372036854775808 to +9223372036854775807) 
Did this article resolve the issue?