After specifying the Connection Timeout in Connection String, but still got the error Execution Timeout Expired

1 Answer 144 Views
DataSource SQL Report Designer (standalone)
Dali
Top achievements
Rank 1
Dali asked on 05 Sep 2023, 02:21 PM

Hi,

I have built a report on the Telerik Standalone Report Designer, it calls a stored procedure and the SP will complete by around 5 minutes 33 seconds.  I have specified the Connection Timeout to 600 seconds in the Connection String (see attached), but when I preview the report on Telerik Report Designer and Telerik Report Sever, I still got the error message "Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.".

How could I resolve this problem?

Many thanks.

Best regards,

Jocelyn

1 Answer, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 06 Sep 2023, 01:17 PM

Hi Kyriacos,

We are discussing the case in a support ticket but I want to also share my replies with the public so that it may help other users in the future. Thus, I will copy my answer below:

Please have a look at the Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. - Telerik Reporting KB article and test the 1st and 3rd solutions.

For the 3rd approach, in the case of the Report Server, his Web.config file can be found at the following path(assuming default install dir):

C:\Program Files (x86)\Progress\Telerik Report Server\Telerik.ReportServer.Web

I hope this will help with the problem.

Regards,
Dimitar
Progress Telerik

Stay tuned by visiting our roadmap and feedback portal pages, enjoy a smooth take-off with our Getting Started resources, or visit the free self-paced technical training at https://learn.telerik.com/.
Tags
DataSource SQL Report Designer (standalone)
Asked by
Dali
Top achievements
Rank 1
Answers by
Dimitar
Telerik team
Share this question
or