there are a few reasons I have come across for non-convergence:
(1) Firstly when the filter was set to 1=2 and inserts were made while the
merge agent was running
(2) If you bulk insert the rows and choose the defaults, then FIRE_TRIGGERS
is false and consequently the rows are not added to MSmerge_contents.
(3) compensate for errors problem (see
If a change from publisher fails to get applied at the subscriber (for some
reason, PK,FK,CHECK,etc constraints) it undoes the change at the publisher.
So a insert from publisher when fails at the subscriber gets deleted at the
publisher too. Similary a delete from publisher which fails at the
subscriber, it gets re-inserted at the publisher.
In any of these cases, you need to run sp_addtabletocontents to include the
rows then resynchronise. Alternatively you can use sp_mergedummyupdate for a