topic Re: Failed to submit error in Survey123 Form in ArcGIS Survey123 Questions

Failed to submit error in Survey123 Form

DianaTorres10 — Wed, 13 Dec 2023 19:26:47 GMT

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?

Re: Failed to submit error in Survey123 Form

abureaux — Wed, 13 Dec 2023 20:39:19 GMT

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

Re: Failed to submit error in Survey123 Form

DianaTorres10 — Wed, 13 Dec 2023 20:47:52 GMT

Sure!

I just removed the url from my service tho.

Re: Failed to submit error in Survey123 Form

DougBrowning — Wed, 13 Dec 2023 21:00:25 GMT

Usually it is text that is longer than 255.

https://community.esri.com/t5/arcgis-survey123-questions/quot-failed-to-submit-quot-error-in-survey123-web/td-p/1276953

Re: Failed to submit error in Survey123 Form

abureaux — Wed, 13 Dec 2023 21:10:26 GMT

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:

Re: Failed to submit error in Survey123 Form

DianaTorres10 — Wed, 13 Dec 2023 23:51:10 GMT

@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.

Re: Failed to submit error in Survey123 Form

abureaux — Thu, 14 Dec 2023 15:23:08 GMT

Glad this is working now!

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

Re: Failed to submit error in Survey123 Form

DougBrowning — Thu, 14 Dec 2023 15:32:59 GMT

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.

Re: Failed to submit error in Survey123 Form

RyanJensen18 — Tue, 10 Dec 2024 06:33:59 GMT

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.

Re: Failed to submit error in Survey123 Form

DougBrowning — Tue, 10 Dec 2024 13:39:58 GMT

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/ba-p/895267

Re: Failed to submit error in Survey123 Form

RyanJensen18 — Tue, 10 Dec 2024 18:48:44 GMT

Hi Doug,

Thanks for the quick response! Here is my xls sheet. It was working perfectly before the last update.

Re: Failed to submit error in Survey123 Form

DougBrowning — Tue, 10 Dec 2024 19:49:20 GMT

I would start by setting all those big table fields to bind::esri:fieldType null.

Re: Failed to submit error in Survey123 Form

RyanJensen18 — Tue, 17 Dec 2024 01:34:48 GMT

Thanks Doug, it worked! I am wondering why it was working before without the null value. Either way, thanks. I have another question. I have a field in a survey that gets its data from a csv. I also have an inbox but the only field that doesn't show data is the csv file field. It submits with data but when inbox is refreshed by a different user, that field shows no data. Any thoughts?

Re: Failed to submit error in Survey123 Form

DougBrowning — Tue, 17 Dec 2024 14:50:38 GMT

You probably got a bigger result in production than testing.

Yes coming back from inbox or drafts can create all kinds of issues with calcs. You could try a calculation mode of when empty and see of that does it. Never had much luck but worth a shot. https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-calculation-modes/ba-p/1206967

Also make sure your csv is clean - no extra commas or special chars. Look at it in Notepad vs Excel.

I see you have the word query on the begin group line that I would remove.

Re: Failed to submit error in Survey123 Form

RyanJensen18 — Tue, 17 Dec 2024 15:09:00 GMT

Hi Doug. I figured it out. The survey that was having the issue was a submission_url survey and the calculation for that field was getting erased. I removed the calc and it stores the data in the inbox. I will remove the query. Thanks for your help.