none
Mark for Re-Initialization is breaking merge pull subscribers after adding new filter to article

    Question

  • I got situation where i have to add filter to existing articles in merge publication, After adding filter it asks for generating new snapshot and mark for Re-Initialization of subscribers.

    Once this step is complete subscribers starts breaking while synchronization,

    Adding new articles and generating new snapshot does not breaks subscribers. It only happens when we add new filter to any articles. It seems it is breaking while re-initializing subscribers only.

    It gives different error

    "snapshot is obsolete" and then starts throwing meta data mismatch error.

    Merge Agent is configured using RMO for pull subscription using web synchronization.

    Any help would be appreciated.


    HiSam

    Friday, July 12, 2013 10:42 AM

All replies

  • Hi,

    Check whether the snapshot location is changed.

    The below post might help you,

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a60a613e-184a-4817-9cfe-a729bfc103dd/snapshot-files-obsolete


    Thanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.

    Friday, July 12, 2013 2:17 PM
  • Snapshot location is not changed. 

    Snapshot-files-obsolete error appears only once after that it went off with other error message as "meta data mismatch",

    I can get rid of metadata mismatch error as well by setting recgen,sentgen ,recguid.sentguid between publication and subscription, but my question is by using Mark for Reinitialization why all subscribers starts breaking, 

    Is there any other way round which i should use to add filters to my existing articles in merge publication so that my subscribers are happy?


    HiSam

    Saturday, July 13, 2013 4:25 AM