March 27, 2006 at 11:25 am
I am currently working with a a merge replication environment that consists of a large central server with multiple filtered subscriber servers. The replication scenario is pull/push (work happens on subscriber) with 8 publications and 2 of those being filtered.
The following error is occuring on one particular subscriber on one particular subscription when I star syncing:
The process could not query row metadata at the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error number: -2147200996)
I have done quite a bit of research on the net for this error and everything says that I need to increase the merge profile query timeout setting, but currently I have the query timeout set to 3600 as opposed to the default 300. Also, when I kick off the subscription the failure message above comes up in approx 4 minutes, much quicker than the query timeout. I am able to connect between the publisher and subscriber with Query Analyzer and ping with subsecond performance.
I also ran a Profiler trace against the merge replication SPIDs and captured the following transaction:
Exec sp_msgetmetadatabatch
Return
(0)
The system stored proc is not returning anything from the meta tables, like the error says. I bounced the SQL service on the subscriber in case a bad query plan was cached. Nevertheless the subscriber failed again with the same error when I kicked off the sync again.
Does anyone have any suggestions for addressing this issue beyond upping the query timeout in the agent profile?
Thanks,
Chris
March 30, 2006 at 8:00 am
This was removed by the editor as SPAM
June 30, 2007 at 1:21 am
Not sure if you found your answer yet, but what I did was delete the subscription at both the publisher and subscriber and re-ran it and it worked fine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply