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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » The merge process was unable to deliver the...

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

Rate Topic

Display Mode

Topic Options

Author

Message

vefa

Posted Wednesday, December 17, 2008 12:10 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, October 21, 2010 6:11 PM
Points: 57, Visits: 100

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

Jack Corbett

Posted Wednesday, December 17, 2008 7:28 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

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

vefa

Posted Wednesday, December 17, 2008 9:09 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, October 21, 2010 6:11 PM
Points: 57, Visits: 100

The problem was solved.
It was related server configuratin.

Thanks.

Post #621761

JakDBA

Posted Thursday, July 01, 2010 5:06 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 10, 2013 8:31 AM
Points: 38, Visits: 164

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

jzapp

Posted Wednesday, August 04, 2010 9:53 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 2:07 PM
Points: 10, Visits: 46

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

Thanks.

Post #963579

rnoldec

Posted Monday, August 09, 2010 8:19 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 09, 2012 5:30 AM
Points: 2, Visits: 24

Hi vefa,

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

Post #966327

vefa

Posted Saturday, August 14, 2010 7:40 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, October 21, 2010 6:11 PM
Points: 57, Visits: 100

Hi Mate,
It has been long time. It was related to db trigger.
Please check db triggers in subscriber site.

Cheers

Post #969445

gmohanraj

Posted Wednesday, August 22, 2012 9:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:10 AM
Points: 2, Visits: 36

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

Post #1348505

marcelo miorelli

Posted Wednesday, September 19, 2012 11:08 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 15, 2013 6:28 AM
Points: 14, Visits: 176

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 »

Permissions