RD PH Error: Execution Timeout Expired – Solver Support

Summary:

This articles troubleshoots an error that occurs when running a report that takes longer than five minutes due to existing timeout settings.

Article sections

Symptoms
Cause
Resolution
Properties

Symptoms:

When running a report in Report Designer, users receive the following error message.

System.Exception: There was a problem executing the report. ---> System.Exception: System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out.

Causes:

This is caused by the default timeout period for the application being set to 5 minutes.

Resolution:

To resolve this, there are two timeout settings that need to be updated.

ExecuteReportService.TimeoutInSeconds
MDL.RqlTimeout

After following the below steps, you must also restart the Solver Report Rendering Service on the services server. Please make sure you have access to this server to perform this action after executing the below SQL.

Go to SQL Server Management Studio where Solver_Repository database is located.
Open a new query pointing to Solver_Repository database

Execute the following query to update (or add) a timeout setting. The below query has been set to timeout in 10 min, from a default of 5min.

Declare @RQLTimeoutValue nvarchar(10) ='600' -- value in seconds; default 300
		,@ReportServiceTimeoutValue nvarchar(10) = '900' -- value in seconds; default 300

MERGE into dbo.MasterSettings t
USING (
		Select 'ExecuteReportService.TimeoutInSeconds' as [Key]
			,@RQLTimeoutValue as [Value]
			,'System.Int32' as [Type]
			,0 as [IsSystemSetting]
			,'00000000-0000-0000-0000-000000000000' as UserId
		union 
		Select 'MDL.RqlTimeout' as [Key]
			,@ReportServiceTimeoutValue as [Value]
			,'System.Int32' as [Type]
			,0 as [IsSystemSetting]
			,'00000000-0000-0000-0000-000000000000' as UserId
		) s
On t.[key] = s.[key] and t.[Userid] = s.[userid]
When Matched then update set t.[Value] = s.[Value]
When not matched then insert ([Key], [Value],[Type],[IsSystemSetting],[UserId])
	Values(s.[Key],s.[Value],s.[Type],s.[IsSystemSetting],s.[UserId]);

After successful execution of the query, restart the report rendering service.

Properties

Private Host 5.x

Attachments