7 Replies Latest reply on Sep 26, 2007 5:15 PM by timf

    Netflow 2.2 web error on nodes without netflow data

    timf

       I am still having issues with nodes that do not have netflow data to them.  If i click on a node without any netflow data I get:

       System.Exception: Unable to create TopApplicationsReport. ---> System.Data.SqlClient.SqlException: Invalid object name NetflowDetail_5119'.

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

       

       When I click on a router that does have netflow data, the page and info. display properly.  I know each netflow enabled node has a corresponding table in the database.  But why are ALL of my nodes attempting to call a table even when it doesn't even exist?  Even clicking on servers comes up the error message above.
       

        • Re: Netflow 2.2 web error on nodes without netflow data
          aLTeReGo

          Hmm... Agreed.  Here's mine just for good measure..

           

          An error has occurred with the Orion website.

          Additional Information

          System.Exception: Unable to create TopApplicationsReport. ---> System.Data.SqlClient.SqlException: Invalid object name 'NetflowDetail_163'.
             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_NetPerfMon_NodeDetails.OnInit(EventArgs e)
             at System.Web.UI.Control.InitRecursive(Control namingContainer)
             at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
            • Re: Netflow 2.2 web error on nodes without netflow data
              aLTeReGo

              This still seems to be the case after installing the NTA hotfix released today. Here's another screen-scrape post upgrade just in case it's helpful

               

              Orion Website Error

              An error has occurred with the Orion website.

              Additional Information

              System.Exception: Unable to create TopApplicationsReport. ---> System.Data.SqlClient.SqlException: Invalid object name 'NetflowDetail_223'.
                 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_NetPerfMon_NodeDetails.OnInit(EventArgs e)
                 at System.Web.UI.Control.InitRecursive(Control namingContainer)
                 at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)