Loading

Error " Runtime Error: Arithmetic overflow error converting expression to data type int" Connecting to MS SQL Server with Custom SQL

Date de publication: Mar 20, 2026
Description

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.
 

Cause

The returned value exceeds the maximum memory of the type for the column.

 

Résolution

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 the FLOAT() function.

 

Option 3

Work with the database administrator to recast the BIT type of the column in the original data source.

 

Ressources supplémentaires

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.

 

Numéro d’article de la base de connaissances

001474055

 
Chargement
Salesforce Help | Article