none
The merge process could not enumerate changes at the 'Subscriber'.

    Question

  • I have two SQL 2005 Standard servers using merge replication, and out of the blue started getting failure notices regarding "The merge process could not enumerate changes at the 'Subscriber'." I turned on verbose logging and noticed the following section:

    2006-04-19 12:53:33.227 Category:NULL
    Source:  Merge Replication Provider
    Number:  -2147200999
    Message: The merge process could not enumerate changes at the 'Subscriber'. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.
    2006-04-19 12:53:33.227 The Merge Agent was unable to update information about the last synchronization at the Subscriber. Ensure that the subscription exists at the Subscriber, and restart the Merge Agent.
    2006-04-19 12:53:33.227 The merge process was unable to update last synchronization information at the Publisher.

    Using Profiler on both sides, I don't see anything out the ordinary during the replication process until there are two calls in a row to the stored procedure sp_MSadd_merge_history90, where the second one is storing the error message listed above.

    Any ideas?

    Thanks,

    Scott Davis

    Wednesday, April 19, 2006 1:37 PM

All replies

  • Are you still hititng this issue?  I've seen it happen when machine resources are low, or agent timeout limit is exceeded (although not the correct behavior).
    Monday, April 24, 2006 5:18 PM
    Moderator
  • I wasn't able to resolve the issue. I opened up a support call with MS Tech support to no avail as well. Last night I removed replication, manually merged the data between the two databases and setup replication again, and the issue is gone. Just wish I could have figured out the root cause in case it happens again.
    Monday, April 24, 2006 5:50 PM
  • I have the same problem with my replication.

    After i set up a merge replication ( with a dynamic snapshot) the merge process works Ok.

    After a while i get this error mesage and the only thing that is solving my problem is to set up subscriber again.

    I replicate 21 tables with a Server Type Subscriber and all tables have downloadonly option.

    Can this be the problem ? 

    Wednesday, May 31, 2006 10:28 AM
  • This is bad bug, and would need some debugging, I'd call support.
    Wednesday, May 31, 2006 6:37 PM
    Moderator
  • The "merge process could not enumerate changes at the subscriber" is a very generic error message. It could be caused by many different things like timeout to network errors. Unless we can get more info, we cannot determine whether it is a serious problem or not.

    Try getting more info from Profiler with more granular tracing. Also increase the verbosity of the merge output with OutputVerboseLevel 3 and post back the output. Maybe that will help us in narrowing down the issue.

    Thursday, June 01, 2006 5:43 AM
  • If you had that case sometimes then it could be due to bad conectivity and many other reasons, but if you have it all the time, then it is possible that it is something worse.

    I had both types of situations with my merge replication, solution for constant troubles in my case was that it all went away when I runned dbcc checkdb. To be more precise I tried dbcc checkdb but it failed to go through whole db. Then I did dbcc checkdb with repair fast and it repaired what was wrong. After that everything was ok.

     

    Thursday, June 01, 2006 12:30 PM
  • I am too getting this message little too often. My worry is why it does not re-try. is there any setting to re-start after the failure
    Wednesday, March 14, 2007 10:49 AM
  • Even I couldnt get Exact Error

    Regards Mohanraj..


    • Edited by Mohanraj G Friday, July 05, 2013 2:27 AM -----
    Thursday, July 04, 2013 6:04 PM