Error : The Operation Has Timed Out In SSRS Report Server


1) Set the HttpRuntime ExecutionTimeout value to a greater value (ie 3 hours) on the Report Server


   a.      Open the ReportServer’s Web.config file by going to Start -> Administrative Tools -> 
            Internet Information Services.
   b.      From there, expand Web Sites -> Default Web Site, and click on ReportServer. On the right-h
            zand pane, right-click ‘Web.Config’ and select ‘Open’.
   c.      Locate the HttpRuntime parameter. If it doesn’t exist, you will have to create it within the 
           <System.Web> section.
   d.      Set the executionTimeout value to ‘10800’ (3 hours) as shown below:

           <system.web>
          < httpRuntime executionTimeout = "10800" />
          < /system.web>


2) Increase the script timeout on the report server

   1. Go onto your Reporting Server and open up Internet Information Services; right-click on the  
       ReportServer and select Properties.
   2. Go to the Options tab, and set the ASP Script timeout to 300 seconds as shown below.

3) Set the report to never time out on the server

   1. Open your web browser on the server and go to http://localhost/Reports
   2. Navigate to the Report location and click on the problem report(s).
   3. On the left-hand pane, click on Properties.
   4. In the ‘Report Execution Timeout’ click the ‘Do not timeout report execution’.

Comments

  1. Great article,Thank you for sharing this awesome Post.
    Keep updating....

    MSBI Online Training

    ReplyDelete

Post a Comment

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular Posts

Failed to execute the package or element. Build errors were encountered

Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

Cannot convert "Column" between a unicode and a non-unicode string data types in SSIS