Report Results Timeout Error

<< Click to Display Table of Contents >>

Navigation:  Professional > Troubleshooting > Reporting Errors >

Report Results Timeout Error

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()

 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:


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 (for EQuIS Online sites) or your database administrator to request an extension of the connection timeout for the ALS role.