[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Slow ASP.NET Crystal Reports - Restart the web site?

Posted on 2010-03-26
5
Medium Priority
?
540 Views
Last Modified: 2012-05-09
My client has an ASP.NET 1.1 website which uses Crystal Reports. It runs on a Windows 2000 server (one box for both web and sql [msde]) with IIS 5.0.

In the last day or so, some of the crystal reports take too long and the browser can't display the web page (IE message). Script timeout is set to about 30 minutes while execution timeout is set to several hours. It seems like page times out after about 20 minutes.

These are existing reports and I don't think the size of them has grown. I suspect the website needs to be "rebooted" but I don't want to restart the entire box since there may be other web sites running on it. Short of restarting the server and / or IIS, what can I do to clear out any accumulated junk for our website?

Thanks.
0
Comment
Question by:ZekeLA
  • 3
  • 2
5 Comments
 
LVL 5

Assisted Solution

by:meetingexpectations
meetingexpectations earned 2000 total points
ID: 28707002
Clear the temp folder, usually C:/Windows/Temp, that is where Crystal reports create temp files.
0
 
LVL 1

Author Comment

by:ZekeLA
ID: 28708523
The latest file in WINNT\Temp is from 2009. Or is it just that the temp folder may be too full?
0
 
LVL 5

Assisted Solution

by:meetingexpectations
meetingexpectations earned 2000 total points
ID: 28710681
That could be the reason. You need to periodically clean the temp folder, or at least add the code to dispose off the temp crystal files on page unload..Ex:

rptReportDocument is my CrystalDecisions.CrystalReports.Engine.ReportDocument
Private Sub Page_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Unload
            Try

                If IsNothing(rptReportDocument) = False Then
                    rptReportDocument.Close()
                    rptReportDocument.Dispose()
                End If

               Catch ex As Exception
                End Try
   End Sub
0
 
LVL 1

Author Comment

by:ZekeLA
ID: 28711643
Thanks for that code. I plan to implement it if testing shows no problems with it.
0
 
LVL 1

Accepted Solution

by:
ZekeLA earned 0 total points
ID: 29415413
Hosting company rebooted server which corrected the problem. Giving partial points to temp folder ideas as that seems like it was related.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
A phishing scam that claims a recipient’s credit card details have been “suspended” is the latest trend in spoof emails.
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses
Course of the Month10 days, 10 hours left to enroll

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question