nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Find more posts tagged with

Accepted answers

abureaux

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:

All comments

dougbrowning

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.

RyanJensen18

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?

AGC Intrusive Investigation Gustine.xlsx

dougbrowning

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

RyanJensen18

Hi Doug,

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

Team Logbook.xlsx

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

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.

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.

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.

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

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.

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-survey123-web/td-p/1276953

DianaTorres10

Sure!

I just removed the url from my service tho.

Presion.xlsx

abureaux

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.