URGENT Merge Replication: missing rows at Publisher and Subscriber: no conflicts

We have SQL Server 2000 with merge replication at a Publisher and subscriber.

We have some records getting deleted at Publisher and Subscriber and no conflicts are logged.

We have tried the compensate_for_errors setting and this has had no effect.

This is causing serious data corruption and has now become an URGENT issue. Out tech team are almost out of ideas.

Has anyone experienced this or have any ideas as to what to check next

WJ

What do you mean records getting deleted

Do you make inserts at the subscriber and after merging, you find those rows deleted

If so it could be happening because those rows are violating some constraint (check, PK-PK or other constraints) at the publisher and if you have compensate_for_errors=true, those rows could be deleted at the subscriber.

If that is the case you should turn off compensate_for_errors

Additionally you should look if there are filters (subset or merge filters) defined on the publication and if so, verfy that these newly inserted rows do not violate (or not qualify) such filters. If they do, then they could be deleted too.
Maruthi Ravuri

MSSQL Server 2005 Replication Step by Step

http://blog.csdn.net/longrujun/posts/783357.aspx
cdisdero
longrujun, I did not see the blog post talk about this specific issue and this is SQL 2000.
URGENT Merge Replication: missing rows at Publisher and Subscriber: no conflicts