locked
Merge Agent fails to deliver snapshot RRS feed

  • Question

  • SQL Server 2005 standard edition (2005 - 9.00.5057.00 (Intel X86)) publishing a merge publication to sql express 2005 (2005 - 9.00.5000.00 (Intel X86) )

    The snapshot agents runs but fails to complete and deliver the snapshot.

    I have placed the:

    replication scripts

    trace files

    output of verberose logging

    at the bellow link, any help is highly appreciated, thanks ahead.

     http://www.filesend.net/download.php?f=1001e872bc70d370b06cac3991f3a7c0.

    Error messages:
    The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
    Get help: http://help/MSSQL_REPL-2147201001
    Cannot find the object 'MSmerge_ctsv_666A7278A11348C2BF86DF4D1EAA3270', because it does not exist or you do not have permission. (Source: MSSQLServer, Error number: 15151)
    Get help: http://help/15151


    Yaniv Etrogi
    site | blog | linked in | mail
    Please click the Mark as Answer button if a post solves your problem! or Vote As Helpful

    Wednesday, October 31, 2012 6:02 PM

Answers

  • This problem was found and corrected;

    Since the subscriber machine was replaced, the server name in sys.servers was not matching the replication scripts. Once the server name was corrected using sp_dropserver and sp_addserver the issue was resolved.

    Silly issue, big problem and once again Microsoft's logs...


    Yaniv Etrogi
    site | blog | linked in | mail
    Please click the Mark as Answer button if a post solves your problem! or Vote As Helpful

    Thursday, November 8, 2012 10:59 AM