RD PH Error: "Execution Timeout Expired."

Summary

This articles details the symptoms and resolution related to a timeout error when running a report.

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.

Cause

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. 

1. Go to SQL Server Management Studio where Solver_Repository database is located.
2. Open a new query pointing to Solver_Repository database
3. 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]);
     

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

Properties

Applies to:

• Private Host 5.x