Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-04 : 08:18:58
|
| newsqlguy writes "Hi,I build a replication on one table with 77 columns and with one subscriber. it works fine. after applying the snapshot I try to remove one field out of the replication so only 76 columns will be replicated (because the other one should be changed in the subscriber separately from the publisher).Now, after reinitialization of the subscription the problem starts. the distribution agent fails with messages like:"The process could not copy bulk into table "Item"..."and"Unexpected EOF in bcp data-file"Or,"string data, right truncation"and"Unexpected EOF in bcp data-file"Now, this happens even with single record in the table.Additional info:1. the column I took out of the rep. is float type.2. After creating the replication all column defaults in subscriber table have been deleted. So, I added the default for the float field manually to be 0 but it didn't work.3. I tried to search for some answers but could not find anything to help me with this one.Please, help ASAP." |
|
|
Ken Blum
Constraint Violating Yak Guru
383 Posts |
Posted - 2004-02-04 : 11:50:32
|
| Need some info...1. SQL Server Version/SP2. Publication Type: Transaction/Merge/Snapshot?3. Push or Pull Subscriptions?4. How did you "remove one field out of the replication". Did you use Publication Column Filters?5. What do you mean by "reinitialization of the subscription"? Did you create a new snapshot and redistribute the new snapshot after changing your filter columns? If not, that is your problem. |
 |
|
|
newsqlguy
Starting Member
13 Posts |
Posted - 2004-02-04 : 15:01:41
|
| 1. SQL Server 2000 Standard Edition Version 8.00.534 (SP2).2. Transaction replication.3. Push Subscription4. I did use the column filter to remove the filed from the replication.5. When I removed the column from the article it automatically notified me that this will mark all subscription for reinitialization. after that I right clicked on the snapshot agent and choosed run agent. Did I missed something about this?What do you mean "create a new snapshot"? should I create another snapshot publication and apply it? running the snapshot agent created by this publication isn't good enough? the snapshot isn't updated after changing the publication?Thanks a million,Izzy. |
|
|
|
Ken Blum
Constraint Violating Yak Guru
383 Posts |
Posted - 2004-02-04 : 15:38:49
|
| Sounds like you are doing everything right to me, although I am no expert. Those errors seem to indicate that the subscription and publication articles do not match (just a guess). If you look at the agent history in the snapshot agent you should see when the new snapshot was generated. You should also see when the snapshot was applied under the subscriber article. Also take a look at where your snapshot is being stored and the type under those properties of the publication. Anything odd? Does the Datetime stamp of the snapshot file change after you change the publication. When you Explore the snapshot does it look right? Do your subscriptions validate?Read "Applying the Initial Snapshot" in BOL.Try reinitializing all of your subscribers manually, or deleting the subscription and pushing a new one. |
|
|
|
|
|
|
|
|
Troubles with replication distribution agent