Getting Operation Rolled back error when trying to send survey

Question

I keep getting the message Operation rolled back when trying to submit my survey. It was working fine until I added jr:choice -name calculation fields. I added these to generate a column with the labels rather than names for the species select_one questions.  I am using version 3.24.30 of the Survey123 Connect and version 3.24.21 of the Survey123 mobile app. There are no updates available.

How to fix this issue? Or is there a better way to get output to display labels instead of names? Excel sheet is attached.

Thanks.

VCH Veg Survey.xlsx

smx-profile-shapes.png

dougbrowning · Answer

select one and multiple are a special case as there is no way to program that in excel so they are fine.  I know that is a bit weird but they did the best they could with excel.  So yes you just have to know which are ok to be green.

NinaPage · Answer

Thank for your suggestion @DougBrowning, I will work on those. A lot of them are for select_one questions and I'm struggling to figure out my these are flagged given the list names are correct. Do you have any ideas why this is? Thanks

dougbrowning · Answer

You have several name issues.

First Date is a reserved word.  See the green mark here telling you.

Here you have a space after the repeat name.  Again cannot ignore the green boxes on the name column.

For your species list just an idea but what we do is have species code scientific name  common name with spaces in the label section so crews can look up any of the names they know.

Start with these fixes and see.  Hope that works.