locked
SSRS 2005 - The page cannot be displayed RRS feed

  • Question

  • Hello.

    I have a problem.

    I'm trying to run my report.

    Report begin generating (there're displaying animated picture "generating report")
    After some time (nearly 30 minutes) a have an "error"

    "The page cannot be displayed"

    What is it? And how can I fix it?

    Thanks.
    Tuesday, July 28, 2009 9:34 AM

Answers

  • Hi Mynameisvova,

     

    Ah, another huge report. It seems this issue is caused by the timeout setting, but there are lots of pleases related timeout setting, if I remember correctly, you can check the following point:

     

    1.    Report Manager->Site settings->Report Execution Timeout->select “do not timeout report execution”.

     

    2.   Open C:\Program Files\Microsoft SQL Server\MSSQL\ReportingServices\ReportManager\Web.config,
    C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
    Services\ReportServer\Web.config
    Search for <httpRuntime executionTimeout="9000"/> Change it to 18000

     

    3.  Open C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting
    Services\ReportServer\rsreportserver.config
    Search for <Add Key="SQLCommandTimeoutSeconds" Value="60"/>
    <Add Key="MaxActiveReqForOneUser" Value="20"/>
    <Add Key="DatabaseQueryTimeout" Value="120" />


    Increase these values and then test it.


    4.
        Check the timeout setting in dataset.

     

    Also, what is the type of data source, you should make sure the datasoure is not timing out too.

     

    Hope this helps.

    Raymond

    Thursday, July 30, 2009 3:02 AM

All replies

  • Hi,

    Is the report very bog so time out occurs. You may have to increase the session timeout value. You can also have a look at the server log files to find the problem
    http://msdn.microsoft.com/en-us/library/ms156500.aspx
    If you are working with SQL 2005 you have to check IIS settings.

    Gouri Sohoni
    Tuesday, July 28, 2009 10:32 AM
  • What settings I need to check in the IIS ?

    >You may have to increase the session timeout value
    In the IIS ?
    Tuesday, July 28, 2009 11:08 AM
  • Error appears during report generating.

    I have no VPN connection,
    Tuesday, July 28, 2009 2:02 PM
  • Hi Mynameisvova,

     

    Ah, another huge report. It seems this issue is caused by the timeout setting, but there are lots of pleases related timeout setting, if I remember correctly, you can check the following point:

     

    1.    Report Manager->Site settings->Report Execution Timeout->select “do not timeout report execution”.

     

    2.   Open C:\Program Files\Microsoft SQL Server\MSSQL\ReportingServices\ReportManager\Web.config,
    C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
    Services\ReportServer\Web.config
    Search for <httpRuntime executionTimeout="9000"/> Change it to 18000

     

    3.  Open C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting
    Services\ReportServer\rsreportserver.config
    Search for <Add Key="SQLCommandTimeoutSeconds" Value="60"/>
    <Add Key="MaxActiveReqForOneUser" Value="20"/>
    <Add Key="DatabaseQueryTimeout" Value="120" />


    Increase these values and then test it.


    4.
        Check the timeout setting in dataset.

     

    Also, what is the type of data source, you should make sure the datasoure is not timing out too.

     

    Hope this helps.

    Raymond

    Thursday, July 30, 2009 3:02 AM
  • if report is using a query or sp check that in Managment studio what is its execution time.
    Shamas Saeed MCITP-DBD 2005 http://sqlservercoollinks.blogspot.com
    Thursday, July 30, 2009 6:15 AM