This is a migrated thread and some comments may be shown as answers.

Change Query Timeout Limit

12 Answers 823 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

12 Answers, 1 is accepted

Accepted

answered on 04 Jan 2010, 11:45 AM

Hello Bradley,

Telerik Reporting does not provide its own data layer but depends on the existing .NET objects (DataSet, Data Table, DataView, ADO.NET, lists - for more information on report data binding, please, refer to this help topic). In this line of thoughts, it is up to the developer to prepare and provide the DataSource for the report. This holds true for altering the settings of the SqlCommand as well e.g.:

private void Report1_NeedDataSource(object sender, System.EventArgs e)

{

SqlCommand sqlSelectCommand1 = new SqlCommand();

sqlSelectCommand1.CommandTimeout = 40;

SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter();

SqlConnection sqlConnection1 = new SqlConnection();

sqlConnection1.ConnectionString = "Data Source=(local)\\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True";

sqlSelectCommand1.CommandText = "SELECT * FROM Production.Product";

sqlSelectCommand1.Connection = sqlConnection1;

sqlDataAdapter1.SelectCommand = sqlSelectCommand1;

(sender as Telerik.Reporting.Processing.Report).DataSource = sqlDataAdapter1;

}

Regards,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

answered on 30 Apr 2010, 06:09 PM

Hi Steve Johnson,

With Q1 2010 we have introduced a SqlDataSource Component. The example that my colleague sent you is about the SqlCommand. Do you want to set the timeout to the SqlDataSource? If this is the case you can modify the ConnectionString from the project's Settings or delete the old one and create a new one with a custom Timeout. Check out the following screenshoot:

Regards,
Peter
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.

answered on 30 Apr 2010, 07:17 PM

You are talking about the Connect Timeout which can be set in the Connection String.

What is at issue here is the CommandTimeout which is set as a property of an individual .NET SqlCommand object. In an effort to solve the problem of my reports timing out after 30 seconds, I set the Connect Timeout in my Connection Strings to 600 seconds (10 min), and also provided implemented the IReportServiceClientFactory with the following code

    
                    public ReportServiceClient Create(Uri remoteAddress)  
        
                    {  
        
                        BasicHttpBinding binding = new BasicHttpBinding();  
        
                        //     
        
                        // Increase the max message size in order to avoid the dreaded message:     
        
                        // System.ServiceModel.CommunicationException : The maximum message size quota for incoming     
        
                        // messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize      
        
                        // property on the appropriate binding element.     
        
                        //     
        
                        binding.MaxReceivedMessageSize = Int32.MaxValue;  
        
                        //     
        
                        // Now set the timeout to an appropriate number of seconds.     
        
                        // TODO:  Handle the timeout exception gracefully if it does happen, i.e., set the timeout to 5 seconds.     
        
                        //     
        
                        binding.SendTimeout = new System.TimeSpan(0, 0, 600);  
        
                        binding.ReceiveTimeout = new System.TimeSpan(0, 0, 600);  
        
                        return new ReportServiceClient(binding, new EndpointAddress(remoteAddress));  
        
                    }

.
Neither of these have provided a solution.

Now I'm only guessing, but it appears the only timeout left which is set to 30 seconds by default is the SqlCommand.CommandTimeout. Many of my reports are timing out exactly at 30 seconds, and without the ability to set this value I cannot determine without a doubt that this is the problem. I assume that at some point in the ReportService code there is a SqlCommand object being created, or some similar object that contains this CommandTimeout property that can be set. If I am correct, and this is the valuie that I must change in order for my reports to run, the inability to change the value will render Telerik Reporting useless for our development needs. We are developing an application for the State of Nevada where we deal in database tables that have in excess of 1,000,000 records. I really have no desire to switch reporting products, and it will seriously affect our development schedule if we are forced to, however if I cannot resolve this issue quickly, I will have no choice.

Please do all you can to provide a way to set this value, or help me find the true cause of this timeout.

Thank you,
Steve

answered on 07 May 2010, 09:14 AM

Hi Steve,

We will try to include the requested settings in the following internal releases, but cannot point exact time frame.

However you do have the ability to use parameterized query/SP in Telerik Reporting without using the new SqlDataSource. The idea is to manually transfer the values of the report parameters to the SQL parameters in the NeedDataSource event.

For detailed steps please refer to the KB article Using data source with parameters in Telerik Reporting.

Kind regards,
Milen
the Telerik team

answered on 18 Feb 2015, 12:49 PM

timeout.png

telerik-prop.png

Hello, I
use telerik to generate report to my Silverlight app. I my report query return
6550 records, and telerik seem to be unable to support this amount of data as
result I have a timeout exception as you can see on image as attach (timeout.png).

The connection
string of my report has some configurations at web.config, in that manner:

<add name="SL_Relatorios.Properties.Settings.CmamConnectionString" connectionString="Data Source=localhost;Initial
Catalog=FCF;User ID=###;Password=###; providerName="System.Data.SqlClient" />

I tried to
define a new connection timeout and a max pool size:

<add name="SL_Relatorios.Properties.Settings.CmamConnectionString" connectionString="Data Source=localhost;Initial
Catalog=FCF;User ID=###;Password=###; Connection Timeout=10000" pooling='true'; Max Pool Size=8000; providerName="System.Data.SqlClient"
/>

I also tried to define a new command timeout at my report as you can see at the image telerik prop.png

But none of them work, what can I do to avoid the timeout?

Hope your
feedback .