SQLite constraint error

JeremyBridges — Tue, 01 Feb 2022 18:08:04 GMT

An FYI to the Runtime dev teams... Getting an odd SQLite error when trying to use sync replicas. This has also been observed in Collector:

https://community.esri.com/t5/arcgis-collector-questions/strange-error-with-sqlite/m-p/1096824/highlight/true#M13463

A fix in Runtime is probably needed. Exception below:

Esri.ArcGISRuntime.ArcGISRuntimeException: SQLite constraint violation: SQLite: 19
Abort due to constraint violation

- at Esri.ArcGISRuntime.ArcGISException.HandleCoreError (RuntimeCoreNet.GeneratedWrappers.CoreError error, System.Boolean throwException)
- at RuntimeCoreNet.GeneratedWrappers.Interop.CheckError (System.IntPtr errorHandle, System.Boolean throwOnFailure, System.Runtime.InteropServices.GCHandle wrapperHandle)
- at RuntimeCoreNet.GeneratedWrappers.CoreArcGISMapImageSublayer.get_Table ()
- at Esri.ArcGISRuntime.Mapping.ArcGISMapImageSublayer.<get_Table>b__43_0 (RuntimeCoreNet.GeneratedWrappers.CoreArcGISMapImageSublayer c)
- at Esri.ArcGISRuntime.Internal.RuntimeLazy.Make[T,U] (T& target, System.Boolean& initialized, System.Object locker, U factoryParam, System.Func<T,T1>[T,TResult] factory)
- at Esri.ArcGISRuntime.Internal.RuntimeLazy.Get[T,U] (T& target, System.Boolean& initialized, System.Object locker, U factoryParam, System.Func<T,T1>[T,TResult] factory)
- at Esri.ArcGISRuntime.Mapping.ArcGISMapImageSublayer.get_Table ()

Re: SQLite constraint error

TonyWakim — Wed, 02 Feb 2022 01:59:29 GMT

Jeremy,

Could you try setting up the SyncDirection (Property SyncDirection (arcgis.com)) to see if the error is happening on sync "Upload" or "Download"?

Re: SQLite constraint error

MikePowers — Fri, 14 Apr 2023 20:03:41 GMT

Getting that same error but when trying to submit a record in fieldmaps, not savvy enough to know the steps to set up that sync direction you suggested but it says "unable to submit" before the rest of the error message for what that's worth.

topic SQLite constraint error in .NET Maps SDK Questions

SQLite constraint error

Re: SQLite constraint error

Re: SQLite constraint error