Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Bulk Import - Thread was being Abort

Thread Tools

Bulk Import - Thread was being Abort

Prasad Dannani
Posts: n/a
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


BMS Team


Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Thread abort error - REVISITED BillGatesFan ASP .Net 1 11-14-2005 07:48 PM
Bulk Import - Thread was being Aborted Prasad Dannani ASP .Net 0 09-01-2005 06:43 PM
Newbie: Catching the Abort method to destroy a thread =?Utf-8?B?Y2hhcmxpZXdlc3Q=?= ASP .Net 2 06-30-2005 02:47 PM
Re: Threading.Thread.Abort error Karl ASP .Net 0 09-15-2004 05:45 PM
Server.Tranfer giving Thread abort problem =?Utf-8?B?c3Jpa2lydGk=?= ASP .Net 3 05-20-2004 08:21 AM