Survey123 Error Code 1000: String or binary data would be truncated. The statement has been terminated. How to fix this error without republishing the survey?

Question

I have checked other online forums and the answer to this error seems to be that a multiline question or a select_multiple question has an answer which is too long for the field. However, we have already submitted survey responses to this survey with much longer answers than the current response which won't work and would like a way of fixing the error without having to republish the survey and lose all existing responses.

SarahFannin · Answer

Hi John

We've established the problem question. How can I change the field length on ArcGIS Online without having to republish the survey?

Thanks,

Sarah

JohnHasthorpe · Answer

Hi Sarah

If you can establish what question is causing the issue, go to the service item online and check its field length.

A select_one submission can get long if multiple answers are selected. e.g. if you had A B C or D as names and all were selected, then we would submit the following as a string: 'A,B,C,D'. If the names for your choices are are long, then you could end up with a string that is longer than the field.

You should definately check this.

Thanks

John

SarahFannin · Answer

Hi Johnathan,

I think the problem might be with a multiple choice tick question, would it be possible that maybe ticking a large number of the boxes is producing a value that is larger than the field can accept?

Thanks

Sarah