Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Netflow 2.2 web error on nodes without netflow data

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.

Find more posts tagged with

Accepted answers

All comments

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)

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)

timf

I just applied the patch to 2.2 as well. I am still having the same issue.

FormerMember

Thanks. Got it. We're looking into why this issue persists.