?
Solved

SQL 2000 server replication error

Posted on 2010-01-06
2
Medium Priority
?
355 Views
Last Modified: 2012-05-08
Hi, all,

I ran into a merge replication error on a SQL 2000 server when executing the merge agent that looks like this:

The process could not query row metadata at the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error number: -2147200996)
---------------------------------------------------------------------------------------------------------------
The merge process timed out while executing a query. Reconfigure the QueryTimeout parameter and retry the operation.
(Source: SERVER (Data source); Error number: 0)
---------------------------------------------------------------------------------------------------------------
The process was successfully stopped.
(Source: Merge Replication Provider (Agent); Error number: -2147200996)

What I did I changed in the merge agent profile the parameter to Large Batch to increase the query timeout o a bigger value, 2000, and seemed to be OK as it ran for 2.5 hours but after that the error was showing again.

Any ideas?

Thank you.
0
Comment
Question by:Zberteoc
2 Comments
 
LVL 15

Accepted Solution

by:
MohammedU earned 2000 total points
ID: 26193453
Try creating new merge agent profile with max time out setting and change the setting for the following with low values....Did you check the blocking if not please check if there is any blocking going one...

-DownloadGenerationsPerBatch  
-DownloadReadChangesPerBatch  
-DownloadWriteChangesPerBatch  
-UploadGenerationsPerBatch  
-UploadReadChangesPerBatch  
-UploadWriteChangesPerBatch  
0
 
LVL 27

Author Closing Comment

by:Zberteoc
ID: 31673645
Indeed it was a locking on the subscriber side. Finding what caused it was an entirely other issue though.

Thanks for your posting.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

616 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question