Home

Products
       NCAA Tourney
       Loan Calculator
       Text / HTML Versioner
       HTML Fader
       HTML Scheduler
       SQL Reporting Services
       MySkype

Support & Forums
Tuesday, September 07, 2010 You Are Here: Support & Forums  | 
Welcome to Module Masters support forums - the primary support mechanism for our products. Feel free to post your questions, and we will aim to respond in a timely manner.  We also encourage our users to post any feedback you may have.  You may also email us directly at service@modulemasters.com
Forums > Module Masters Forum > SQL Reporting Services
Subject: Timeout Problem
Prev Next
You are not authorized to post a reply.

Author Messages
chiptayUser is Offline

Posts:12
08/06/2007 09:57  
We have a large report that takes about 2 minutes and 10 seconds to run, but we're now getting a timeout error when trying to run this report inside of DNN:

System.Exception: Unhandled Error: ---> System.Web.HttpException: Request timed out. --- End of inner exception stack trace ---
I can run this report from the SSRS Report Manager page with no problem.

We recently upgraded to version 1.5 of this module, but I'm not sure if that has anything to do with it. This report, although it takes a while to run, used to work before the upgrade.

Thanks. - ChipTay
hostUser is Offline

Posts:449
08/06/2007 10:20  
There should be more detail over in the log viewer under admin, can you pass that along here.
chiptayUser is Offline

Posts:12
08/06/2007 10:28  
AssemblyVersion: -1
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider:
ExceptionGUID:
InnerException: Unhandled Error:
FileName:
FileLineNumber: -1
FileColumnNumber: -1
Method:
StackTrace:
Message: System.Exception: Unhandled Error: ---> System.Web.HttpException: Request timed out. --- End of inner exception stack trace ---
Source:
Server Name: SERVER1
chiptayUser is Offline

Posts:12
08/06/2007 10:31  
Here's an earlier one:

AssemblyVersion: 04.03.07
PortalID: 0
PortalName: Portal1
UserID: -1
UserName:
ActiveTabID: 36
ActiveTabName: Home
RawURL: /hce/Reserved.ReportViewerWebControl.axd?ReportSession=j0cfyr55d3rd5s55oucsba55&ControlID=3c3ee40e-4e25-42b1-bc47-94dbc1ed3a9d&Culture=1033&UICulture=1033&ReportStack=1&OpType=ReportArea&Controller=ClientControllerdnn_ctr505_ViewRS2005__ctl0_ReportViewer1&PageNumber=1&ZoomMode=Percent&ZoomPct=100&ReloadDocMap=true&EnableFindNext=False&LinkTarget=_top
AbsoluteURL: /hce/Reserved.ReportViewerWebControl.axd
AbsoluteURLReferrer: http://w2k3-ght/hce/Reserved.ReportViewerWebControl.axd?OpType=DocMapReport&ClientController=ClientControllerdnn_ctr505_ViewRS2005__ctl0_ReportViewer1&ReportUrl=%2fhce%2fReserved.ReportViewerWebControl.axd%3fReportSession%3dj0cfyr55d3rd5s55oucsba55%26ControlID%3d3c3ee40e-4e25-42b1-bc47-94dbc1ed3a9d%26Culture%3d1033%26UICulture%3d1033%26ReportStack%3d1%26OpType%3dReportArea%26Controller%3dClientControllerdnn_ctr505_ViewRS2005__ctl0_ReportViewer1%26PageNumber%3d1%26ZoomMode%3dPercent%26ZoomPct%3d100%26ReloadDocMap%3dtrue%26EnableFindNext%3dFalse%26LinkTarget%3d_top
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: c5863790-9b7f-4188-b25e-c658dd7ec7ba
InnerException: Unhandled Error:
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Microsoft.Reporting.WebForms.ReportDataOperation..ctor
StackTrace:
Message: System.Exception: Unhandled Error: ---> Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired at Microsoft.Reporting.WebForms.ReportDataOperation..ctor() at Microsoft.Reporting.WebForms.HttpHandler.GetHandler() at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --- End of inner exception stack trace ---
Source:
Server Name: Server1
hostUser is Offline

Posts:449
08/06/2007 12:05  
In the web.config, please go to the tag and increase the executionTimeout. Maybe double it's value.
hostUser is Offline

Posts:449
08/06/2007 12:06  
I mean the httpRuntime section!
chiptayUser is Offline

Posts:12
08/06/2007 12:12  
I don't see execution timeout in httpRuntime. Here's what I have:
chiptayUser is Offline

Posts:12
08/06/2007 12:13  
My above message didn't post correctly:

httpRuntime useFullyQualifiedRedirectUrl="true" maxRequestLength="8192" requestLengthDiskThreshold="8192"
chiptayUser is Offline

Posts:12
08/06/2007 12:36  
I added executionTimeout="9000" and it's working now.

Thanks a bunch!

ChipTay
You are not authorized to post a reply.
Forums > Module Masters Forum > SQL Reporting Services > Timeout Problem


ActiveForums 3.7
Copyright 2005 by Module Masters Privacy StatementTerms Of Use