ERROR

Failed to submit. Arithmetic overflow error converting expression to data type int. The statement has been terminated

Last Published: May 9, 2022

Error Message

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.
Error message

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.
Error message in the Survey123 field app.

Cause

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 typeValue
typeinteger
bind::esri:fieldTypeesriFieldTypeInteger
bind::type int

Solution or Workaround

As a workaround, use a string (text) field type instead of integer. To do this:

  1. Open the survey in ArcGIS Survey123 Connect.
  2. In the XLSForm of the survey, ensure questions requiring value responses that fall outside the valid range have the field types and values set as follows:
Field typeValue
typetext
bind::esri:fieldTypeesriFieldTypeString
bind::type string
  1. Republish the survey. Refer to ArcGIS Survey123: Publish a survey for more information.

Article ID:000020979

Software:
  • ArcGIS Survey123 Connect
  • ArcGIS Survey123 Website

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options