Issue
When connecting to Microsoft SQL Server using custom SQL, the following error might occur:Runtime Error: Arithmetic overflow error converting expression to data type int.
Last Modified Date: 09 Jan 2020
Runtime Error: Arithmetic overflow error converting expression to data type int.
Environment
- Tableau Desktop
- Windows 7
- Microsoft (MS) SQL Server
Resolution
Option 1
Change the calculation to return a valid number for the column type in the database.Option 2
Recreate the calculation, wrapping it in theFLOAT() function
Option 3
Work with the database administrator to recast theBIT type of the column in the original data source.
Cause
The returned value exceeds the maximum memory of the type for the column.Additional Information
An arithmetic overflow error can occur when there is a calculation in the custom SQL that generates a result that exceeds the limitations of the data type of the column.Additionally, the following link from Microsoft Technet may provide some insight into this issue: Runtime Error: Arithmetic overflow error converting expression to data type int.
Discuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials