SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Merge Replication across internet, "The merge process was unable to deliver the snapshot to the...


Merge Replication across internet, "The merge process was unable to deliver the snapshot to the Subscriber. "

Author
Message
dakshinamurthy-655138
dakshinamurthy-655138
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1998 Visits: 1056
Hi,

I am getting the following error message while configuring replication across internet, please suggest.


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

With Regards
bruno.fontoura
bruno.fontoura
SSC-Enthusiastic
SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)

Group: General Forum Members
Points: 171 Visits: 118
Hi,

Are you using a virtual directory to delivery the file?

Could you send some more details about the publishing you're using?

Att,
Chusky
Chusky
SSC-Enthusiastic
SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)

Group: General Forum Members
Points: 152 Visits: 44
Hi

I'm getting the same error you told here. Had you been able to fix it?

I'm totally desperate...

Thanks in advance

Jesus
bruno.fontoura
bruno.fontoura
SSC-Enthusiastic
SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)

Group: General Forum Members
Points: 171 Visits: 118
Does that replication ever worked properly before?

Please send more details about the configuration.

Att,
Chusky
Chusky
SSC-Enthusiastic
SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)

Group: General Forum Members
Points: 152 Visits: 44
Hi Bruno

Thanks for your help.

I'll fixed already. Making changes on my publication I've found that the default snapshot folder was in format C:\MyFolder\MySnapshotFolder
I've changed it by an UNC format (\\MYSERVER\MySnapshotFolder) and I don't get the error anymore.
I hope my experience helps to someone...

Thanks again Bruno
bernard.jadot
bernard.jadot
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 2
Hello,

I experienced the same kind of problem.

In a merge replication with SQL Express 2012, I got the error when applying the snapshot to the subscriber.
On server side, the database file is about 7.5 Gb.

Strange fact ... at the moment of the error : my database file (on the subscriber) is exactly sized to 4Gb but ... I read somewhere SQL Express 2012 file limitation was extended to 10Gg ...

An idea ?

Kind regards
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search