Report Results Timeout Error

Affected Software/Reports/DLL(s): N/A

Affected Software Version: N/A

Symptoms:

An error has occurred in EarthSoft.Common, Version=x.x.x.x:

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

at EarthSoft.Common.Data.SqlConnection.ExecuteFunction(String functionName, IDataParameterCollection parameters)

at EarthSoft.Common.Reports.FunctionReport.Execute()

at EarthSoft.Common.Reports.FunctionReport.Execute(Int32 facilityId)

at EarthSoft.Reports.ReportGrid.backgroundWorker_DoWork(Object sender, DoWorkEventArgs e)

Cause/Details: This error generally occurs when running a large query or opening a table with a large amount of records, because the default timeout period for EQuIS Professional is 30 seconds. This can be customized by users using Database-Level Security (logging in with the SQL Server drop-down under Server Name) to increase the timeout expiration period.

Resolution/Workaround:

Add a longer connection string timeout such as the following to the Connection String Options box on the Connect tab of the EQuIS Professional Backstage:

Connection Timeout=600;

Note: If the user is using an Enterprise account to login (which uses an Application Level Security [ALS] role) for the database presenting the timeout error above, the connection timeout string will not be available to edit. Contact support@earthsoft.com (for EQuIS Online sites) or your database administrator to request an extension of the connection timeout for the ALS role.