Timeout Expired

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

Affected Software Version: N/A

Symptoms:

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 large table because the default timeout period for EQuIS Professional is 30 seconds.

Resolution/Workaround:

Users with SQL logins (Database-Level Security) can add a longer connection string timeout to the Connection String Options when logging in, such as:

Connection Timeout=600;

For EQuIS Enteprise users, administrators can increase the connection string timeout via the connection string for an Application Level Security (ALS) role.

Note: Non-admin Enterprise accounts cannot edit the connection timeout string for their ALS role. To request an extension of the connection timeout, contact EarthSoft Support (for EQuIS Online sites) or the database administrator.