Post reply

The process could not deliver the snapshot to the Subscriber.

  • July 2, 2007 at 9:28 pm

    #372680

    Hi. SQL Gurus

    Please help me.

     I have problem with merge Replication in sql server 2000.

    I have two servers which are located in different locations. My intension is that data should be updated in both servers.

    So I have configured server1 to be Publisher/Distributor and server2 just subscriber but I got this error message.

    The process could not deliver the snapshot to the Subscriber.

    (Source: Merge Replication Provider (Agent); Error number: -2147201001)

    ---------------------------------------------------------------------------------------------------------------

    The process could not bulk copy into table '"dbo"."ARINVOICE"'.

    (Source: BKKNTS112 (Agent); Error number: 20037)

    ---------------------------------------------------------------------------------------------------------------

    Could not bulk insert. Bulk data stream was incorrectly specified as sorted.

    (Source: BKKNTS112 (Data source); Error number: 4819)

    ---------------------------------------------------------------------------------------------------------------

    How Do i fix this problem?

    Thank you.

  • July 3, 2007 at 9:19 am

    #716933

    Whilst searching on the description "Bulk data stream was incorrectly specified as sorted" on google, it brought up this solution: make sure that both the publisher and subscriber are set to the same default collation.

    Paul

  • September 27, 2007 at 6:02 am

    #736686

    give permission to ur Admin for "Process Administrator" & "Bulk Insert Administrators"

    --Pradeep

  • August 20, 2008 at 12:44 am

    #860418

    Thanks Pradeep, i was experiencing similar problems when replicating from 2000 to 2005 and it was simply a case of adding the login and configuring server roles as you mentioned.

    Why can't the error message tell you this? ;o)

    cheers

  • August 20, 2008 at 2:28 am

    #860479

    ....Actually,red-herring, it was coallation conflict as Paul Mu suggested! (thanks Paul)

    Not removed the login/role configuration and retested as prodution has now started and next window is a while away!

    cheers

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

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