473,326 Members | 2,012 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

error aspnet_wp.exe, stopped unexpectedly

Hello,

I'm wondering if anybody has seen this problem. I basically need to cycle
through ~30000 db rows to update the data, I load up the id of the rows I
need first, put them into ArrayList, close the connection, then process
through one record at a time, so there is no nested transaction. It
normally take 1 hour or more, after about 45 min, the aspx page gives up
with a server unavailable msg, but the server still goes on in the
background for 15 min or more then stop.
App event in the server shows this: aspnet_wp.exe (PID: 2400) stopped
unexpectedly

Does anyone know what the problem is?

Thanks!

Nov 19 '05 #1
4 1151
Hi,

Without an error it is probably hard to say something, but cannot you make
an update in a some sort of batch? I do not think it is a good idea to make
updates one-by-one especially in ASP.NET environment. I am pretty sure there
is a better way to do this, but it depends on what you need to achieve

--
Val Mazur
Microsoft MVP

http://xport.mvps.org

"Zeng" <Ze******@hotmail.com> wrote in message
news:ub**************@TK2MSFTNGP10.phx.gbl...
Hello,

I'm wondering if anybody has seen this problem. I basically need to cycle
through ~30000 db rows to update the data, I load up the id of the rows I
need first, put them into ArrayList, close the connection, then process
through one record at a time, so there is no nested transaction. It
normally take 1 hour or more, after about 45 min, the aspx page gives up
with a server unavailable msg, but the server still goes on in the
background for 15 min or more then stop.
App event in the server shows this: aspnet_wp.exe (PID: 2400) stopped
unexpectedly

Does anyone know what the problem is?

Thanks!

Nov 19 '05 #2
How come you didn't think it was a good idea to make updates one-by-one in
asp.net environment? By the way, each update is a well-defined and
re-usable operation, doing it otherwise would risk code inconsistency, I
have to do this once every two weeks. MS must have tried something like
this to stress test the framework, right? Basically just do a big loop and
do several db read/update each iteration. My loop failed around the 10000th
record. If all resource (memory etc..) is released and/or recycled
properly, why would it matter if it's a big loop or not?


"Val Mazur (MVP)" <gr******@hotmail.com> wrote in message
news:OD**************@TK2MSFTNGP10.phx.gbl...
Hi,

Without an error it is probably hard to say something, but cannot you make
an update in a some sort of batch? I do not think it is a good idea to make updates one-by-one especially in ASP.NET environment. I am pretty sure there is a better way to do this, but it depends on what you need to achieve

--
Val Mazur
Microsoft MVP

http://xport.mvps.org

"Zeng" <Ze******@hotmail.com> wrote in message
news:ub**************@TK2MSFTNGP10.phx.gbl...
Hello,

I'm wondering if anybody has seen this problem. I basically need to cycle through ~30000 db rows to update the data, I load up the id of the rows I need first, put them into ArrayList, close the connection, then process
through one record at a time, so there is no nested transaction. It
normally take 1 hour or more, after about 45 min, the aspx page gives up
with a server unavailable msg, but the server still goes on in the
background for 15 min or more then stop.
App event in the server shows this: aspnet_wp.exe (PID: 2400) stopped
unexpectedly

Does anyone know what the problem is?

Thanks!


Nov 19 '05 #3
Tim
(excuse the caps).

RDBMS excel when SET based operations are used.

IE if you get data, you get a set of data using SELECT.

If you want to delete data, you delete a set of data using DELETE.

If you wish to update data, you use an UPDATE statement. It is by far the
most efficient way of performing the operation. Updating say 10,000 records
should take a second or so on a moderate performing server. It can of course
take a lot longer if there are complex joins in the update statement.

Using a cursor operation with procedural logic is akin to reading tape files
on a mainframe and processing a record at a time - it is inherently very
slow. In a client server environment, each fetch of next record [can]
involve a network round trip to the server which with network latency,
server latency etc. makes for a slow process. Effectively you are treating
the data source as a big serial file...

Certainly there are some situations where the values to use in each record
update may require a custom calculation, but where does this data come from?
If it comes from the database, then the concept is to chop out the network,
the client and devise an SQL statement that will execute the UPDATE for all
records in one statement on the server. If some of the data needed is
somewhere in the client, then bung it in the database in some suitable table
for the duration of the update and so make it available for the calculation.

There are techniques to batch the update into smaller chunks that involve
using the TOP operator.

As for the cause for your failure: as Val says, it is difficult to give any
answer without any errors. Is there anything in the event log? I would
suspect you are hitting a timeout of some sort. IMHO ASP.Net is not designed
for large Batch operations.

- Tim

"Zeng" <Ze******@hotmail.com> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...
How come you didn't think it was a good idea to make updates one-by-one in
asp.net environment? By the way, each update is a well-defined and
re-usable operation, doing it otherwise would risk code inconsistency, I
have to do this once every two weeks. MS must have tried something like
this to stress test the framework, right? Basically just do a big loop and
do several db read/update each iteration. My loop failed around the
10000th
record. If all resource (memory etc..) is released and/or recycled
properly, why would it matter if it's a big loop or not?


"Val Mazur (MVP)" <gr******@hotmail.com> wrote in message
news:OD**************@TK2MSFTNGP10.phx.gbl...
Hi,

