Velocity Reviews - Computer Hardware Reviews

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

Reply
Thread Tools

Bulk Import - Thread was being Abort

 
 
Prasad Dannani
Guest
Posts: n/a
 
      09-01-2005
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




 
Reply With Quote
 
 
 
Reply

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



Advertisments