Transactional replication synch error
in [Replication]
|
From: Koni Kogan on 30 May 2006 19:08 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) Get help: http://help/20253
From: Hilary Cotter on 30 May 2006 22:39 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 "Koni Kogan" <kkogan(a)haiint.com> wrote in message news:Omsjt3DhGHA.4404(a)TK2MSFTNGP05.phx.gbl... > 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) > Get help: http://help/20253
From: Koni Kogan on 31 May 2006 11:21 Hilary Cotter wrote: > Did you try to bcp this in? > Yes, i get the famous 'EOF' error.
From: Hilary Cotter on 1 Jun 2006 08:52 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 "Koni Kogan" <kkogan(a)haiint.com> wrote in message news:O5hrvXMhGHA.764(a)TK2MSFTNGP03.phx.gbl... > Hilary Cotter wrote: > >> Did you try to bcp this in? >> > Yes, i get the famous 'EOF' error.
|
Pages: 1 Prev: Synchronization error Next: Sychronization error - MSSQL_REPL22037 |