SQL 2000 server replication error

Posted on 2010-01-06
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.
Question by:Zberteoc
    LVL 15

    Accepted Solution

    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...

    LVL 26

    Author Closing Comment

    Indeed it was a locking on the subscriber side. Finding what caused it was an entirely other issue though.

    Thanks for your posting.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how the fundamental information of how to create a table.

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now