Delay in Project Sync

If a project has been stuck in In Progress sync state for a long time without any new files being downloaded, it may be stuck try to read from a TCP connections. As a workaround, the TCPView tool may be used to close the connections and force the service to resume syncing.

• If not available, download the TCPView tool from:

  https://learn.microsoft.com/en-us/sysinternals/downloads/tcpview

• Extract the zip file.

• Run tcpview64.exe.

• Select the TCP connections opened by Spectrum.Site.SyncService in Established state.

  

• Right mouse button click to display the the context menu.

• Select Close connection on each Established connection to force the service to retry the current database session.

Another workaround is to restart the whole service, but this causes the service to restart syncing from the beginning.