Thread was being aborted

yadavdep
yadavdep used Ask the Experts™
on
I am running a process from my asp.net application in a separate thread.
This process takes time as it has to insert 150000 records in the table.

But I am getting "Thread was being aborted" error some where around 6000 th  record only.

What can I do here to keep the running till all records gets imported.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
ǩa̹̼͍̓̂ͪͤͭ̓u͈̳̟͕̬ͩ͂̌͌̾̀ͪf̭̤͉̅̋͛͂̓͛̈m̩̘̱̃e͙̳͊̑̂ͦ̌ͯ̚d͋̋ͧ̑ͯ͛̉Glanced up at my screen and thought I had coded the Matrix...  Turns out, I just fell asleep on the keyboard.
Most Valuable Expert 2011
Top Expert 2015

Commented:
Did you make the thread a background thread?

e.g.

Thread t = new Thread(SomeFunction);

t.IsBackground = true;

Open in new window

yadavdep

Author

Commented:
No, I don't think I did that.

Also, I recheck the code and I guess it is running in the main thread only.

If it is running in the main thread then is there any solution to it
ǩa̹̼͍̓̂ͪͤͭ̓u͈̳̟͕̬ͩ͂̌͌̾̀ͪf̭̤͉̅̋͛͂̓͛̈m̩̘̱̃e͙̳͊̑̂ͦ̌ͯ̚d͋̋ͧ̑ͯ͛̉Glanced up at my screen and thought I had coded the Matrix...  Turns out, I just fell asleep on the keyboard.
Most Valuable Expert 2011
Top Expert 2015

Commented:
I suppose that depends on how you want to solve it. If you want to run it on the main thread, then your user's browser window is going to sit there spinning until the operation completes--assuming it completes before your configured timeout period. Otherwise, I *think* you would need to make the thread a background thread in order to allow ASP.NET to return a response to the client browser, yet still continue processing the DB inserts. This foregos returning a response to the browser in that request. You would have to work some AJAX magic in order to see a response from the background thread's work.
Commented:
I believe there is a timeout setting in the IIS configuration either for the site or for the app pol that might be able to be extended in order to let your thread complete.  Best practice would be to put the work into a worker thread but the timeout setting might give you a quick fix.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial