topic Arithmetic Overflow send error and Converting expression to data type int. in ArcGIS Survey123 Questions

Arithmetic Overflow send error and Converting expression to data type int.

StephaneMoisy — Wed, 29 May 2019 07:02:39 GMT

Hello,

I published a survey that seemed to be working fine. Field crew were submitting completed surveys and using it. Then at the time of submitting the survey I encounter the problem: <<Arithmetic overflow error converting expression to data type int. he statement has been terminated >>. (see attachment)

After hours of browsing the forums, especially this one, no solution already proposed unfortunately corresponds to my situation. Yes, I was able to detect the source of the ERROR problem I unfortunately do not have the solution. Indeed, in my survey, I defined some text fields as integer via the column bind:Esri:fieldType (EsriFieldString : A series of alphanumeric symbols) and 255 as bind:esri:fieldLength). Therefore, it is impossible to submit the survey despite the fact that I have modified some results to match the data types.

Please any help that anyone can offer would be greatly appreciated.

I would like to point out that the investigation has not yet been submitted and it is still in the mailbox of the device.

Thanks,

Re: Arithmetic Overflow send error and Converting expression to data type int.

Anonymous User — Wed, 05 Jun 2019 01:16:45 GMT

Hi Stephane,

Are you using AGO or Portal? Can you provide a copy of your xlsx file and exactly what fields and datatypes where set wrong.

Have you tried republishing your survey with the correct field types and bind settings, and then on the same device, re-download that survey and try to open the same record and send again? If you can fix the issue in the schema/design/bind types in the survey xslx file and update it on the device, and the data matches the correct format, you should be able to send the record successfully.

Phil

Re: Arithmetic Overflow send error and Converting expression to data type int.

StephaneMoisy — Wed, 05 Jun 2019 06:58:44 GMT

Hello Phil

By using the url function I was able to modify the fields/column that was problematic and republish. And now it works. Walking with small mistakes not too serious.
I use AGO.

Thank!