timeout with WebForms ReportViewer on server only

[Andrew Swindler]

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.

[Andrew Swindler]

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?

[Milen | Product Manager @DX]

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.

[Andrew Swindler]

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?

[Steve]

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.

[Andrew Swindler]

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?

[Andrew Swindler]

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.


[Bob]

Milen,

Did you fix the SqlDataSource problem with timeout's?

Regards,

Bob

[Steve]

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