all groups > sql server replication > may 2006 >
You're in the

sql server replication

group:

Transactional replication synch error



Transactional replication synch error Koni Kogan
5/30/2006 6:08:12 PM
sql server replication: The tables in the publication and subscription dbs are identical. This
seems like an old bcp 'unreadable' characters problem... Anybody help?

Error messages:
The process could not bulk copy into table '"dbo"."eh_RetailSales"'.
(Source: MSSQL_REPL, Error number: MSSQL_REPL20037)
Get help: http://help/MSSQL_REPL20037
Field size too large
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 "DwStageSql4"."dbo"."eh_RetailSales" in
"e:\MSSQL\ReplData\unc\SQL5_EMIOPER_EMIOPER4DWSTAGE\20060530173785\eh_RetailSales_12#1.bcp"
-e "errorfile" -t"\n<x$3>\n" -r"\n<,@g>\n" -m10000 -SSQL6\Y -T -w
(Source: MSSQLServer, Error number: 20253)
Re: Transactional replication synch error Hilary Cotter
5/30/2006 10:39:47 PM
Did you try to bcp this in?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Re: Transactional replication synch error Koni Kogan
5/31/2006 10:21:47 AM
[quoted text, click to view]
Re: Transactional replication synch error Hilary Cotter
6/1/2006 8:52:34 AM
This normally means you have different schemas on either side? Are they the
same?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

AddThis Social Bookmark Button