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?

[RyanJensen18]

Hi Doug,

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

[DougBrowning]

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

[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?

[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/...   

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]

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.