topic Re: Failure to sync related table in ArcGIS Collector Questions

Failure to sync related table

JenniferSwitzer1 — Tue, 15 Nov 2016 16:32:31 GMT

I have a point feature service to collect sign poles with a related table (1:M relationship class using Global ID as primary key) to collect the street signs attached to each pole. The services are hosted through our ArcGIS Server. I can take my map offline, create the pole features and add related sign entries. However, when I try to sync my edits when I am connected to WiFi, the pole features come through but the related sign entries do not. I get this message - "Error code '500': Failed to Synchronize". I am using a Windows Surface tablet (Windows 10). Any ideas why this is happening? Would it have anything to do with the Global IDs? Thank you

Re: Failure to sync related table

JayantaPoddar — Tue, 15 Nov 2016 18:09:54 GMT

What version is your ArcGIS Server?

Have you working with a Relationship Class? Creating a simple relationship class

Re: Failure to sync related table

JenniferSwitzer1 — Tue, 15 Nov 2016 18:46:03 GMT

I am using ArcGIS Server 10.4.

I have a 1:M simple relationship class using Global IDs as the primary key.

The data is in an enterprise SQL Server database, version 2014.

Re: Failure to sync related table

JenniferSwitzer1 — Wed, 16 Nov 2016 15:27:19 GMT

I talked to someone at Esri and the problem was that I was using the GlobalID field as both the primary and foreign keys in the feature class and table. What you must do is create a GUID field in the table to use as the foreign key. After adding the GUID field, I created a new relationship class using GlobalID as the primary key and then the GUID as the foreign key. I then republished my feature service and everything is working and syncing with no problems.

This blog describes it well ... GUIDs and Global ID Fields for Related Tables in ArcPad | ESRI ArcGIS Collector Desktop Mobile|RIA Mobile GIS Hobart Tas…

Thanks