topic Re: Strange Error with SQLite in ArcGIS Collector Questions

Strange Error with SQLite

JackSelzer — Thu, 09 Sep 2021 16:11:47 GMT

Hello,

I am using a hosted feature layer to collect data in Esri Field Maps (21.2.3) or Collector (21.0.2)

The hosted feature layer contains three layers; polylines, polygons, and point features.

I have no issue placing polygon, or polyline features, but when a second point feature is submitted, it fails and is followed by; Error SQLite constraint violation.

Re: Strange Error with SQLite

JakeSkinner — Thu, 09 Sep 2021 17:04:56 GMT

@JackSelzer this will probably require troubleshooting:

Try publishing the data as a new hosted feature service and see if the issue remains.
Try publishing new data as a hosted a feature service and see if the issue remains.

Re: Strange Error with SQLite

JeremyBridges — Tue, 01 Feb 2022 17:45:18 GMT

We see similar errors when using Runtime with sync replicas. Seems like Runtime might need a better error message. An FYI. Stack trace:

- 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: Strange Error with SQLite

ArmstKP — Fri, 22 Apr 2022 19:33:15 GMT

I am getting the same error, when trying to delete a feature in the Field Maps app...

Re: Strange Error with SQLite

MikePowers — Sun, 16 Apr 2023 02:23:15 GMT

I was getting an error a smidge longer (arcgis.runtime exception, SQLite constraint violation. SQLite 19..... something like that) republished a new feature service and now I just get the same sleeker error as the original post.