The merge process was unable to deliver the snapshot to the Subscriber.

Question

The merge process was unable to deliver the snapshot to the Subscriber.

vefa

Mr or Mrs. 500

Points: 589
More actions
December 17, 2008 at 12:10 am

#204194

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

Viewing 9 posts - 1 through 8 (of 8 total)

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

Jack Corbett SSC Guru Points: 184393 More actions · Answer 1

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
Consultant - Straight Path Solutions
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

vefa Mr or Mrs. 500 Points: 589 More actions · Answer 2

The problem was solved.

It was related server configuratin.

Thanks.

JakDBA SSCommitted Points: 1610 More actions · Answer 3

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

@JayMunnangi

jzapp SSC Rookie Points: 34 More actions · Answer 4

Please don't just say it was a server configuration issue. What part of the server configuration was causing the problem?

Thanks.

rnoldec SSC Veteran Points: 234 More actions · Answer 5

Hi vefa,

Can you share to us what exactly did you do to solve the problem?

vefa Mr or Mrs. 500 Points: 589 More actions · Answer 6

Hi Mate,

It has been long time. It was related to db trigger.

Please check db triggers in subscriber site.

Cheers

gmohanraj SSC Enthusiast Points: 153 More actions · Answer 7

hi,

I didnt have any trigger like , could you tell exactly how did u resolved

jjradha SSChasing Mays Points: 616 More actions · Answer 8

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