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 |
|
readysetstop
Posting Yak Master
123 Posts |
 Posted - 2007-07-03 : 15:40:30
|
| I have one central publisher server and several remote merge pull boxes. On random remote servers, at random times, replication will fail. The data is inconsistent between the master publisher and the remote merge pull subscribers. (i.e., The subscribers have more recent data than the publisher.)There are no error messages generated, and it's only for one article. The rest seem to update fine.I am a complete noob when it comes to replication. How would I even start troubleshooting this?Any assistance is appreciated. Thanks.-D.____________________________________________________________________________________"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-04 : 00:08:31
|
| Checked merge agent details? |
 |
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-07-04 : 18:50:09
|
| For what?____________________________________________________________________________________"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-04 : 21:20:09
|
| For details of what happened. |
|
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-07-04 : 23:14:10
|
| All the agent logs say is that "no data needed to be merged" which is untrue. The articles are different on the publisher and the subscriber. There are no error messages of any kind. I am wondering if there is an issue with the msmerge_contents or msmerge_tombstone tables, though I can't find any evidence of an issue in those. I'm going to go back an check the RowGUID's tomorrow (after the holiday.)____________________________________________________________________________________"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide |
|
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-07-05 : 16:13:01
|
| It got weirder.Turns out that somehow the table was not marked for replication in master..sysobject, though it looked fine in EM. The blame is currently being laid on a third party app that we're using here. I have no idea. I'm calling this one closed.Thanks.-D.____________________________________________________________________________________"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide |
|
|
|
|
|
|
No errors. No replication, either...