Solved

Report timing out on website

Posted on 2013-05-21
5
778 Views
Last Modified: 2013-07-10
Hi

I have a report that has been running fine up until last week when users started to experience timeouts when running the report. The incident happens at intermittent times of the day with some days the report runs fine.
The report is a RDLC file which is called through our asp.net website

Timeout set in webconfig is:

<!-- set the timeout of report viewer, value is in miliseconds-->
    <add key="ReportViewerTimeOut" value="6000000"/>

SQL time out is set at:

(Server properties\Connections)

remote server connections

remote Query time  out (in seconds. 0=no timeout)

750


After investigate HTTPERR logs, IIS logs and Event viewer i noticed the following events


IIS:

013-05-21 09:47:05 GET /Reports/PerformanceViewer.aspx Report=PerformanceReport&location_chooser_filter=Henley+Thames&location_chooser_location_type_id=1&location_chooser_sub_location_type_id=-1&location_chooser_id=16&location_filter_type=Depot&location_filter_type_id=1&SearchFilters.startDate=21%2F05%2F2013 - 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+5.2;+Trident/4.0;+POIE4SP2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729;+.NET4.0C;+.NET4.0E) http://localhost/Reports/MyReport/PerformanceReport localhost 500 0 10349 1119 60875

500 0 looks like a status and substatus error

HTTPERR:
Date                                IP              Port
2013-05-21 09:57:31 10.xx.xx.xx  1959 172.xx.xxx.x 443 - - - - - Timer_ConnectionIdle -
2013-05-21 09:57:31 10.xx.xx.xx 1961 172.xx.xxx.x 443 - - - - - Timer_ConnectionIdle -
2013-05-21 09:57:31 10.xx.xx.xx 1962 172.xx.xxx.x 443 - - - - - Timer_ConnectionIdle -
2013-05-21 09:57:37 10.xx.xx.xx 1962 172.xx.xxx.x 443 - - - - - Timer_ConnectionIdle -


(seems fine to me)

Event viewer:
Event Type:      Warning
Event Source:      ASP.NET 4.0.30319.0
Event Category:      Web Event
Event ID:      1309
Date:            21/05/2013
Time:            10:47:05
User:            N/A
Computer:      IISServer
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 21/05/2013 10:47:05
Event time (UTC): 21/05/2013 09:47:05
Event ID: 92222d6976124410b2f73149b04e2f13
Event sequence: 95472
Event occurrence: 42
Event detail code: 0
 
Application information:
    Application domain: /LM
    Trust level: Full
    Application Virtual Path: /
    Application Path: C:\Program Files\Web\
    Machine name: IISServer
 
Process information:
    Process ID: 20176
    Process name: w3wp.exe
    Account name: IISServer\svcBWe
 
Exception information:
    Exception type: HttpUnhandledException
    Exception message: Exception of type 'System.Web.HttpUnhandledException' was thrown.
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.Util.AspCompatApplicationStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.


I have ran the query on the SQL server and it runs first time 22 seconds then under 2 seconds atter that. But on the website its timing out everytime.

Im wondering it IIS is the problem here? Is there any checks i can do in IIS6 other than increasing timeout?
0
Comment
Question by:wilko100
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 20

Expert Comment

by:Marten Rune
ID: 39186198
You have recycled the IIS application pool I take it.

Next case is a profiler measuring whats happening on the SQL

perhaps combined with a netmon on the IIS

/Regards Marten
0
 

Author Comment

by:wilko100
ID: 39187949
Hi

The app pool gets recycled every night. The netmon sounds a good route to take. The SQL SP looks quite effecient but it is somethign i may need to double check later
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39188605
Perhaps it is time to optimize the query that generates the report.  How many rows are returned in SSMS?
0
 

Accepted Solution

by:
wilko100 earned 0 total points
ID: 39189281
It reutns around 50 rows however there are a couple of views it used so yes that something i may need to do.
I wanted to check the IIS first though, i can see these in the IIS log that look like status errors?:

localhost 500 0 10349 1119 60875

 i aslso noticed this today in the HTTERR logs:

2 - Connection_Dropped MyAppPool

I can see quite a few of them, is this something that can indicate network?
0
 

Author Closing Comment

by:wilko100
ID: 39313524
no solution found
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

626 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