Results 1 to 1 of 1

Thread: SQlserver timeout

  1. #1
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Rep Power

    SQlserver timeout

    SQlserver timeout DBA Tip

    Here is a useful SQLserver DBA artcile about the timeout parameter in SQLserver

    Extending your SQL server timeout setting

    Article ID:1041Posted Date:5/5/2005 1:28:38 PMProducts:Ultimate Survey - Enterprise .NET Edition
    Ultimate Survey - Enterprise .NET Edition with Dev KitUpdated Date:5/5/2005 1:28:38 PM

    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(IMul tipleResults imultipleResults, OleDbConnection connection, OleDbCommand command) +293
    System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(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_DeleteCo mmand(Object sender, DataGridCommandEventArgs e) +77
    System.Web.UI.WebControls.DataGrid.OnDeleteCommand (DataGridCommandEventArgs e) +109
    System.Web.UI.WebControls.DataGrid.OnBubbleEvent(O bject source, EventArgs e) +589
    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26
    System.Web.UI.WebControls.DataGridItem.OnBubbleEve nt(Object source, EventArgs e) +106
    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26
    System.Web.UI.WebControls.ImageButton.OnCommand(Co mmandEventArgs e) +120
    System.Web.UI.WebControls.ImageButton.System.Web.U I.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +125
    System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18
    System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection 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

    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.

    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.
    Last edited by Admin_attu; 10-05-2006 at 09:57 AM.
    To Find Out more About Attunity Technology:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts