locked
Time out error on Report builder RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    There is a report I built that pulls a lot of data understandably.

    However, when I run this report, it times out. I have set the time out value to be 0 and it still times out.

    The only error it brings is that, The operation has timed out..

    Please help

    Thursday, January 15, 2015 6:09 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi sanjb12001,

    As per my understanding, you created a report, when you run the report with report builder, you got the error message: The operation has timed out.

    The report server does not limit the size of a report definition. However, ASP.NET imposes a maximum size for items that are posted to the server. If we upload or publish a report definition that exceeds this limit to a report server, you receive an HTTP exception. To solve the problem, we can set the executionTimeout to 3600 (seconds) and set maxRequestLength to 2097151 in the httpRuntime tag of the web.config file(location: C:\Program Files\Microsoft SQL Server\ServerInstance \Reporting Services\ReportServer) like below:

    <system.web>
      <httpRuntime maxRequestLength="2097151" executionTimeout="3600"/>
</system.web>

    If the problem remain unresolved, i would appreciate it if you could give us detailed error log(default location: %programfiles%\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles), it will help us move more quickly toward a solution.

    Thanks,
    Wendy Fu

    Wendy Fu
    TechNet Community Support


    • Proposed as answer by Wendy Fu Saturday, January 24, 2015 8:48 AM
    • Marked as answer by Wendy Fu Sunday, January 25, 2015 12:38 PM
    Sunday, January 18, 2015 8:15 AM