This is a migrated thread and some comments may be shown as answers.

"Report is unavailable or session has expired."

3 Answers 104 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
AH
Top achievements
Rank 1
AH asked on 14 May 2012, 12:36 PM
Hello there.

I am using Telerik Reporting in Silverlight and for the most part, it works pretty well. I start the report from my Silverlight-project and  Silverlight ReportViewer opens. Then I have ReportLibrary where I have reports. My reports uses objectdatasources which search data from database. Datasource is a class in ReportLibrary, datamember is IQueryable-method in that class and then there's couple of parameters. With this kind of solution reports gets data from our database.

But especially reports with more than one objectdatasource occasionally gives the error "Report is unavailable or session has expired.", even though rendering haven't taken that much time.

After I press refresh button once or twice, the error disappears and Silverlight reportviewer shows the report correctly.

I know that there is an article about that error, but I would still like to know what is the most likely reason for this kind of behavior?

Thanks.

3 Answers, 1 is accepted

Sort by
0
Accepted
Steve
Telerik team
answered on 17 May 2012, 08:39 AM
Hello Asku,

Reading your description of the problem, it sound like you experience #2 Session is lost. You can review the possible reasons for this problem and make the necessary changes i.e. check whether you're not running out of memory if the report is large, apply out-proc session handling if this is a web farm and check windows error logs for any sign of problems. Additionally if you're running an Azure project, in Azure when you use multiple web roles, you have to use an out-proc session i.e. multiple roles act similar to web farm and you need common session. Adding ASP.NET Session State Provider for Windows Azure should prevent the "Report is unavailable or session has expired" error and reports should appear consistently.

Regards,
Steve
the Telerik team

BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >

0
ajpetersen
Top achievements
Rank 1
answered on 20 Feb 2013, 08:06 PM
Asku,

Thank you for your answer. I believe this is the solution I need, but can you give me an example of how to Add the ASP.NET Session State Provider for Windows Azure for my Telerik Report?

I am using windows azure for my project and I am having the same problem as the OP except I have a very small report.

Below is a snippet of my SessionState in the web.config.

<sessionState mode="InProc" customProvider="DefaultSessionProvider">
      <providers>
        <add name="DefaultSessionProvider" type="System.Web.Providers.DefaultSessionStateProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="DefaultConnection" />
      </providers>
</sessionState>

Thanks for your help!
0
Stef
Telerik team
answered on 25 Feb 2013, 04:49 PM
Hello Claude,

Please, check the following articles:

If you are using multiple instances then you have to use an out-proc session to preserve the viewer's state between the different instances. In Azure using the AppFabric Cache Provider is the only feasible solution as Microsoft does not support SQL Session State Management using SQL Azure databases.

I hope this helps.

Regards,
Stef
the Telerik team

See what's new in Telerik Reporting Q1 2013. Register for the March 4 webinar to witness the impressive new visualizations in Telerik Reporting. Just for fun, 10 webinar attendees will be randomly selected to win a Telerik T-shirt and a $50 Gift Certificate to ThinkGeek. Register now! Seats are limited!

Tags
General Discussions
Asked by
AH
Top achievements
Rank 1
Answers by
Steve
Telerik team
ajpetersen
Top achievements
Rank 1
Stef
Telerik team
Share this question
or