Trying to use the SSRS Reporting (ReportViewer) Control on a ASP.Net Page with long process time. Using ASP.Net 4.5 Web Forms

Pat Brown 1 Reputation point
2020-10-14T15:49:14.38+00:00
  1. On a long report(over 10 minutes that outputs a file) the ReportViewer Control will disappear
    Also the Process/Cancel message disappears after a couple of minutes but I fixed that adding AsyncPostBackTimeOut="5000"

2 Also on the 1st report of the day we get but only the 1st time. After the 1st time
The report execution hclfqmf5t0bfw255aozncrus has expired or cannot be found. (rsExecutionNotFound)

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,912 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,576 Reputation points
    2020-10-15T02:48:49.447+00:00

    Hi @Pat Brown ,
    In the ReportServer database, there is a table called ConfigurationInfo. In this table, there are the values of SessionTimeout and SessionAccessTimeout. I think it is set to "600". This value corresponds to the number of seconds that the report session will be open.
    I suggest raising this number for a few hours Neal consecutively.
    The way to set this property is to use some Reporting Service Scripting, .rss files, and run them using the rs.exe utility that was installed with Reporting Services.
    Try this method and if you have any question, please feel free to let me know.
    Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.