Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Netflow Traffic Analyzer (NTA) > Unable to add Netflow sources

Unable to add Netflow sources

Updated March 10, 2017

Overview

 

When trying to add sources by using the link in the Netflow Top 25 Events resource or from Manage Nodes, an error is generated and the sources cannot be added:

 

http://Solarwinds_IP_Address/Orion/T...mmaryView.aspx
Message: Error occured in transaction.
ErrorSite: NetflowWeb.AllNetflowSourcesEditDAL.StoreData
ErrorType: System.Exception

 

You may also find the below SQL timeout error occurring in the NTA.BusinessLayer.log before the error occurs:

XXX-XX-XX XX:XX:XX,XXX [74] (5582) WARN  SolarWinds.Netflow.DAL.AllNetflowSourcesEditDAL - (null)  System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

   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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

   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(CommandBehavior behavior)

   at SolarWinds.Orion.Common.SqlHelper.ExecuteReader(SqlCommand command, SqlConnection connection, SqlTransaction transaction, CommandBehavior behavior)

   at SolarWinds.Netflow.DAL.AllNetflowSourcesEditDAL.StoreData(ConfigurationType type, ArrayList checked_Vendors, ArrayList unchecked_Vendors, ArrayList checked_Nodes, ArrayList unchecked_Nodes, ArrayList checked_Interfaces, ArrayList unchecked_Interfaces, List`1 addedInterfaceID)

ClientConnectionId:87cd9cf4-6710-48ef-9543-35b9fcb765fb

Error Number:-2,State:0,Class:11

 

XXX-XX-XX XX:XX:XX,XXX [74] (5582) ERROR ASP.global_asax - (null)  Application_Error(51559972eb9d41249ad6d9277a2e7571)

System.Exception: Error occured in transaction.

   at SolarWinds.Netflow.DAL.AllNetflowSourcesEditDAL.StoreData(ConfigurationType type, ArrayList checked_Vendors, ArrayList unchecked_Vendors, ArrayList checked_Nodes, ArrayList unchecked_Nodes, ArrayList checked_Interfaces, ArrayList unchecked_Interfaces, List`1 addedInterfaceID)

   at AllNetflowSourcesEdit.ParseFields()

   at AllNetflowSourcesEdit.Submit_Click(Object sender, EventArgs e)

   at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)

   at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)

   at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

Environment

NTA 4.2

Resolution

1.  Please run a repair of NTA 4.2 via the instructions below if the below (step 2, SQL timeout) is not applicable:

https://support.solarwinds.com/Success_Center/Netflow_Traffic_Analyzer_(NTA)/Repair_NTA_in_Control_Panel

2.  This can occur if there are too many Netflow sources, specifically if there is a SQL timeout occurring just before the error page is displayed.  This is seen in the NTA.BusinessLayer.log as noted in the above description.

 

If this is applicable, the next recommendation is to remove all interfaces in the Netflow Sources that are not collecting any data in order to bring down the size of the query.

 

Since this is not possible via the Orion Web Console due to the error itself, please first backup the database or at least the dbo.NetflowSources table and run the following query via the database manager:

 

https://support.solarwinds.com/Succe...winds_database

 

Success_Center/Netflow_Traffic_Analyzer_(NTA)/Unable_to_add_Netflow_sourceshttps://support.solarwinds.com/Success_Center/Network_Performance_Monitor_(NPM)/Start_and_stop_Orion_services

 

SELECT * INTO NetflowSources_Backup

FROM NetflowSources

 

Please then stop the Netflow service via the Orion Service Manager and run the following database query via the Database Manager to delete sources with no data collected:

 

DELETE FROM NetFlowSources

Where LastTime IS NULL

 

Please then restart the Netflow service via the Orion Service Manager as described in the above article.

 

 

Last modified
16:01, 10 Oct 2017

Tags

Classifications

Public