Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Merge replication problems - Subscriptions expiring prematurely


Merge replication problems - Subscriptions expiring prematurely

Author
Message
Doug Elwood-471888
Doug Elwood-471888
SSC-Addicted
SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)

Group: General Forum Members
Points: 418 Visits: 118
Environment:
Publisher: SQL 2000 EE 8.00.2039 on Windows 2003 (32-bit)
Subscribers: SQL 2000 EE 8.00.2040 or 8.00.2039 on Windows 2003 (both 32-bit and 64-bit subscribers)

We have an 18 subscriber merge replication infrastructure. It ran pretty well for most of the last two years until early December. We applied Windows updates on a number of our subscribers in early November and our problems cropped up shortly afterwards. (Windows Updates on 11/07/2010 and 01/09/2011)

Problem #1: (11/23/2010)

Our merge subscriber indicated a problem inserting a row into the MSmerge_genhistory table - after this failure, the subscription was marked as "expired". This is a "pull" merge subscription with no prior history of these issues.

Problem #2: (11/30/2010)

Almost exactly a week later, our same subscription had the same behavior as described in problem #1.

Problem #3: (01/09/2011)

Nine of our merge replication subscriptions (all "pull") show up as "expired". I rebuilt them all as "push" instead. This was the day we installed Windows Updates. (the system from problems 1 & 2 was impacted - but on a different publication)

Here is the list of Windows Updates and the date they were installed:

11/07/2010:
KB979687
KB2416451
KB2378111
KB2345886
KB2296011
KB2279986
KB2387149
KB981957
KB2360131
KB2360937
KB982132

01/09/2011:
KB2443105
KB2423089
KB2436673
KB2296199
KB2467659
KB2416400
KB2440591

I am dying to know if this is just really bad luck or if any of the above patches might have played a role in my problems.

Anyone have any ideas? I can get more background information if required.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search