w3wp Worker Process leakage problem when running Crystal Report


R

Rabbit

Dear All,

I have recently using ASP.net 2.0 to build web application with Crystal
Report for .net, one of my typical coding to generate report on web page as
follows:

Dim rpt As New ReportDocument
rpt.Load(Server.MapPath("rptPurchaseOrder.rpt"))
rpt.SetDataSource(dsPOData)
Me.CRViewer.ReportSource = rpt

My user reported to me that the web application will run into problem when
executing the report repeatly for say 30 times, the new report request will
cause the web page showing "Load Report Failed"

I checked whenever the memory usage for w3wp.exe (application pool) over
around 200 MB, the service will then run into trouble. I need to delete the
service (w3wp.exe) in order to fix the problem or set Application pool to
recycle the worker process on certain memory usage

Now my users complaining this workaround make them lost all sessions(such as
User ID), so they need to re-login again ...

My question is any problem on my coding sample, do I need to set something
to release the report resouce after use?

Anybody share can your experience is very appreciate!

Keith
 
Ad

Advertisements


Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top