Post reply

Unexpected EOF encountered in BCP data-file - Replication

  • July 2, 2007 at 2:38 am

    #179469

    I am trying to run replication between two 2003 servers running SQL 2000

    The db is quite lager 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 has run previously without errors. I thought it might be a data error so I have run the replication process against the offending tables seperatley 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.

    The tables that replication errors on are very large, I am not sure if this would cause the problem as I do not have much experience with replication.

    Any ideas?

  • July 2, 2007 at 5:25 am

    #716486

    i have come across this on several occasions.

    i tried dropping the article and adding back in before creating a new snapshot, but the problem re-appeared.

    the only method i've found of correcting the issue was to remove the article from the publication. create the snapshot and distribute the snapshot.

    then add the article back in and create a new snapshot (which should be pushed out)

    MVDBA

  • July 5, 2007 at 8:38 am

    #717410

    Thanks for the reply Mike.

     

    I have another problem dropping the article. When I go into Publication properties and select Articles the ticks against all the tables are greyed out.

     

    How did you drop the article?

    Thanks

     

  • July 5, 2007 at 8:45 am

    #717414

    you have to drop any subscriptions to it firts - but enterprise manager won't let you do that through the gui -

    here is the script

    sp_dropsubscription @publication = 'publication'

    ,@article = 'article'

    @subscriber = 'all'

    go

    sp_droparticle @publication = 'publication'

    , @article = 'article'

    then use sp_addarticle and sp_addsubscription (see BOL) to add the article back in and subscribe to it

    MVDBA

  • July 13, 2007 at 2:11 am

    #719205

    Thanks for all your help Mike.

     

    The problem turned out to be an issue with our SAN which has now been corrected.

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

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