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

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

Najděte více příspěvků označených jako

Accepted answers

RonParis

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

All comments

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.

BillSimper

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

TLongSUGF

I received this as well, any solution?

ArmstKP

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

SanMateoCountyDPW

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

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.

S-BlakeSmithGISS

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!

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

RonParis

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

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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