Report Results Timeout Error

<< Click to Display Table of Contents >>

Navigation:  Professional > Troubleshooting >

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.