Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    70

    Unhappy Unanswered: Merge Replication Problem

    Hello Group,
    (I have posted this query in Microsoft Newsgroup also, but I did not get any response. Please respond. Thanx)
    I have setup a Merge Replication between two
    servers. (SERVER_PUBLISH is the Publisher and
    SERVER_SUBSCRIBE is the Subscriber).
    I was periodically getting Network errors, I tried looping
    step 3 (both on success and failure) of the job back to
    step 1. I have also given a higher number of retry
    attempts and interval, but still at times I get this error
    (mentioned below) and my replication stops. Is there a
    way to automatically resume replication after such errors
    occurs.

    Please Help. This is very urgent.

    Thanks in advance
    Anand

    Part of the error log is mentioned below =>


    Downloading data changes to the Subscriber
    Percent Complete: 4
    No data needed to be merged.
    Percent Complete: 4
    Uploading data changes to the Publisher
    Percent Complete: 4
    No data needed to be merged.
    Percent Complete: 4
    Downloading data changes to the Subscriber
    Percent Complete: 4
    No data needed to be merged.
    Percent Complete: 4
    Uploading data changes to the Publisher
    The merge process could not apply the replication metadata.
    The process could not enumerate changes at
    the 'Subscriber'.
    The process could not enumerate changes at
    the 'Subscriber'.
    The merge process encountered an unexpected network error.
    The connection to Subscriber 'SERVER_SUBSCRIBE' is no
    longer available.
    Percent Complete: 0
    The merge process could not apply the replication metadata.
    Percent Complete: 0
    Category:NULL
    Source: Merge Replication Provider
    Number: -2147200968
    Message: The merge process could not apply the replication
    metadata.
    Percent Complete: 0
    Category:COMMAND
    Source: Failed Command
    Number: 0
    Message: {call sp_MSproxiedmetadata(?,?,?,?)}{call
    sp_MSproxiedmetadata(?,?,?,?)}{call sp_MSproxiedmetadata
    (?,?,?,?)}{call sp_MSproxiedmetadata(?,?,?,?)}{call
    sp_MSproxiedmetadata(?,?,?,?)}{call sp_MSproxiedmetadata
    (?,?,?,?)}{call sp_MSproxiedmetadata(?,?,?,?)}
    Percent Complete: 0
    CategoryQLSERVER
    Source: SERVER_SUBSCRIBE
    Number: 11
    Message: General network error. Check your network
    documentation.
    Percent Complete: 0
    Category:NULL
    Source: Merge Replication Provider
    Number: -2147199469
    Message: The process was successfully stopped.
    Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
    Disconnecting from Publisher 'SERVER_PUBLISH'
    Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
    Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
    Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
    Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
    Disconnecting from Publisher 'SERVER_PUBLISH'
    Disconnecting from Publisher 'SERVER_PUBLISH'
    Disconnecting from Publisher 'SERVER_PUBLISH'
    Disconnecting from Publisher 'SERVER_PUBLISH'
    Disconnecting from Publisher 'SERVER_PUBLISH'
    Disconnecting from Distributor 'SERVER_PUBLISH'

  2. #2
    Join Date
    Aug 2003
    Location
    Mesquite, TX
    Posts
    2

    Re: Merge Replication Problem

    Try setting up the Merge Agent to run on a schedule of every one minute. That way, it will start up again even if it has failed. Also, please do not say your request is "urgent". All of us that ask for help feel our requests are "urgent".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •