topic Re: Error Code 1000 in ArcGIS Survey123 Questions

Error Code 1000

KaraHarmet — Tue, 28 Nov 2017 21:41:32 GMT

Hello,

I receive a send error message that says "Arithmetic overflow error converting expression to data type nvarchar." What does this indicate and how do I solve it? Any help would be appreciated! Please see the image below.

Thanks,

Kara

Re: Error Code 1000

JohnathanHasthorpe — Tue, 28 Nov 2017 23:21:07 GMT

Hi Kara

To help us troubleshoot this issue, can you please share you survey and let me know the following:

- Is the issue happening with every submission, or just when certain values are entered?

- Was the service published through Connect or the web?

- Was the survey published against ArcGIS Online or ArcGIS Enterprise (is so, what Portal version)?

- Was the survey published against an existing feature service?

Thanks

John

Re: Error Code 1000

KaraHarmet — Wed, 29 Nov 2017 13:41:12 GMT

Hi John,

I have updated the initial post to include my survey. To my knowledge, it is every submission I try. I have tried submitting the submission in my outbox with different values and I receive the same error message. It was published through Connect with ArcGIS Online. It had been published before in the same manner.

Thanks,

Kara

Re: Error Code 1000

JamesTedrick — Wed, 29 Nov 2017 17:47:47 GMT

Hi Kara,

in database terms, nvarchar is a text field; the error is occurring because something is getting converted from a number into text; these would include calculate and note questions as well, which default to text. Scanning through your sheet, it looks like lines 525 and 526 potentially could be causing errors, as they involve a numerical calculation that is getting saved into a text field. One thing to look at is if the calculation for either results in a number with (including the decimal place and negative sign) is larger than 10 characters (the length of the field).

In the spreadsheet you attached, while I don't see submission_url, the questions all have their type & length explicitly set - is this using an existing feature service?

Re: Error Code 1000

KaraHarmet — Wed, 29 Nov 2017 22:13:02 GMT

Hi James,

You were correct! I had looked at the field types and lengths but missed those lines. Thanks for all the help!

-Kara