troubleshooting Question

SQL server 2014 replication error

Avatar of marrowyung
marrowyung asked on
Microsoft SQL Server
35 Comments3 Solutions874 ViewsLast Modified:

right now configuration some test on SQL server 2014 transaction replication and we receive the following error:

Error messages:

Error messages:
•	The process could not bulk copy into table '"dbo"."<tableName>"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)
Get help: http://help/MSSQL_REPL20037
•	Batch send failed
•	OLE DB provider 'STREAM' for linked server '(null)' returned invalid data for column '[!BulkInsert].Remark'. (Source: MSSQLServer, Error number: 7339)
Get help: http://help/7339
•	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 "FLHAECO"."dbo"."<tableName>" in "\\HXDECOUATDBS01\WorkingDir\unc\HXDECOUATDBS01_HXDB_HMS_WMS\20170314093312\<tableName>_11#27.bcp" -e "errorfile" -t"\n<x$3>\n" -r"\n<,@g>\n" -m10000 -SHXTWMSUATDB -T -w (Source: MSSQLServer, Error number: 20253)
Get help: http://help/20253

it seems that the mentioned error was due to the collation difference in source and destination DB and continuously happen in production environment as well.

I knew the diff in collation can't be solve and it involve reinstall of the DB server, right?

Are there any methods ton bypassing the those columns with different collation in replication ?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 35 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 35 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros