Replication Merge

  • Hi,

    I get the following error, when i click on Agents and view the error details, please let me know how to solve.

    The process could not deliver delete(s) at the 'Publisher'.

    (Source: Merge Replication Provider (Agent); Error number: -2147200988)

    ---------------------------------------------------------------------------------------------------------------

    The merge process timed out while executing a query. Reconfigure the QueryTimeout parameter and retry the operation.

    (Source: 02 (Data source); Error number: 0)

    ---------------------------------------------------------------------------------------------------------------

    The process was successfully stopped.

    (Source: Merge Replication Provider (Agent); Error number: -2147200988)

    Infact i tried to have the parameter QueryTimeOut as mentioned, even then dint work.

    With Regards

    Dakshina Murthy

  • Hi,

    Your Publisher is unable to download the Delets from subscriber.

    What was the query time you have set? you can try increasing upto 3000 secs. if you are having more than the specified one its ok.

    And you can try increasing the Download Read/Write changes perbatch to 1000 where default value is 100. And changes per history to 1000.

    @JayMunnangi

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

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