Report Results Timeout Error

<< Click to Display Table of Contents >>

EQuIS 7  >>  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 however be customized by the user to increase the timeout expiration period. The connection timeout string can be added to the advanced tab of the connection window. (there is a tool tip when you hover the mouse over the connection strings box).

 

Resolution/Workaround:

 

1.Open EQuIS.

2.Right-click on the server you are connecting to.

3.Select View/Edit Connection.

4.Go to the Advanced tab.

5.Hover your mouse over the "Connection Strings Options" text box.

6.To change the timeout, in the text box write "Connection Timeout=[your time ie. 600];". Remember to add the semicolon at the end.

7.Test your connection to make sure it worked.

8.Connect.

 

Note: If the database which is presenting the timeout error above is hosted by EarthSoft, the connection timeout string will not be available to edit. Contact support@earthsoft.com to request an extension of the connection timeout.