sync issue for collector, server throwing a series of errors

Question

Any help would be great,

All issues are related to the System/SyncTools.GPServer

Failed in acquiring Archive Difference Cursor for dataset: wmhb_gis.DBO.DispCampInventory_DP for Replica: DBO.Ags_Fs_1448316015807      [GUID: 5EC4984C-6AE5-47F3-BD31-E6AC8E5BB407]. Time taken: 0.049000 seconds. Underlying DBMS error      [WMHB_GIS.DBO.DISPCAMPINVENTORY_DP][STATE_ID = 2727]. Dataset: wmhb_gis.DBO.DispCampInventory_DP. Replica:      DBO.Ags_Fs_1448316015807.

GaryMacDougall · Answer

Hi

One thing to check out is the 10.3.1 sync patch:

ArcGIS 10.3.1 for (Desktop, Engine, Server) Feature Service Sync Performance Patch | Samples and Utilities

There is an item addressed in this patch that returns the same error message you list above.

thanks

Gary

MiaogengZhang · Answer

Are you running into similar issue like https://community.esri.com/message/378915?

MichaelDavis3 · Answer

You might look into the available memory on your database server - we've found that when using archiving the server needs a ton of RAM to sync.  This is especially true if you are doing photo attachments.