| Author |
Topic |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2008-07-02 : 16:50:28
|
| Hi Experts,I have configured transaction replication beween 2 servers with updatble subscription in SQL Server 2005 with SP2. Everything goes fine. Except when the snapshot is getting applied to the subscriber.I get error when the snapshot is getting applied to the second server.Error messages:1) The process could not bulk copy into table '"dbo"."AllDocStreams"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)Get help: http://help/MSSQL_REPL200372) An existing connection was forcibly closed by the remote host.One or more BLOB columns could not be sent to the server, attempt to recover from the problem failed.3) Communication link failure (Source: MSSQLServer, Error number: 08S01)Get help: http://help/08S014) Unspecified errorFailed to send batch after max errorsAny help or recommendation is appreciated.Thanks in advanceSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-02 : 17:03:21
|
| Why are you applying snapshot in Subscriber? It should be applied in Publisher. |
 |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2008-07-03 : 06:47:47
|
| Snapshot is applied on subscriber when you choose to apply snapshot immediately. Basically what applying the snapshot means is that all objects which are part of your publication are (re)created in the subscriber database and when the data is bcp'd into the tables. And when this is going the BCP fails for one table :(.regardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 20:18:48
|
| How big is the table? |
|
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-07-05 : 00:18:59
|
| check the order of columns while bcp also check to see you have copy the contents of BCP into a new table, truncate the existing table and copy the contents from this new table to the original table and check to see if the ERROR persists..There might be something wrong with the DATA...ManinderSQL server Architect / Admin (DEV&PROD) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-05 : 23:04:09
|
| The bcp here is started by replication as part of snapshot. |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2008-07-07 : 03:18:25
|
| Hi Maninder /rmiao,I checked the order of the tables and they are same in both publisher and subscriber. The table contains a column with image datatype. I think that can be a problem. MSDN says that to replicate LOB data, using "Distribution Profile for OLEDB streaming" profile is optimized. I even tried that, but no luck.Please help.ThankssachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-07 : 23:23:39
|
| How big is that table? Has enough disk space to hold data files for bcp? |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2008-07-08 : 02:44:10
|
| The table is of 2GB and enough space on disk to hold the BCP file.Don't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-09 : 23:14:05
|
| Snapshot 2gb table may have problem if link speed between servers is slow. |
|
|
|
|
Replication Error