This articles troubleshoots an error that occurs when running a report that takes longer than five minutes due to existing timeout settings.
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.
This is caused by the default timeout period for the application being set to 5 minutes.
To resolve this, there are two timeout settings that need to be updated.
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.
Private Host 5.x