Sync fails at 10.5.1 with 500 error

6060
27
Jump to solution
09-03-2017 08:05 PM
FraserHand1
New Contributor III

Hi,

 

We have just upgraded a customer today to 10.5.1 from 10.4.1 and we have found that syncing with Collector now fails. The edits get pushed up to the enterprise geodatabase but do not come down from ArcGIS Server from the enterprise geodatabase.

 

After investigating it appears that during the sync process the GP tool is looking for the wrong schema in SQL Server for some of the temporary tables that get created.

 

  • We have SDE schema with geodatabase repository
  • We have GISADMIN schema with feature classes
  • ArcGIS Server runs as Domain\server_ArcGIS (OSA authentication)
  • Feature classes have archiving enabled

If we go offline with Collector the replica creation works fine, and if we sync, the edits get pushed up from Collector but it does not refresh the data from the enterprise geodatabase to the mobile device – we get a 500 sync failed error.

 

NOTE: The feature class is GIS.GISADMIN.SomePoints – syncing fails – ArcGIS Server has correct editing permissions assigned

 

If we give the ArcGIS Server creation rights on the enterprise geodatabase and create the feature class to be GIS.” Domain\server_ArcGIS”.SomePoints then all works as expected. If we set ArcGIS Server to connect to the enterprise geodatabase as the data schema owner (as a db connection GISADMIN) all works as expected.

This workflow was fine 10.1 through 10.4.1 – this customer has been using it.

 

Please note that versioned feature classes work as expected. It is just an issue with archiving.

 

Also be aware we have applied the recent SQL Server Permissions patch (10.5.1)

Has anyone hit this? This seems like a bit of a biggie.

 

Many thanks,

Fraser

1 Solution

Accepted Solutions
JoeHershman
MVP Regular Contributor

The issue is at 10.5.1 and 10.6 not at 10.5.  Syncing works at 10.5.  There is a 10.5 patch associated to sync at 10.5 Esri Support 10.5 (10.5.1) .  This fixes a bug that occurs if you are using a workflow that includes copy and register of your replicas.  Sync will fail without the patch is the user registering the replica did not create the replica or is an admin

Thanks,
-Joe

View solution in original post

27 Replies
JoeHershman
MVP Regular Contributor

I have observed the exact same issue, but did not think to test the scenario you found that works.

See: Download Sync not working in AGS 10.5.1 .  In my case it is a Runtime application that presents the identical issue.  I honestly question whether esri tests their software at all.  This is the standard configuration, how can it never have been tested.  

Thanks,
-Joe
JustinBurdette
New Contributor III

We also tried to upgrade to server 10.5.1 and found the same problems so we rolled back to 10.5. Does ESRI know this is a huge problem? I can't find any bug reported that mentions this. It is a show stopper for sure if you do any offline collector editing and suddenly the sync is not working.

FraserHand1
New Contributor III

Hi Justin,

I have been trying to work through this will Esri Inc support but at this point they haven't been able to reproduce - even though I have done it consistently in Azure and on various customer sites. Have you logged a support call and shraed your workflow with Esri?

Thanks,

Fraser

JustinBurdette
New Contributor III

No, we did not, after the problem was discovered we saw the 2 other posts on geonet and decided to rollback to 10.5, assuming that ESRI knew about the issue.

FraserHand1
New Contributor III

Hi, AFAIK they didn't - the issue is in the sync tools - when it is looking for the onprem changes it is looking in the wrong schema for a temp table - in SQL anyway - which causes it to fail. I would most definitely log an issue and also highlight you had to roll back to ensure your workflow didn't break.

Ta

Fraser

JoeHershman
MVP Regular Contributor

We have reported the issue with support.  I do not know status nor have a formal bug.  I have sent them this link to see it is occurring with others

Thanks,
-Joe
JonathanQuinn
Esri Notable Contributor

Full disclosure, I rarely if ever work with syncing, but throwing this out there in case it's helpful; getting SDEINTERCEPT logs may help identify if there's a invalid SQL statement that's being sent.  If it's schema related, you should be able to identify this in the SDEINTERCEPT logs:

How To: Diagnose ArcSDE connection and performance issues using SDEINTERCEPT 

They may help Support log a bug if required.

JoeHershman
MVP Regular Contributor

When things work on versions 10.3.1 through 10.5, with the same exact setup it certainly makes one think it has something to do with 10.5.1.

Thanks,
-Joe
JustinBurdette
New Contributor III

ESRI ever resolve these issues for any of you? I'd like to get our server up to 10.5 if the sync functions would work.

0 Kudos