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

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.

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.

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.

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:

3. Republish the survey. Refer to ArcGIS Survey123: Publish a survey for more information.