Reports Render : ASP.NET session has expired

[Database Administrator]

Hello All,

I am getting ASP.Net session expired error when I try to run a report
from my deployment server. I am using SQL Server Reporting Services
2005 and report viewer control to render report. Report processing
mode is Remote.
I searched many forums, they say that we need to use single worker
process[ this can't be done since it impacts performance ], some say
EnableSessionState on the aspx page[ this is not working]. Can some
body help me out in this? Any pointers would be of great help.
Following is the details of the error I am getting:
------------------------------------------------------------------------------------------------------------------------------------------------------------------
ASP.NET session has expired
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details:
Microsoft.Reporting.WebForms.AspNetSessionExpiredE xception: 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() +559
Microsoft.Reporting.WebForms.HttpHandler.GetHandle r(String
operationType) +470
Microsoft.Reporting.WebForms.HttpHandler.ProcessRe quest(HttpContext
context) +53

System.Web.CallHandlerExecutionStep.System.Web.Htt pApplication.IExecutionStep.Execute()
+358
System.Web.HttpApplication.ExecuteStep(IExecutionS tep step,
Boolean& completedSynchronously) +64




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433;
ASP.NET Version:2.0.50727.1433

---------------------------------------------------------------------------------------------------------------------------------------------------------------

Thanks,
Vani

[Database Administrator]

Hello Vani,

I had the same problem. Here is what I found that fixed the problem in my
case, it may help you. At the forums there are a lot of people that said that
the report will automatically keep alive the connection, however, this did
not happen in my case and that is how I got the time-outs.

- The 1st thing you need to do is figure out about how long it takes for the
time-out to occur. In my case this was 2 hours.
- In the Design tab of your chart, right-click outside of the page area, in
the menu that appears click "Properties". (You can also use the following to
get to the window if your page is pretty big: Report > Report Properties...)
- In the General tab, on the bottom, you will find an "Autorefresh:"
checkbox. Enable it.
- In the "(seconds)" number field select any value smaller than your session
time-out time.

I'm pretty sure you know how to convert minutes and/or hours to seconds, so
that I will not explain. ^_^

Hope this solution works!

Greets,

Stitch10925

-------

"Vani" wrote:

> Hello All,
>
> I am getting ASP.Net session expired error when I try to run a report
> from my deployment server. I am using SQL Server Reporting Services
> 2005 and report viewer control to render report. Report processing
> mode is Remote.
> I searched many forums, they say that we need to use single worker
> process[ this can't be done since it impacts performance ], some say
> EnableSessionState on the aspx page[ this is not working]. Can some
> body help me out in this? Any pointers would be of great help.
> Following is the details of the error I am getting:
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------
> ASP.NET session has expired
> Description: An unhandled exception occurred during the execution of
> the current web request. Please review the stack trace for more
> information about the error and where it originated in the code.
>
> Exception Details:
> Microsoft.Reporting.WebForms.AspNetSessionExpiredE xception: 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() +559
> Microsoft.Reporting.WebForms.HttpHandler.GetHandle r(String
> operationType) +470
> Microsoft.Reporting.WebForms.HttpHandler.ProcessRe quest(HttpContext
> context) +53
>
> System.Web.CallHandlerExecutionStep.System.Web.Htt pApplication.IExecutionStep.Execute()
> +358
> System.Web.HttpApplication.ExecuteStep(IExecutionS tep step,
> Boolean& completedSynchronously) +64
>
>
>
>
> --------------------------------------------------------------------------------
> Version Information: Microsoft .NET Framework Version:2.0.50727.1433;
> ASP.NET Version:2.0.50727.1433
>
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Thanks,
> Vani
>