Loading

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

Дата публикации: Mar 20, 2026
Описание

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.

 

Решение

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.

 

Дополнительные ресурсы

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.

 

Номер статьи базы знаний

001474055

 
Загрузка
Salesforce Help | Article