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.