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; } } }

"Error 1003: Operation rolled back" on some completed surveys

Jean-YvesLandry1

I'm receiving Error 1003 on some of the completed survey sent (presently only 5 out of 100 received this error). I've tried to see if the form was completed differently but I can't find the problem for these particular filled forms. Any idea what would cause this error on some and not others? I've searched the blogs on this particular error but haven't found a solution.

Finde mehr Beiträge mit dem Tag

Accepted answers

JamesTedrick

Hi Jean-Yves,

This error code is displayed if something occurs during the submission operation that causes an error in the feature service. There can be a few different reasons for it to happen, the most common is a difference in the value types (text, integer, decimal, date) being submitted and what the table is defined as storing in the feature service. Another possibility is a text value larger than can be held in the field- this seems more likely given that only a few records exhibit this problem.

All comments

MichelleWilliams1

I was able to fix this error by removing the TABOO symbols, like commas.

Dear esri staff can you change the verbiage of Special characters to TABOO characters, and move it to the top of the list, because it's REALLY important (and change the color of the text to RED). I've never read the statement stating that "The following characters can't be used" because it blends into all the other text, so it took me a really long time to figure it out, and it seems that this question is all over the internet, and it could be fixed with these little tweaks. I hope this is helpful to your end-users!

Taboo

MichelleWilliams1

Hi Jean,

This looks like this could work for me but I'm not sure how to do this part. Would you say this again but differently?

I removed the edit code in DB browser for sqlite and launched it again and everything is uploading.

"__meta__":{"editMode":1,"globalIdField":"globalid","objectIdField":"objectid"},

Jean-YvesLandry1

This is an issue with the edit with repeats... Here's my methodology:

I asked my crew to copy and send me the arcgis folder from each tablet, then I opened the .sqlite located in "ArcGIS\My Surveys\Databases" I found the forms with errors:

I compared to the other forms that didn't have any problems and noticed they all had something in common, they had the edit mode clause.

e.g.:

{"Inventaire_Structure_V20731":{"__meta__":{"editMode":1,"globalIdField":"globalid","objectIdField":"objectid"},"comment_gen":

I removed the edit code in DB browser for sqlite and launched it again and everything is uploading.

"__meta__":{"editMode":1,"globalIdField":"globalid","objectIdField":"objectid"},

Jean-YvesLandry1

I opened the .sqlite and this is what happens.

[{"code":1003,"description":"Operation rolled back.","tableId":0},{"code":1000,"description":"The INSERT statement conflicted with the FOREIGN KEY constraint \"REL_FK_service_5b1bfaa8eba1488db6d414664296f90a_STRUCTURE_MENAGE_0\". The conflict occurred in database \"db_7501\", table \"user_7501.service_5b1bfaa8eba1488db6d414664296f90a_INVENTAIRE_STRUCTURE_V20731\", column 'globalid'.The statement has been terminated.","tableId":1}]

Jean-YvesLandry1

Hi James,

we've noticed that the rollbacks only occur on forms that were re-submitted, but not all, most can be re-submitted. The questionnaires have repeats so they are not updated they are duplicated, we nonetheless deleted the questionnaire online to see if they upload but they did not.

JamesTedrick

Hi Jean-Yves,

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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