Conflicts in merge replication, records deleted

Conflicts in merge replication, records deleted

Post by Magnus Granbe » Wed, 30 Jan 2002 20:06:56

I have one SQL Server 7 publisher and four SQL Server 7 subscribers
with merge replication (pull). From time to time I get conflicts in
tables with the reason, that a record which was inserted in the
subscriber database couldn't
be inserted in the publishers db due to a FK constraint. The record
then seems to be deleted from the subscriber. I figure the conflicts
occur because the FK constraints are enabled during replication. I
then use Conflict Viewer to insert the conflicting data into the
publisher db and it works fine. The FK conflicts don't exist anymore
so I guess the replication order (table order) must have caused the
problem. Atleast that's what I thought.

But... When I run the merge replication again the same conflicts are
back and the conflicting records are deleted from the publisher! If I
instead script the conflicting data into the publisher's db and then
run the merge replication everything works fine.


Should FK constraints be enabled during replication?
How come the conflicts come back when they are resolved successfully?
Why are the conflicting records deleted?



1. delete stament conflicted ... in Merge Replication

I have two NT 4 servers with SQL and a Merge Replication of some tables
of a DB. The Snapshot agent and the Merge Agent seam to be working fine.
But when I try to delete a record on the Subscriber I receive the
following error.
[Microsoft][ODBC SQL Server Driver] [SQL Server] DELETE statement
conflicted with Table reference constrain "FK_...." The conflict ocurred
in database ... table ...

Does any one knows what is going on ?


2. saving word doc into sql

3. Merge replication deleting records on subscriber after sync

4. error 2008 and primary fil group

5. Records getting deleted in merge replication on Synchronization after applying S

6. class recommendations in D.C., Virginia area???

7. Merge Replication Deleting Records

8. Sybinit freezing on 10.01 to 10.02 upgrade

9. Merge Replication deleting records intermittently

10. URGET !!Merge Replication deleting records

11. Merge Replication deleting records

12. Merge replication deletes new records on device

13. merge replication doesn't merge records