Offline Map - SQLite Error

[RonParis]

I have an offline map synced to my device, but whenever I go to submit changes, I get the below error:

This wasn't an issue before the latest agol/field maps update, and the app version I'm using is v21.1.0, build 385. My device is iOS. Also the layer I am trying to update is a view layer.

TIA 

[RonParis · Accepted solution]

This appears to have been resolved with the latest version of Field Maps (21.1.1)

[ArmstKP]

It hasn't been resolved.  I received the error using 22.1.0, and this isn't from using Offline at all....

[TL2]

I received this as well, any solution?

[MiltonSolano]

Although it's an old topic, I wish to contribute in case someone still finds this error:

I got the same error message when the fields Editor and EditDate are not part of the View definition. Because the view needs to trigger update to these fields, you always need to include them on the view definition. If you don't you receive this error message.

Milton

[BlakeSmith]

Can you try and explain this more? I'm not able to follow. I made a web map and I am not having an issue making edits in the field on Field Maps. However, all of my coworkers are getting this error message when making an edit and trying to submit. This is only a recent error and not one we have ever experienced in the past. Thank you for any help!

[AyeletGreenberg]

Thanks a lot! I could not figure out how to solve this problem, and none of the other solutions helped. 

[BillSimper]

Thank you so much for posting this kind sir-- you saved my project!

[MiltonSolano]

Sure @BlakeSmith.

I noticed when creating a view that you may forget to include the fields Editor and Editdate (maintained by AGOL) in the View definition. Then you add this view to a map, create popups and a FieldMaps form. After your field crew takes de map offline and makes edits, then this triggers the "Offline Map - SQLite Error".

It makes sense to always allow these field available to update, but sometimes we may forget. I'm just saying in case someone forget to include these fields.

Update 04/02/2023: The error is happening on iPadOS 16.3 when an offline view has the following layer settings enabled:

Keep track of changes to the data (add, update, delete features).
Keep track of who edited the data (editor name, date and time).

But the fields Creator, CreationDate, EditDate, Editor are not available as part of the fields view; the error will raise in offline mode. Online mode will work without problems. On Android it will work without issues.

[MikePowers]

I'm getting that error (Esri.ArcGISRuntime.ArcGISRuntimeException: SQLite constraint violation: SQLite: 19
Abort due to constraint violation) in a field maps application with out any views, just the feature layer, and the keep track of changes is NOT enabled. Having some difficulty tracking the source of this error.