ERROR
Attempts to submit a survey in the ArcGIS Survey123 website return the following error message:
Error: Failed to submit. Arithmetic overflow error converting expression to data type int. The statement has been terminated.
Attempts to submit the same survey in the Survey123 field app return the following error message:
Error: Add error 1000 - Arithmetic overflow error converting expression to data type int. The statement has been terminated.
The integer data type set in ArcGIS Survey123 Connect has a range of valid values that follows the integer data type in SQL Server. This range is from -2^31 (-2,147,483,648) to 2^31 (2,147,483,647). The error occurs when the response value submitted for questions with an integer field type falls outside this range (for example, phone numbers, or a value such as 323 111 0000). Below is a list of possible integer field type sets in ArcGIS Survey123 Connect survey questions.
Field type | Value |
type | integer |
bind::esri:fieldType | esriFieldTypeInteger |
bind::type | int |
As a workaround, use a string (text) field type instead of integer. To do this:
Field type | Value |
type | text |
bind::esri:fieldType | esriFieldTypeString |
bind::type | string |
Get help from ArcGIS experts
Download the Esri Support App