Failed to submit error in Survey123 Form

[DianaTorres10]

My form was created using the Survey123 Connect version 3.18.123.

I have the following error when users try to submit an answer:

[{"id":0,"addResults":[{"success":false,"globalId":null,"error":{"code":10500,"description":"Database error has occurred."},"objectId":null}]}]

I'm using a pulldata calculation consuming a feature service.

I tried changing the feature service and also updating it's privacy.

Any advice?

[abureaux]

pulldata shouldn't affect submission. Any chance you can upload your XLSX?

[DianaTorres10]

Sure! 

I just removed the url from my service tho.

[DougBrowning]

Usually it is text that is longer than 255.

https://community.esri.com/t5/arcgis-survey123-questions/quot-failed-to-submit-quot-error-in-survey1... 

[abureaux · Accepted solution]

Did they update the error message? I normally see this when a string length is exceeded:

Send Error. This survey could not be sent due to the following error: Database Error

Still a database error though.

I don't see anything odd with the XLSX, and it submits fine in a raw form. It would make sense if the data you were pulling exceeded the 255 default character length. You could try changing bind::esri:fieldLength for two of the pulldata fields to be, for example, 1000 (and just temporarily delete the other pulldata calculates). Be aware that that type of change will give you this warning:

[DianaTorres10]

@abureaux Thank you so much!

It was the first pulldata the one that gets the info form the https. I updated the lenght to 25,000 and that fixed the error.

[abureaux]

Glad this is working now!

Credit where credit is due though. It was @DougBrowning that first brought up field length as a potential issue.

[DougBrowning]

Thanks for that lol.  Your post was much more written out.  I should have specifically said to look at the pulldata fields since this happens a lot.

[RyanJensen18]

Hello all,

I have a form that has an HTML table to show a summary of log entries. Since the latest update 3.21.62, the form will not submit. It throws an error stating send error with a radio button of "ok". I click the "ok" radio button and try to re-open the survey. It states "send error" due to my instance name. Well, I got rid of the instance name and it still wont send.  I then took the table out of my xls form and I can send the survey.  This was working fine until the update.  Anyone have any ideas on why my survey will not send anymore? Attached is the portion of the xls form with the HTML table and screen shots of the errors.  Thank you for any info one may provide.

[DougBrowning]

With no form just a guess but is the field you are using for this table have the bind::esri:fieldType set to null so it does not try to submit it?  You could be running out of field length.  You could also try setting bind::esri:fieldLength to something long.

You could also look at using a grid for this vs writing out html.  https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-groups-grids-and/b...