Home

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

Support & Forums
Saturday, February 04, 2012 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: ASP.NET session has expired
Prev Next
You are not authorized to post a reply.

Author Messages
jamescUser is Offline

Posts:1
04/30/2008 19:37  

I am consistently getting a message when trying to view a report that has been set up:

Exception Details: Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[AspNetSessionExpiredException: ASP.NET session has expired]
   Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +678
   Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +561
   Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +10
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +358
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

The module will display the parameters but below the parameter bar where the repoort should display I get the message above.  I am also intermitently getting a message "this Module has Expired. Please visit..."  Occasionaly it will run and display the report correctly in the module. Each time I refresh the page it's different.

The module has been paid for and downloaded from your site. Any ideas? 

 
hostUser is Offline

Posts:497
04/30/2008 20:50  
What version of the module are you using?  Was this working for some time and then this error started happening?  It appears that there is some soft of session issue.  How is your web.config configured to handle sessions?
JamesUser is Offline

Posts:4
04/28/2010 11:37  
This is an older thread, but no resolution seems to be posted.  I'm seeing this exact same issue in a DNN 4.9.0 install, using version 04.01.00 of the SQL Reporting Services module.  Is there an easy solution to this?  Was a resolution to this issue ever found?

Thanks!
hostUser is Offline

Posts:497
04/28/2010 12:25  
There are some session timeout settings in the web config file, Please check these and the file size settings in there too.
JamesUser is Offline

Posts:4
04/28/2010 12:57  
Which settings are you thinking of, the httpRuntime executionTimeout settings? I saw another reference to that one (in another post for a similar error), but I wasn't sure if it would affect this or not
hostUser is Offline

Posts:497
04/28/2010 13:01  
Yes, bump those up
JamesUser is Offline

Posts:4
04/28/2010 16:56  
OK, I've added both executionTimeout="9000" and shutdownTimeout="3600" to my web.config in DotNetNuke, and can still recreate this error.

If I load up a report in DNN that has multiple pages, I can make this happen every time.  I load the report no problems.  Then I leave it alone for 15 minutes.  Go back, and try to use the navigation bar to go to the next page.  It comes up every time.
hostUser is Offline

Posts:497
04/28/2010 17:15  
email your web.config to service@modulemasters.com
jdroger2User is Offline

Posts:4
07/21/2010 22:22  
any resolution on this?  I am using DNN 5.4.4 and Reporting Services v4.2.0 and having the same issue. 

in my web.config I have:


Thanks!
jdroger2User is Offline

Posts:4
07/21/2010 22:24  
from my web.config
 
jdroger2User is Offline

Posts:4
07/21/2010 22:26  
try #3


httpruntime executiontimeout="5930" requestlengthdiskthreshold="8192" maxrequestlength="20000" uefullyqualifiedredirecturl="true"
hostUser is Offline

Posts:497
07/21/2010 22:48  
Yes, this is an issue with the session timing out. You can check the application pool setting in iis to see what it is set to and you can checkout this link as well.

http://forums.asp.net/t/1143744.aspx
jeropsUser is Offline

Posts:2
09/14/2010 15:04  

I was having the same issue and I solved it using the information found here:

http://shahamishm.blogspot.com/2009/07/advanced-property-sql-server-reporting.html

I had my SessionTimeout = 600...I reset to match my web.config of 208192.

And that has seem to resolve my issue.

I hope this helps someone else...It took me a long time to figure this one out.

Thanks.
jeropsUser is Offline

Posts:2
05/12/2011 15:34  

Hi,

The asp.net timeout issue has reared it's ugly head again, but this time my situation is different.  I moved my portal from a single server environment to a IIS Clustered environment.

I have discovered that in order to fix the issue I needed my portal store the ASP.NET session in SQL Server.  Review the instructions here to fix the issue: https://support.powerdnn.com/index.php?/Knowledgebase/Article/View/67/26/store-aspnet-session-in-sql-server

On one of my IIS heads in the cluster I ran the following from the CMD PROMPT to create the ASPState database:
C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regsql.exe -S DATABASESERVER - E -ssadd -sstype p

Once the database is created, you will need to create a SQL service account and map it to the ASPState DB. 

Once that is completed, follow the instructions in the link above and use the new SQL account in the web.config string that you will add.

I hope this helps.
You are not authorized to post a reply.
Forums > Module Masters Forum > SQL Reporting Services > ASP.NET session has expired



ActiveForums 3.7
Copyright 2011 by Module Masters Privacy StatementTerms Of Use