Symptoms
Did your SMS_OBJECT_REPLICATION_MANAGER component shows a lot or 6004 MessageIDs with the following description: “Object Replication Manager failed to process Object changes. These changes will be retried on next processing cycle.”?
Cause
By design, maybe.
Resolution
Run the following query in SQL Management Studio (Warning! modifying the database directly may not be supported by Microsoft. Do this on your own risk.):
SELECT ca.UniqueID,c.CollectionName
FROM vClientSettingsAssignments as ca LEFT JOIN collections AS c ON ca.CollectionID=c.SiteID
WHERE CollectionName = NULL
This will show collection name/s for all active assignments to collection/s that do not exist anymore.
If you have any, copy the UniqueID and run the following query:
DELETE FROM vClientSettingsAssignments
WHERE UniqueID = ‘{UniqueId here}’