AnsweredAssumed Answered

String or binary data would be truncated Error

Question asked by brandon.adcock_CDPHDATA on Apr 3, 2019
Latest reply on Mar 11, 2020 by

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.