Loading

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

Udgivelsesdato: Mar 20, 2026
Beskrivelse

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.

 

Løsning

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.

 

Yderligere ressourcer

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.

 

Vidensartikelnummer

001474055

 
Indlæser
Salesforce Help | Article