Symptom:
When performing tasks involving a large amount of data in Ultimate Survey Enterprise survey software via your web browser, an error is thrown that looks similar to the following:
Timeout expired
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Timeout expired
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OleDbException (0x80040e31): Timeout expired]
System.Data.OleDb.OleDbDataReader.NextResults(IMultipleResults imultipleResults, OleDbConnection connection, OleDbCommand command) +293
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +567
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +66
Prezza.Data.DbWrapper.ExecuteNonQuery(CommandType commandType, OleDbConnection connection, String commandText, Object[] commandParameters) +317
Prezza.Data.DbWrapper.ExecuteNonQuery(String storedProcedureName, Object[] commandParameters) +87
Prezza.Forms.DAL.FormDAL.DeleteForm(Int32 formID) +63
Prezza.Forms.Form.DeleteForm(Int32 formID) +5
UltimateSurvey.ManageSurveys.availSurveys_DeleteCommand(Object sender, DataGridCommandEventArgs e) +77
System.Web.UI.WebControls.DataGrid.OnDeleteCommand(DataGridCommandEventArgs e) +109
System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) +589
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26
System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) +106
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26
System.Web.UI.WebControls.ImageButton.OnCommand(CommandEventArgs e) +120
System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +125
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
Cause:
The SQL server is set not to allow connections for as long of a time as Ultimate Survey Enterprise survey software needs to perform the task.
Resolution:
Extend the Connection Timeout on the SQL server.
1. Open SQL Server Enterprise Manager and find the server that contains your Ultimate Survey Enterprise survey software database.
2. Right click on the server name.
3. Select properties.
4. Choose the Connections tab.
5. Increase the query timeout value. (The value is in seconds. Set it to 0 for unlimited time)
6. Click OK.