I was able to resolve this issue by taking the DB Offline using the SQL manager tools NOT ArcCat. Once I brought it back online everything worked as expected. Until the next time I say.... So the question is what is causing it.
I am experiencing the same problems described in this year old thread. Periodic download and sync failures using offline collector. I can only resolve by downing the SQL Service in management studio as well. Can someone from Esri shed light on why this is occurring?
Have you checked that all of your features are within the limits of your coordinate system? We started getting this error and noticed that we had some new point features that were plotting somewhere in space. Once we fixed these features we were able to sync again. This may be why changing to a Web Mercator projection has worked for some people.
Good to know that a couple years later and in version 10.4.1 and using ArcGIS Pro to publish this error still occurs. Would be nice if someone from esri could define the issue and even better get it fixed
And some of us are still having this error...
Same here. Still having the problem.