Merge Replication - by kashif123

Status : 


Sign in
to vote
ID 646157 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 2/22/2011 11:26:20 AM
Access Restriction Public


    When reinitializing subscriber in merge replication it throwing following error:

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)
Get help: http://help/MSSQL_REPL20037
Field size too large (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
To obtain an error file with details on the errors encountered when initializing the subscribing table, execute the bcp command that appears below. Consult the BOL for more information on the bcp utility and its supported options. (Source: MSSQLServer, Error number: 20253)
Get help: http://help/20253
bcp "GenDev"."dbo"."MSmerge_contents" in "\\servername\RepData\unc\ProdTABLES\Sub01\MSmerge_contents90_forall.bcp" -e "errorfile" -t"\n<x$3>\n" -r"\n<,@g>\n" -m10000 -SPOS_00108 -T -w (Source: MSSQLServer, Error number: 20253)
Get help: http://help/20253 
Sign in to post a comment.
Posted by Microsoft on 2/25/2011 at 8:25 AM
Hi kashif123

thanks for taking the time to share your feedback, this is really important to us.
I can see this is a duplicate of the other feedback (#646156) that you raised. Closing this one as duplicate, please refer to the other one for follow up.

Best regards
Jean-Yves Devant
Program Manager (Replication/CDC/CT)
SQL Server Engine Team