Without an error it is probably hard to say something, but cannot you
make
an update in a some sort of batch? I do not think it is a good idea to

make
updates one-by-one especially in ASP.NET environment. I am pretty sure

there
is a better way to do this, but it depends on what you need to achieve

--
Val Mazur
Microsoft MVP

http://xport.mvps.org

"Zeng" <Ze******@hotmail.com> wrote in message
news:ub**************@TK2MSFTNGP10.phx.gbl...
> Hello,
>
> I'm wondering if anybody has seen this problem. I basically need to cycle > through ~30000 db rows to update the data, I load up the id of the rows I > need first, put them into ArrayList, close the connection, then process
> through one record at a time, so there is no nested transaction. It
> normally take 1 hour or more, after about 45 min, the aspx page gives
> up
> with a server unavailable msg, but the server still goes on in the
> background for 15 min or more then stop.
> App event in the server shows this: aspnet_wp.exe (PID: 2400) stopped
> unexpectedly
>
> Does anyone know what the problem is?
>
> Thanks!
>
>
>



Nov 19 '05 #4
Hi,

How? It does not matter if it is ASP.NET or Windows application environment,
it is always very expensive task to update/delete/insert records one-by-one.
But in ASP.NET environment it means huge load for the IIS and it is not a
benefit for sure. Anyway updating 30000 of rows in a database should not
take 45 minutes. If you use some sort of batch, I am pretty sure you could
do it in a couple of minutes if not under 1 minute. For example, you could
sent data as one XML batch into SP and call one UPDATE there.
--
Val Mazur
Microsoft MVP

http://xport.mvps.org

"Zeng" <Ze******@hotmail.com> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...
How come you didn't think it was a good idea to make updates one-by-one in
asp.net environment? By the way, each update is a well-defined and
re-usable operation, doing it otherwise would risk code inconsistency, I
have to do this once every two weeks. MS must have tried something like
this to stress test the framework, right? Basically just do a big loop and
do several db read/update each iteration. My loop failed around the
10000th
record. If all resource (memory etc..) is released and/or recycled
properly, why would it matter if it's a big loop or not?


"Val Mazur (MVP)" <gr******@hotmail.com> wrote in message
news:OD**************@TK2MSFTNGP10.phx.gbl...
Hi,

Without an error it is probably hard to say something, but cannot you
make
an update in a some sort of batch? I do not think it is a good idea to

make
updates one-by-one especially in ASP.NET environment. I am pretty sure

there
is a better way to do this, but it depends on what you need to achieve

--
Val Mazur
Microsoft MVP

http://xport.mvps.org

"Zeng" <Ze******@hotmail.com> wrote in message
news:ub**************@TK2MSFTNGP10.phx.gbl...
> Hello,
>
> I'm wondering if anybody has seen this problem. I basically need to cycle > through ~30000 db rows to update the data, I load up the id of the rows I > need first, put them into ArrayList, close the connection, then process
> through one record at a time, so there is no nested transaction. It
> normally take 1 hour or more, after about 45 min, the aspx page gives
> up
> with a server unavailable msg, but the server still goes on in the
> background for 15 min or more then stop.
> App event in the server shows this: aspnet_wp.exe (PID: 2400) stopped
> unexpectedly
>
> Does anyone know what the problem is?
>
> Thanks!
>
>
>



Nov 19 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Zeng | last post by:
Hello, I'm wondering if anybody has seen this problem. I basically need to cycle through ~30000 db rows to update the data, I load up the id of the rows I need first, put them into ArrayList,...
0
by: Keith | last post by:
I am building an ASP.NET application using VS.NET 2002 on Framework 1.1.4322.0. I am debugging the application and everytime I click the stop button to quit debugging, the server stops the...
1
by: Stan | last post by:
I get this error when I try to access any page on the website: An error occurred while try to load the string resources (GetModuleHandle failed with error 126). At the same time here is what I...
0
by: Umair Ahmed | last post by:
Hi, I m developing a web application on Win2k platform and deploying the application on Win2k platform. I didnt get any error on the development machine but when i deployed to any machine on...
6
by: GP | last post by:
We get " Object reference not set to an instance of an object. " error in all the links whenever the browser is not used for more than 5 minutes. In IIS 5.0 version we are setting the session time...
10
by: Shawn | last post by:
JIT Debugging failed with the following error: Access is denied. JIT Debugging was initiated by the following account 'PLISKEN\ASPNET' I get this messag in a dialog window when I try to open an...
5
by: Tom | last post by:
I am having the following show up in my application event log: ===================================== Source: .NET Runtime Event ID: 0 Description: The description for Event ID ( 0 ) in Source...
3
by: Ramesh Dodamani | last post by:
Environment: XP Pro, VS.Net 2003, .Net 1.1.4322 with SP1 & KB Hotfix 886903 P4 2.2GHz, 1 GB RAM My system was working fine till a few weeks back when I started seeing the following errors. ...
1
by: ImSoLost | last post by:
My asp.net web application dies after an hour of processing (it's a long database parsing process) and the web page becomes a "Page could not be displayed" webpage. I looked in my event logs and...
0
by: Woodwinds | last post by:
I have a web application run under ASP.NET v1.1.4322 when I run that web application I got error that show on application log "aspnet_wp.exe stopped unexpectedly" I re installed visual...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.