Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The merge process was unable to deliver the snapshot to the Subscriber. Expand / Collapse
Author
Message
Posted Wednesday, December 17, 2008 12:10 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, September 8, 2013 8:30 PM
Points: 57, Visits: 102
Hi All,

I setup a merge replication between SQL2005.

I have two subscribers. First subscriber is working perfectly, but the second is not.

I am getting below error when Sync process is running. I am using the same security and same subscription features.

I will appreciate if someone can help in this manner.

Thanks.

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_621A4D6A4DF547A096F0FB98C63C1FFE', because it does not exist or you do not have permission. (Source: MSSQLServer, Error number: 15151)
Get help: http://help/15151
Post #620984
Posted Wednesday, December 17, 2008 7:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 4:51 PM
Points: 11,264, Visits: 13,023
First I should say that I am not a replication expert, but based on the error message it appears there is a difference in the security setup on the 2 subscribers. What account(s) are the SQL Server and SQL Server agent accounts running under? Are they domain accounts? Do they all have rights to access each other?

Those are some of the questions that pop into mind and those answers have fixed similar problems, not necessarily replication, for me in the past.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #621214
Posted Wednesday, December 17, 2008 9:09 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, September 8, 2013 8:30 PM
Points: 57, Visits: 102
The problem was solved.
It was related server configuratin.

Thanks.
Post #621761
Posted Thursday, July 1, 2010 5:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:07 PM
Points: 39, Visits: 187
HI friend how did u solve the error, now i am facing the same, i am working on SQL 2008 sever.

Please let me knkow the configuration changes you have done... URGENT
Post #946076
Posted Wednesday, August 4, 2010 9:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 6:11 AM
Points: 10, Visits: 64
Please don't just say it was a server configuration issue. What part of the server configuration was causing the problem?

Thanks.
Post #963579
Posted Monday, August 9, 2010 8:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:02 AM
Points: 2, Visits: 27
Hi vefa,

Can you share to us what exactly did you do to solve the problem?
Post #966327
Posted Saturday, August 14, 2010 7:40 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, September 8, 2013 8:30 PM
Points: 57, Visits: 102
Hi Mate,
It has been long time. It was related to db trigger.
Please check db triggers in subscriber site.

Cheers
Post #969445
Posted Wednesday, August 22, 2012 9:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 17, 2013 10:41 PM
Points: 3, Visits: 42
hi,
I didnt have any trigger like , could you tell exactly how did u resolved
Post #1348505
Posted Wednesday, September 19, 2012 11:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 3:31 AM
Points: 15, Visits: 289
hi there,
same error here,
it happens pretty often actually.
sometimes it soves itself out though.

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
The process could not bulk copy into table '"dbo"."MSmerge_contents"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)

I am using SQL Server 2005 SP2.
64 Bits.

please let me know anything if you found any solution for this problem.
thanks and regards
marcelo
Post #1361515
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse