Replication with errors

Question

Post reply

Replication with errors

Ed7

SSCrazy Eights

Points: 8519
More actions
January 29, 2007 at 10:39 am

#175706

Hi All,
I run into problems:
Error messages:
·          The process could not bulk copy into table '"t_ElecConnData"'. (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 "JAW_TEST_TWO".."t_ElecConnData" in "C:\SWEETWATER_ReplData\unc\GHS0016RPT_SITEDATA_GARRADHASSAN_SITEDATA_4c7573d6\20070129071646\t_ElecConnData_7.bcp" -e "errorfile" -t"\n<x$3>\n" -r"\n<,@g>\n" -m10000 -S14419-26632 -T -w (Source: MSSQLServer, Error number: 20253)
Get help: http://help/20253
Can anyone helps pls?
Thanks
TJ

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

MohammedU SSCoach Points: 19644 More actions · Answer 1

Is source and destination table has the same schema?

MohammedU
Microsoft SQL Server MVP

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 2

how to check the db schema?

Sorry, I am newbee DBA

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 3

how did you originally create the publication? have you tried to reinitialize it?

MohammedU SSCoach Points: 19644 More actions · Answer 4

Script the objects using SSMS and compare them manually if you don't have any coparison tool..

Did you initialize the snapshot?

MohammedU
Microsoft SQL Server MVP

Jeff Gray SSChampion Points: 10667 More actions · Answer 5

Did you try what the error message says to do? Execute the BCP command manually to get the error results in a file called "errorfile".

I'd try that and see if you get any more detailed information.

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 6

The initial snapshoot went complete with no errors.

MohammedU SSCoach Points: 19644 More actions · Answer 7

If initial snapshot completed then how BCP is being executed?

MohammedU
Microsoft SQL Server MVP

Jeff Gray SSChampion Points: 10667 More actions · Answer 8

I think the error happens when the distribution agent applies the snapshot at the subscriber.

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 9

Hi Addict,

That's correct. I am getting the errors when the distribution agent applies the snapshoot at the subscriber.

Thanks

TJ

abhijit.dey Old Hand Points: 314 More actions · Answer 10

first stop the distribution

then remove the subscription

truncate the destination table

run the BCP to transfer the data from source to destination.

add the subscription again using @sync_type parameter set to "replication support only"

Run the distribution.

bass321.tw SSC Rookie Points: 29 More actions · Answer 11

It's because your source table's data type/format are out of the range of destination tables.

Usually it's "Date" type.

@Peandaddy

Saravanan_tvr SSCarpal Tunnel Points: 4558 More actions · Answer 12

I am sure this problem begins with datatype , any constraints missing between Pub. DB to sub. DB tables , please recreate the table from Pub DB and ran it on Sub db..

or find out the differences between the tables and do it manually.. surely the problem will be solved 🙂