Merge replication problem

  • I have a publisher and 2 subscribers, and having merge replication between these 3 servers. One of the merge replication to the server is happening, while the other is happening sometimes, but sometimes, the merge agent just stops when saying that the "The process could not query the row metadata at subscriber", sometimes it gives the error as "The subscription to the database is invalid." I have a cyclic redundancy in running the agemt, as i run the agent from the step 3 also. But then also i am not getting y it is getting stopped. If someone knows abt this please let me know.

    Regds

    Jay

  • This was removed by the editor as SPAM

  • I've seen that message a couple of times myself and as far as I know it's a locking issue. The mergeagent tries to read some records at the subscriber which are locked by another process. Usually if you retry it a couple of minutes later it works again.

    M.

    [font="Verdana"]Markus Bohse[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply