Post reply

Metadata Cleanup error in Merge Replication

  • October 21, 2008 at 12:41 pm

    #154831

    Hi All,

    In Sql server 2005, I have merge replications between two different servers through internet, in many merge publications i received the following error.

    I know troubleshooting. but to avoid it in future, need to know the cause for this kind of error. please any one of you guide me to protect from this error.

    the error message is:

    "The Merge agent failed after detecting that retention-based metadatacleanup has deleted metadata at the publisher for changes not yet sent to the subscriber. You must reinitialize the subscription [without upload]. [Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402]."

    with thanks and regards,

    Tharves

  • August 24, 2012 at 1:15 pm

    #1529923

    I'm facing the same error. May you please guide me how had you fix it.

    The scenario with me here is, I'v one Subscriber and Publisher. Publisher machine (Central Server) went down and was unavailable for more than 14 days. Meanwhile, application was running at Subscriber end and generating data on daily basis. Finally Publisher machine was fixed but the DB needs to be restored from last backup (one day before the Publisher went down)

    Here is the error reported by every replication tasks that I try to restart:

    The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be lost leading to non-convergence.

    This could be due to the subscriber not having synchronized within the retention period, or because of one of the replicas being restored to a backup older than retention period.

    Subscriber is detecting that the Central database is older now than the maximum retention period (14 days). Since the Central server was restore with old backup (16 days) therefore 2 days older than the maximum retention period of 14 days.

    Will the solution Graham will work if I update sysmergesubscriptions at Subscriber with current values in Publisher?

    I'v noticed that at Central Server (Publisher) in sysmergesubscriptions table there are NULL values for all sentgen, sentguid, recgen and recguid for subid = pubid. So what values will be SET in UPDATE statement at Subscriber?

    Thanks

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

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