timeout with WebForms ReportViewer on server only

9 posts, 0 answers
  1. Andrew Swindler
    Andrew Swindler avatar
    9 posts
    Member since:
    Sep 2005

    Posted 04 May 2010 Link to this post

    I'm creating a project in VisualStudio 2005 that uses a WebForms ReportViewer.  It runs just fine locally when debugging with VS.  I deployed it to a server and can bring up the page with the ReportViewer just fine.  And I know it's connecting to the database OK because one of the parameters populates via a stored procedure, and quite quickly.  The stored procedure that drives the report itself also should return quickly - it does when I run it directly with the parameters the report would send it.  But when I try to run the report it hangs for about 30 seconds and then displays this:
    An error has occured while processing Report '': 
    Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 


  2. Andrew Swindler
    Andrew Swindler avatar
    9 posts
    Member since:
    Sep 2005

    Posted 07 May 2010 Link to this post

    The timeout is definitely 30 seconds.  I still can't find it.  It's not on the SQL connection or the app itself, as I have them set to 60 minutes (just to rule them out for now):

    <add name="TelerikReportingTestReports.Properties.Settings.NutritionDB2" 
            connectionString="Data Source=localhost;Initial Catalog=PinpointScratch;Persist Security Info=True;User ID=nutrition;Password=nut295;Connect Timeout=3600" 
            providerName="System.Data.SqlClient" /> 
             
    <httpRuntime executionTimeout="3600" /> 

     Can anyone help?
  3. DevCraft banner
  4. Milen
    Admin
    Milen avatar
    163 posts

    Posted 10 May 2010 Link to this post

    Hi Andrew,

    Indeed, this is a limitation on our end we are aware of when using SqlDataSource. In the next internal release (it should be out in a week's time) the SqlDataSource will expose a timeout setting.

    Sorry for the inconvenience and thank you for the provided feedback.
     

    Best wishes,
    Milen
    the Telerik team

    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 Public Issue Tracking system and vote to affect the priority of the items.
  5. Andrew Swindler
    Andrew Swindler avatar
    9 posts
    Member since:
    Sep 2005

    Posted 10 May 2010 Link to this post

    Can I get around it by using an ObjectDataSource?  What's the quickest way to create one that runs a stored procedure with parameters, same as a SqlDataSource would?
  6. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 11 May 2010 Link to this post

    Hi Andrew,

    Yes, filling your data into DataSets and using ObjectDataSource component to bind the report is currently the way to go. More info is available in this help article: How to: Bind to a DataSet.

    All the best,
    Steve
    the Telerik team

    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 Public Issue Tracking system and vote to affect the priority of the items.
  7. Andrew Swindler
    Andrew Swindler avatar
    9 posts
    Member since:
    Sep 2005

    Posted 11 May 2010 Link to this post

    Nice, I found this page a little more helpful in my case: http://www.telerik.com/help/reporting/object-data-source-how-to-bind-to-business-object.html
    Combined with this for dealing with dynamic report parameters: http://www.telerik.com/help/reporting/object-data-source-using-expressions.html (especially the "=Parameters.XXXX" part, which wasn't clear elsewhere)

    However, my report still runs long.  And I actually got the 30 second timeout thing until I upped the timeout on my SqlCommand object.  But I run the same stored procedure with the same parameters directly and it comes back within a second.  Running it via ReportViewer control it takes over a minute.

    Any ideas what might be going on?
  8. Andrew Swindler
    Andrew Swindler avatar
    9 posts
    Member since:
    Sep 2005

    Posted 13 May 2010 Link to this post

    Turns out it was an issue with a pre-existing stored procedure that was run a lot on my prod server, and I needed to run DROPCLEANBUFFERS and FREEPROCCACHE.  Along the lines of this forum topic: http://stackoverflow.com/questions/250713/sqldataadapter-fill-method-slow

    So, unrelated to Telerik.
  9. Bob
    Bob avatar
    21 posts
    Member since:
    Mar 2008

    Posted 24 Jan 2012 Link to this post

    Milen,

    Did you fix the SqlDataSource problem with timeout's?

    Regards,

    Bob


  10. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 25 Jan 2012 Link to this post

    Hello,

    This forum is almost two years old and discusses missing setting for timeout in the SqlDataSource component. Such property is already exposed via the CommandTimeout Property.

    Kind regards,
    Steve
    the Telerik team

    Q3’11 of Telerik Reporting is available for download. Register for the What's New in Data Tools webinar to see what's new and get a chance to WIN A FREE LICENSE!

Back to Top
DevCraft banner