0 Replies Latest reply on Nov 5, 2008 5:40 AM by sstarling

    Query Timeout with Custom Relative

    sstarling

      We are trying to utilize a custom query within one of our Netflow interfaces so that we can look at data from last month. Each time I try to perform a Custom Relative query for more than a couple days, the website times out with the below error.  This error was with a Custom Relative of 7 Days.  It is critical that we be able to obtain historical information from NetFlow:

      Orion Website Error

      An error has occurred with the Orion website.

      Additional Information

      System.Exception: Unable to create TopApplicationsReport. ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
         at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
         at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
         at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
         at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
         at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
         at System.Data.SqlClient.SqlDataReader.get_MetaData()
         at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
         at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
         at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
         at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
         at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
         at System.Data.SqlClient.SqlCommand.ExecuteReader()
         at SolarWinds.Netflow.Reporting.TopApplicationsReport..ctor(Int32 rowCount, FilterCollection filters)
         --- End of inner exception stack trace ---
         at SolarWinds.Netflow.Reporting.TopApplicationsReport..ctor(Int32 rowCount, FilterCollection filters)
         at SolarWinds.Netflow.Web.NetflowObject.GetTopApplicationsReport(Int32 rowCount)
         at Orion_TrafficAnalysis_Utils_TopApplicationsReport.DataBind()
         at System.Web.UI.Control.DataBindChildren()
         at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
         at System.Web.UI.Control.DataBind()
         at ASP.TopXXApplications.OnInit(EventArgs e)
         at System.Web.UI.Control.InitRecursive(Control namingContainer)
         at System.Web.UI.Control.AddedControl(Control control, Int32 index)
         at System.Web.UI.ControlCollection.Add(Control child)
         at Orion_ResourceContainer.ResourcePlaceHolder_DataBind(Object sender, EventArgs e)
         at System.Web.UI.Control.OnDataBinding(EventArgs e)
         at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
         at System.Web.UI.Control.DataBind()
         at System.Web.UI.Control.DataBindChildren()
         at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
         at System.Web.UI.Control.DataBind()
         at System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem)
         at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource)
         at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e)
         at System.Web.UI.WebControls.Repeater.DataBind()
         at System.Web.UI.Control.DataBindChildren()
         at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
         at System.Web.UI.Control.DataBind()
         at System.Web.UI.Control.DataBindChildren()
         at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
         at System.Web.UI.Control.DataBind()
         at Orion_ResourceContainer.DataBind()
         at Orion_Netflow_InterfaceDetails.OnInit(EventArgs e)
         at System.Web.UI.Control.InitRecursive(Control namingContainer)
         at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)