AnsweredAssumed Answered

String or binary data would be truncated Error

Question asked by brandon.adcock_CDPHDATA on Apr 3, 2019
Latest reply on Apr 8, 2019 by brandon.adcock_CDPHDATA

I have created a form in Survey 123 Connect.  I tested it in Connect, no problems.  I uploaded it to AGOL and tried to submit a response through the desktop app, no good.

 

When I attempt to submit a completed form though the iPad or desktop Survey123 apps, it returns an error: SEND ERROR - This survey was not able to be sent due to the following error: - string or binary data would be truncated. The statement has been terminated. - Do you want to edit this survey? Yes - No

 

I have done some research and spent several hours troubleshooting.  I see a few places which talk about this happening when the field length of a calculated field exceeds the length allowed by the feature service.  I do not seem to have that problem (the only calculated field that is relevant in this submission is a field that combines text and I already made the field length for that field and the fields it is combining appropriate).  Also attempted to publish it as a completely new survey and that didn't solve the problem either.

 

So, what could be causing this and how do I fix it?  I can attach the spreadsheet I'm using to make the form, but I would have to change a few things for confidentiality and am trying to avoid chasing down those bugs too.

 

Thank you in advance for your help.

Outcomes