topic Re: Collector + attachments = error in ArcGIS Collector Questions

Collector + attachments = error

RoyceSimpson — Wed, 04 Feb 2015 16:22:41 GMT

I've got a feature service hosted by at 10.3 AGS cluster with an Oracle 11g SDE 10.3 backend.

I'm trying to get this feature service to work offline with Collector. So far, everything is working online and I can download and sync offline via Collector, except when my offline edits contain attachments. I then get AGS errors as follows:

I've checked and rechecked the myriad of "data/map prep requirements" for going offline. I even created an all new points feature service following the instructions to the letter and still get the same set of errors when attachments are involved.

Thanks much for the help.

Level	Time	Message	Source

SEVERE

Feb 4, 2015, 9:04:46 AM

Error executing tool.: ErrorMsg@SyncGPService:{"code":500,"description":"Failed to synchronize."} Failed to execute (Sync Feature Service Replica).

System/SyncTools.GPServer

SEVERE

Feb 4, 2015, 9:04:46 AM

An error occurred.

System/SyncTools.GPServer

SEVERE

Feb 4, 2015, 9:04:46 AM

Failed to synchronize.

System/SyncTools.GPServer

SEVERE

Feb 4, 2015, 9:04:46 AM

Failed to synchronize.

System/SyncTools.GPServer

SEVERE

Feb 4, 2015, 9:04:46 AM

Error: Failed to export data changes to replica.

System/SyncTools.GPServer

SEVERE

Feb 4, 2015, 9:04:46 AM

Failure in processing exports for Replica: GIS.Ags_Fs_1423011330985 [GUID: {6DB524F2-02DC-496A-BE9A-C9623EF1B4B6}].

System/SyncTools.GPServer

SEVERE

Feb 4, 2015, 9:04:46 AM

Failed in acquiring Archive Difference Cursor for dataset: GIS.CollectorPoints__ATTACH for Replica: GIS.Ags_Fs_1423011330985 [GUID: 6DB524F2-02DC-496A-BE9A-C9623EF1B4B6]. Time taken: 0.016000 seconds. Stream finished [GIS.CollectorPolys]

Re: Collector + attachments = error

RoyceSimpson — Wed, 04 Feb 2015 17:00:36 GMT

I've made sure that the feature service was saved in AGOL without storing the feature service credentials. Still same errors as above.

Re: Collector + attachments = error

MiaogengZhang — Wed, 04 Feb 2015 21:26:34 GMT

I found this Archiving Problems with Offline Support has similar issue. You might want to try deleting archive and recreating it.

Re: Collector + attachments = error

RoyceSimpson — Wed, 04 Feb 2015 21:37:06 GMT

Hi Miaogeng,

Thanks, I was hopeful about that as a solution but the errors persist even after doing as you suggest.

Re: Collector + attachments = error

RoyceSimpson — Wed, 04 Feb 2015 21:49:17 GMT

One thing to note is that when sync the edits in collector, all the edits make it back to the geodatabase fine, including attachments. If it weren't for the error in collector and all the "severe" log entries in AGS, I would think the sync is working just fine. Perhaps the issue lies in the sync process attempting to correctly bring any changes to the geoDB since last sync onto my device. That's only speculation.

Re: Collector + attachments = error

MiaogengZhang — Wed, 04 Feb 2015 21:49:58 GMT

Do you already have existing attachment in Oracle and it is newly created feature class? I am wondering this attachment with [GUID: 6DB524F2-02DC-496A-BE9A-C9623EF1B4B6] from Collector or it is the existing attachment?

Re: Collector + attachments = error

RoyceSimpson — Wed, 04 Feb 2015 21:55:21 GMT

It was created in Collector.

Re: Collector + attachments = error

MiaogengZhang — Wed, 04 Feb 2015 23:00:11 GMT

Is it in iOS or Android?

When you try deleting archive and recreating it, do you test from scratch (download the map again and add attachment then sync)?

How many attachments are you trying to sync?

Re: Collector + attachments = error

RoyceSimpson — Wed, 04 Feb 2015 23:10:08 GMT

The attachment created in Collector.

Android LG G2 KK 4.4.4 Verizon.

After I deleted then recreated the archive, I restarted the feature service, redownloaded the map in Collector, collected a new point, added a photo attachment, got out of the map, synced... error.

One attachment.

Re: Collector + attachments = error

MiaogengZhang — Thu, 05 Feb 2015 18:07:38 GMT

I tested 10.3 AGS server with an Oracle 11.2.04 SDE 10.3 backend. I can't reproduce the issue. You can contact the support to further debug.

Re: Collector + attachments = error

RoyceSimpson — Thu, 05 Feb 2015 18:30:20 GMT

I've shared the map as public: http://larimercounty.maps.arcgis.com/home/item.html?id=819137c20bd74b34b64e38a02d5d659e

You can edit the points, lines, polys with the "guest1/guest1" combo.

Not sure you'll be able to see anything that will help fix this but you can have a look.

Re: Collector + attachments = error

MiaogengZhang — Thu, 05 Feb 2015 21:36:39 GMT

I can reproduce the issue in your service. But the issue seems happening in Server side. I can't reproduce in house and thus we can't get to the bottom of the issue.

From the server log, it mentions GIS.CollectorPoints__ATTACH. Maybe you want check GIS.CollectorPoints__ATTACH and see if something unusual. You can also try to Delete Attachment and re-create the attachment in SDE.

Re: Collector + attachments = error

DavidColey — Tue, 10 Feb 2015 20:17:33 GMT

Hey Royce - I just got my production environment updated to 10.3 and am itching to get started with collector now that it will support versioned edits. Since I think we have similar architecture I'll get back to you and the community on this post with any findings...

Thanks

David

Re: Collector + attachments = error

RoyceSimpson — Wed, 11 Feb 2015 16:17:14 GMT

Hi David,

Thanks for looking into it. I did try out a versioned workflow but neglected to test the offline attachment issue. Keep me informed. I guess I could try that out again but I'm thinking that 99% of all our Offline/Collector related workflows will not using versioning so really, I need to get this fixed with the non-versioned, enabled archiving workflow. By the way, I have opened a ticket with esri. I'll update here as needed.

Re: Collector + attachments = error

DavidColey — Wed, 11 Feb 2015 21:45:52 GMT

sounds good

Re: Collector + attachments = error

CarlosKrefft — Wed, 12 Oct 2016 15:24:19 GMT

Did you ever get it working. Same thing is happening to me.

Re: Collector + attachments = error

WilliamSchoefmann — Tue, 01 Nov 2016 21:20:22 GMT

We've been using Collector to edit data we stored in the AGOL cloud for an Alarm Line system that was mapped using Collector and ArcGIS for Desktop 10.2.2. Attachments and edits suddenly started failing about two weeks ago. We are about to try and host it on our ArcGIS for Server as a feature service with an SQL backend server but this makes me wonder if even that will work to help remedy the issues with attachments or just complicate things based on your comments here.

Re: Collector + attachments = error

DavidColey — Wed, 02 Nov 2016 21:54:15 GMT

Attachments have been syncing fine for us in a connected environment as of yesterday, but I haven't tried disconnected attachment syncs. We've got some proxy and secure services issues we are trying to resolve between our server and our agol portal When that's done, we can get back at collector in disconnected fashion.