Bulk Import - Thread was being Abort

Discussion in 'ASP .Net' started by Prasad Dannani, Sep 1, 2005.

  1. I am facing a unique problem where i am reading

    an XMl stream(8000 records) using open XML into SQL server > The problem is
    that whenever i execute the stored procedure it starts inserting data but
    suddenly stops at about 1 min 45-50 secs time. The import stops and the
    error is

    "Thread was being aborted". The whole stuff works fine when i connect to the
    database server from local machine.

    The database server is located at a remore place and the live application
    resides in the same place as of the database server. I get this problem when
    i try doing import logging in to the live server. i dont get this problem
    when i try doing this locally to the remote database server



    Settings : IIS6.0 and ASP.NET, SQL Server



    please suggest if there are any web server based settings which are forcing
    the import to time out.



    Arnab Kumar Dutta

    Associate-Technology

    BMS Team

    D03044
    Prasad Dannani, Sep 1, 2005
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?c3Jpa2lydGk=?=

    Server.Tranfer giving Thread abort problem

    =?Utf-8?B?c3Jpa2lydGk=?=, May 20, 2004, in forum: ASP .Net
    Replies:
    3
    Views:
    3,695
    =?Utf-8?B?c3Jpa2lydGk=?=
    May 20, 2004
  2. Karl
    Replies:
    0
    Views:
    3,668
  3. =?Utf-8?B?Y2hhcmxpZXdlc3Q=?=

    Newbie: Catching the Abort method to destroy a thread

    =?Utf-8?B?Y2hhcmxpZXdlc3Q=?=, Jun 29, 2005, in forum: ASP .Net
    Replies:
    2
    Views:
    452
    =?Utf-8?B?Y2hhcmxpZXdlc3Q=?=
    Jun 30, 2005
  4. Prasad Dannani

    Bulk Import - Thread was being Aborted

    Prasad Dannani, Sep 1, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    436
    Prasad Dannani
    Sep 1, 2005
  5. BillGatesFan

    Thread abort error - REVISITED

    BillGatesFan, Nov 14, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    391
    Jason Kester
    Nov 14, 2005
Loading...

Share This Page