Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
roel_vz
Starting Member
16 Posts |
 Posted - 2008-03-25 : 12:32:31
|
| I have set up merge replication between 1 publisher and 9 subscribers (all push subscriptions). Distributor and publisher are located on the same machine.Although everything seems to work fine from the outside (most of the time), there are a lot of conflicts in the conflict table for the replication. They appear all the time. There are a lot of "download insert failed" conflicts. They always look like in the following three screenshots:[url]http://www.tronk.be/conflicts/conflict1.JPG[/url][url]http://www.tronk.be/conflicts/conflict2.JPG[/url][url]http://www.tronk.be/conflicts/conflict3.JPG[/url]In the same way, there are also many "upload insert failed" conflicts.In addition to this, there are some "update conflict"s (but a lot less than the other conflicts). Some of them show the same row at both sides:[url]http://www.tronk.be/conflicts/conflict4.JPG[/url]Others show a different row at the both sides:[url]http://www.tronk.be/conflicts/conflict5.JPG[/url]The only thing that causes a real problem is the last screenshot, although I don't understand why the other conflicts are there (the inserst statements actually seem to happen anyway, even though there are conflicts). In case of the last screenshot, I can't find any place where an UPDATE actually happens at APP-STB, while I can clearly pinpoint the UPDATE at the other side (which is what actually comes from our program).One more thing, the system is running on its limits, but all replication seems to be working fine.I would appriacte any help or comments very much. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-25 : 12:56:43
|
| I would definitely start with this article:http://msdn2.microsoft.com/en-us/library/ms147911.aspx |
 |
|
|
|
|
|
Conflicts in merge replication