Post reply

Unexpected EOF encountered in BCP data-file

  • June 28, 2007 at 7:55 am

    #103382

    I am trying to run replication between two 2003 servers running.

    The db is quite lage 246 GB.

    The snapshot completes successfully but I am getting the following error;

    "Unexpected EOF encountered in BCP data-file" as a Distribution Agent Error and

    "The process could not bulk copy into table BalanceRelatedChange".

    Replication as run previously without errors. I thought it mightbe a data error so I have run the replication process against the BalanceRelatedChange table alone and the process completes successfully.

    However I have rerun replcation several times and the same error has ocurred but for different tables, all of which I have been able to run replication against individually.

    Any ideas?

    SteveB

  • June 2, 2008 at 11:21 am

    #823131

    Steve - did you ever hear anything back on this replication problem you were having? I am experiencing the same problem and was hoping you may have already solved it. Thanks Dawnelle

  • June 10, 2008 at 2:56 pm

    #826989

    Have you gone through the following link:--

    http://support.microsoft.com/?id=271344

    Manu

  • June 30, 2008 at 3:00 pm

    #836393

    I've just had this probem and it turned out that the table that it was erroring on had a diffrent definiton on the subscriber compared to that on the publisher. This happened because it wasn't replacing the table defenition as the article property had 'delete data...' rather than ''drop table and recreate...' if the object already exists.

    if this doesn't work then you can get around it by emptying the table on the publisher and snapshotting and reapplying, then reinsert the data on the publisher and it will either be ok or give you some more hints on what the problem is.

    Jeet


    Thanks Jeet

Viewing 4 posts - 1 through 3 (of 3 total)

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