topic Collector offline error message in ArcGIS Collector Questions

Collector offline error message

Anonymous User — Tue, 26 Mar 2019 23:25:35 GMT

Hello,

I have a Collector user out in the field using an offline web map featuring an ArcGIS online hosted feature class. He has been using this successfully but is now getting the following error messages "Abort due to constraint violation" and "Unable to open the database file - Create virtual table for selection failed" when he tries to collect a point. It seems to be intermittent. It is now allowing him to collect a point but not delete a point. I have not been able to replicate the error with his login on my device. He has tried to remove the map from his device and download again and it has not solved the problem.

Re: Collector offline error message

SUUGIS_Lab — Fri, 05 Apr 2019 00:30:45 GMT

I also have this issue with one of my students and their phone, "Abort due to constraint violation". ESRI Collector started working just fine he then alter the setting to enable averaging, and after that could no longer collect features. He would get the same error each time, "Abort due to constraint violation".

Re: Collector offline error message

WendyBarrios1 — Mon, 20 May 2019 14:12:45 GMT

In the hosted feature layer were any changes made to the fields and domains? This error has popped up before when fields were allowed to be populated with 0 characters, but domains were set that were greater than 0 characters. Try checking the fields and domains.

Re: Collector offline error message

RonaldVanderpool — Tue, 09 Jul 2019 17:02:58 GMT

We have just experienced the same issue. I checked the fields and domains in Pro by opening the AGOL web map that contains the features being collected. Nulls are allowed and this is the typical setting when creating the features in Pro then uploading as a hosted feature. The online table has the value "empty" that is the default if nothing is selected in the field from the associated initial domain values. The online field details look like this;

Re: Collector offline error message

JimmyKnowles — Wed, 10 Jul 2019 22:25:22 GMT

We have experienced this same issue and have been unable to figure out why as well. This issue appears to surface randomly and only affects certain editable features in the web map. Other features can still be created.

I've looked at the .geodatabase files and nothing jumps out at me.

You'd think a constraint violation would have something to do with a unique primary key, but that doesn't seem to be the case here. I've also tried to find a way to turn on logging in Collector, but haven't found anything.

Re: Collector offline error message

RonaldVanderpool — Thu, 11 Jul 2019 13:45:36 GMT

I guess my biggest concern, well over being restricted in field use, is that it is not a consistent error and cannot be re-created for analysis. I have no idea what could be causing this in the geodatabase. I believe that it stems from some Collector vs. OS issue more than anything else.

We have another error when downloading maps in Collector Classic for Android. ESRI has that case but have never found any corrections. We started downloading smaller area maps with far less detail and have not had the issue re-occur since. Still waiting on the new Android Collector to get out of beta status so we can utilize the functionality of the offline map areas, but I digress as that is another story.

Good luck Jimmy!

Re: Collector offline error message

JimmyKnowles — Thu, 11 Jul 2019 17:14:00 GMT

I agree with you Ronald... intermittent and non-reproducible errors are the toughest to crack. This error has been popping up on us on different Android devices and different versions of Collector Classic. We've yet to see it in the iOS version. It is pretty frustrating since it can make a scheduled day of field work almost wasted. Hoping that someone figures it out or future updates fix it. Thanks for sharing your pain.

Re: Collector offline error message

RonaldVanderpool — Thu, 11 Jul 2019 17:35:01 GMT

Also not happening on our iOS devices using the new Collector. Hoping the issue silently goes away when the beta evolves to the real deal. And soon would be better.

Any ideas ESRI when the beta will turn?

Re: Collector offline error message

CarlHolt1 — Tue, 24 Sep 2019 19:32:23 GMT

I'm having the issue on iOS using new Collector

Re: Collector offline error message

RonaldVanderpool — Tue, 24 Sep 2019 19:44:34 GMT

Hi Carl.

We have not had it happen on the iOS devices and have not seen the error for a few months in Android. I would suggest taking a screenshot of the error and run it up the ESRI support flagpole and see if they have had any luck on their end. Also post the same in this dialog but not under comments to me rather the original post by Emily. That way the ESRI GeoNet monitors may see it better.

I have a feeling that it is a device OS issue and not something in Collector. Too many versions of iOS and Android for Collector to have to associate with may be the root.

Re: Collector offline error message

JimmyKnowles — Wed, 25 Sep 2019 20:26:51 GMT

This would be unfortunate if this same intermittent error is occurring on iOS version of new Collector. Carl, could you provide more details to see if this is the same issue? A screenshot or exact verbiage would be nice along with circumstances when the error occurred.

We had two field crews that were plagued by this error this past field season (Android, current version of Collector, 18.0.3). I submitted a support ticket, but due to the intermittent nature of this issue, we didn't get anywhere. I've experienced the error personally once, but have not been able to recreate it. I've literally spent hours downloading offline maps, creating features, and removing the map in hopes of the error happening to me again. I wasn't entirely pleased with support's troubleshooting logic, so just closed the ticket. I asked for a version of Collector with logging enabled (something that is available on the current iOS version), but they thought it made more sense to recreate the feature service and use process of elimination to try and find what was causing the error. But since the error is so hard to recreate, I didn't think we were going to get anywhere with their approach.

I was hopeful that this would just disappear when Aurora for Android gets out of Beta, but now I'm a little worried with this latest news from Carl.

Ronald Vanderpool, did you make any changes? Just curious if there's a reason why you haven't seen it pop up lately.

Edit: One thing I should add is that the 'abort due to constraint violation' error is normally preceded by an 'unable to open file database' error.

Re: Collector offline error message

RonaldVanderpool — Wed, 25 Sep 2019 20:52:26 GMT

Greetings Jimmy.

The only change we made on our end for field workers was to remove the Android Collector Beta and use the old Android Collector. I was confident that we were safe until Carl had his issues on an iOS. Fingers are crossed around here because the support was not what I expected, very similar to what you experienced. Too many versions of Android and iOS operating systems out there and if units are not updated regularly then who knows. Also if they are updated and the Collector app is not set to interface with the new OS versions then there we go again. Scary business, but it is about Halloween so scary is expected..........HaHaHa

Re: Collector offline error message

DaveSelvidge — Wed, 09 Oct 2019 14:06:17 GMT

I'm receiving the error: "Unable to Submit -Abort due to constraint violation"

I just set up a map for collector using the ArcGIS Blog titled "Make your first Collector map". I went out and collected a few features and came back in to check the results. Everything worked as planned. I went back out and collected a path - worked well. Finally I attempted to collect an area (the building perimeter) and after pressing the "Submit" button I received the error.

I was attempting to use online
Only happened when submitting a polygon
The only thing different that I noticed was that my phone had connected to the Wifi and wasn't using the data anymore. ** I'm confident this is the issue for me. As you can see my accuracy is extremely degraded.

I know this isn't the exact issue everyone else is having but hopefully it will help someone somewhere.

EDIT: As you can see, I'm using the new Collector app for iOS.

Re: Collector offline error message

RaquelBensadoun — Mon, 12 Apr 2021 12:53:50 GMT

Has anyone found a resolution to this? One of my field inspectors received this error for the first time today - they have been using the same application for nearly 9 months with no changes to the schema or layer.

Re: Collector offline error message

ColinMurray1 — Tue, 01 Jun 2021 18:24:25 GMT

One of my field staff has also received this error but my other staff in the same area has not. I worked again only after removing and downloading the map again. Would have been annoying if there was no cellular service.