Report Request Timeout

6 posts, 0 answers
  1. cheekl
    cheekl avatar
    55 posts
    Member since:
    Jul 2012

    Posted 03 Oct 2008 Link to this post

    When a report is huge (> 50 Pages), I always receive an error message : Request Timeout.

    I checked my query from backend. It takes only 4 second the get the result.

    I have tried to change the SQL select command's Command timeout = 1200.

    What setting I can changed to extend the timeout so that report viewer can shows the result?

  2. Chavdar
    Chavdar avatar
    898 posts

    Posted 03 Oct 2008 Link to this post

    Hello cheekl,

    By default the connection timeout of the web server (IIS) is 120 secs. You can receive this error if the report generation time is more than this timeout. How to modify it is explained in the Setting Connection Timeout article. I have also attached a screenshot for IIS6.

    Hope this helps.

    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. DevCraft R3 2016 release webinar banner
  4. Rik
    Rik avatar
    8 posts
    Member since:
    Jun 2010

    Posted 21 Dec 2010 Link to this post

    Has this issue been resolved yet? We're experiencing the same issue when loading reports that are over 50 pages.

    Would appreciate any feedback.

  5. Steve
    Steve avatar
    10941 posts

    Posted 22 Dec 2010 Link to this post

    Hi Rik,

    This forum thread is more than two years old and you are the first one to bring it up. It would be best if you open a support ticket where you provide detailed information about your setup or even better, provide us with a runnable sample project that exhibits the problem. You did not provide any information whether this is a problem only when hosting the application in IIS or it occurs on the built-in server as well.

    the Telerik team
    Get started with Telerik Reporting with numerous videos and detailed documentation.
  6. Soumya
    Soumya avatar
    19 posts
    Member since:
    Feb 2014

    Posted 19 Jul Link to this post

    Hi Telerik Team,

    We are facing a similar issue. There is a Telerik report with two datasources. Queries of the datasources when run in SQL server directly shows result withing 4secs. The same query when run by the report either times out or takes a long time to show up. 

    Connectionstring is dynamically updated. There are 6 tables in the report with one row each. When the row is clicked, another report opens.Parent report takes a long time to load for the first time. Child report opens quickly.

    CommandTimeout is set with value 600. Connection Time-out in IIS is set to 601. Still there is no improvement. On running 'dbcc freeproccache' in SQL server, the report gets generated in a few seconds. But, the next time report is generated, the issue is back. We are working with ASP.Net Webforms Telerik Reporting

    Please suggest what could be wrong and what could be done to see the report quickly. Running 'dbcc freeproccache' often is not feasible. 

  7. Stef
    Stef avatar
    2922 posts

    Posted 22 Jul Link to this post

    Hello Soumya,

    Each data item executes its data retrieval method on its own. Beside retrieving data the reporting engine needs time to create objects and resources related to the rendered document.

    In case of retrieving large amounts of data records:
    1. Check Performance Considerations;
    2. Set the SqlDataSource.CommandTimeout to a greater value and provide a greater Connection_Timeout in the connection string.
    3. Verify that the machine can handle the report processing and rendering (CPU and memory). You can test hosting in a web farm and to enable the corresponding viewer's cache - Cache Management.
    4. Test data-binding approaches where a container's data is reused by nested data items - Use DataObject as a datasource for nested data items (Table, List, Crosstab, Graph).

    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top
DevCraft R3 2016 release webinar banner