none
SSRS report returns errorL ASP.NET session has expired or could not be found

    Question

  • I'm running sql 2008 R2 and SSRS 2008 R2, and am trying to pull reports in an aspx page using the aspnet report viewer.  I have an application that's been running fine for years until now.  for each client, we setup dedicated website and dedicated folder in SSRS where the reports for each client live.  all reports for all clients are identical accept for the datasource which points to each client's database.  so in short, all instances of this application are identical.  this summer I bought a new dev computer (windows 8) and upgraded everything to the latest MS tools (VS 2012 ultimate, sql 2012, etc.) but the server is still 2008.  Now I setup 2 new applications for 2 new clients and the code base is all the same, but I get this error when trying to run a report:

    SSRS report returns errorL  ASP.NET session has expired or could not be found

    So I went to my old dev computer (Win7, Bids 2008, etc) and deployed a report from that machine to one of the new report folders and that report still gets this error message.  I've spent hours google with no luck.

    Any ideas how to trouble shoot this?  all the other client's reports work fine - all running on the same server using the same code base (application files).

    Thanks.

    Wednesday, September 04, 2013 9:18 PM

Answers

  • Thanks.  I found the problem.  I had an underscore in the website's URL which caused the problem.  I saw a post somewhere else about evil underscores and reports, but that post referred to it being used in the report's path, which I thought they meant report path in SSRS.  After creating a new domain and URL with out the underscore, all worked good.
    • Marked as answer by moondaddy Thursday, September 05, 2013 3:31 PM
    Thursday, September 05, 2013 3:31 PM

All replies

  • Hello,

    The ASP.Net ReportViewer relies on ASP.Net session state to store critical data that can’t always be easily regenerated. The report viewer may throw an AspNetSessionExpiredException when information it previously placed in session is not available during a postback or HTTP handler operation.
    To troubleshoot this issue, please try to set the property value to report view, set the KeepSessionAlive to true.

    If the issue presists,please let me know.

    Regards,
    Fanny Liu

    If you have any feedback on our support, please click here.


    Fanny Liu
    TechNet Community Support

    Thursday, September 05, 2013 11:03 AM
  • Thanks.  I found the problem.  I had an underscore in the website's URL which caused the problem.  I saw a post somewhere else about evil underscores and reports, but that post referred to it being used in the report's path, which I thought they meant report path in SSRS.  After creating a new domain and URL with out the underscore, all worked good.
    • Marked as answer by moondaddy Thursday, September 05, 2013 3:31 PM
    Thursday, September 05, 2013 3:31 PM