Affected Software/Reports/DLL(s): N/A
Affected Software Version: N/A
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(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.
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:
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 firstname.lastname@example.org (for EQuIS Online sites) or your database administrator to request an extension of the connection timeout for the ALS role.
Copyright © 2021 EarthSoft, Inc • Modified: 14 May 2020