Overview

This article describes the steps needed to fix the SSRS timeout issues for reporting.

Steps

1. Navigate to the Directory where the AdminUI web page content is present: C:\Program Files (x86)\Verdiem\Surveyor\AdminUI

   

2. Right click on the ASPX page named ReportViewerWebForm.aspx and select Edit.

   

3. In this file, search for the tag <asp:ScriptManager>. The present form of this tag will be

   <asp:ScriptManager ID="ScriptManager1" runat="server">

    The below attribute has to be added to override the default timeout.

     <asp:ScriptManager ID="ScriptManager1" runat="server" AsyncPostBackTimeOut="1800" > 

   NOTE : 1800 indicates that the server web page will wait for 1800 seconds (30 Minutes), for the report server to respond before ending the connection with it. 

The steps to disable the timeout at dataset and RDL level are described below. Timeout values can be specified at both the RDL and Dataset level.

1. Navigate to Report Manager.
   1. Open the Report Configuration Manager in the server where the reports are deployed.

      Start > Program Files > Microsoft SQL server > Configuration Tools > SQL Server<version> Reporting Services Configuration Manager

   2. Click on Report Manager URL.

      

   3. Click on URL to open the Report Manager.

      

2. Once Report Manager is opened, you need to find the RDL files and associated dataset to Disable timeout.  Below is an example for the ComputerUserState15Min reports.

   RDL Files	Dataset Associated to RDLs
   Act_ComputerUseState15Min.rdl	ComputerUseState15min
   Act_ComputerUseState15Min_drill.rdl	ComputerUseState15Min_Drill

3. The RDL files are present in the Reports folder. Navigate to that folder and click on the down arrow which is beside the particular RDL file. Select Manage (Note that the pull-down may not function in some browsers).

    

4. After reaching the Manage page. Click on Processing Options, select Do not timeout report and click on Apply.

   

5. Repeat steps 3 and 4 for " Act_ComputerUseState15Min_drill.rdl ".

The steps to disable the timeout for a particular Dataset are presented below.

1. In the Report Manager page, navigate to the Datasets folder. Click on Manage.

   

2. Set the value in the text box to 0 to disable the query timeout, then click on Apply.

    

3. Apply the same settings for the dataset " ComputerUseState15Min_Drill " to complete the process.