SQL Azure Reporting from ASP.NET MVC3 Razor: session has expired or could not be found RRS feed

  • Question

  • Hello,

    I have my Web App (ASP.NET MVC3 Razor view) hosted in Azure that uses Report Viewer to pull reports saved in SQL Azure Report Server. I get " session has expired or could not be found" error many time when we try to execute same report at same time or pull multiple reports at same time.

    <sessionState mode="InProc" timeout="1000">
    This is how currently set in our application. We can reproduce the issue where we get error “ session has expired or could not be found”.

    If I did below change:
    <sessionState mode="InProc" cookieless="true" timeout="1000">
    All reports work fine, but the session get added to URL like:
    Is there a way I can get rid of this here?

    Other Options on Net:
    <sessionState mode="StateServer" stateConnectionString="tcpip=localhost:42424" cookieless="false" timeout="1000">
    Making Session saved in ASP.NET State Server should work, but this require Asp.NET State service to be running, and by default this service is NOT started in the Azure VM or Local Machines.

    Please advise what is the BEST option to make this issue resolved?

    Tuesday, April 17, 2012 5:46 PM


All replies