What is the best workflow for synchronising edits which are managed in SDE to ArcGIS Online without breaking the sync to Collector? We have one dataset of around 90000 polylines and another polygon dataset of around 20000 polygons, amongst other feature classes.
Our data is published to our Portal, and I have tried establishing a collaboration. It worked fine the first sync, but now fails every subsequent time with a message "1 out of 2 failed". Our Portal is 10.6.1 and is not public-facing due to security restrictions.
When we try to append, it causes error when users try to sync, so we would have to ask all users of Collector to check their edits back in. Similiarly, if we wanted to republish the service through ArcGIS Pro, we would lose all our configuration, and the sync.
Please, any suggestion are welcome, as we need to be able to update these records on a regular basis and need to implement a rock-solid workflow to do this! Thanks in advance!