Device showing up in Enabled interfaces but not licensed and last flow is never for all interfaces.
Article ID: 144870
Updated On:
Products
CA Network Flow Analysis (NetQos / NFA)
Issue/Introduction
Device is showing up in Enabled interfaces and showing as Enabled, but not Licensed and last flow is never for all interfaces.
This usually will indicate an issue with the Pump service on the console.
Checking the \CA\NFA\Reporter\logs\Pump*.log we saw the message below which can happen if the pump service fails to connect to mysql for some reason:
Pump log was showing:
10:14:35 -1 - Pump: Pump started.
10:14:54 -1 - OnStart() - :
Connection must be valid and open.
System.InvalidOperationException: Connection must be valid and open.
at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)
at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex)
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at NetQoS.Data.MySqlDataComponentBase.ExecuteScalar(MySqlConnection connection, String sql, DataParameter[] dataParameters)
at NetQoS.Data.MySqlDataComponentBase.ExecuteScalar(String sql, DataParameter[] dataParameters)
at NetQoS.ReporterAnalyzer.Data.ReporterAnalyzer.ParameterDescriptionsDc.GetValueByParameter(String parameter)
at NetQoS.ReporterAnalyzer.Business.SystemSettings.GetValueByName(SystemSettingName name)
at NetQoS.ReporterAnalyzer.PumpService.Pump.StartPump()
11:45:01 -1 - Pump: Pump started.
11:45:24 -1 - OnStart() - :
Connection must be valid and open.
System.InvalidOperationException: Connection must be valid and open.
at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)
at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex)
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at NetQoS.Data.MySqlDataComponentBase.ExecuteScalar(MySqlConnection connection, String sql, DataParameter[] dataParameters)
at NetQoS.Data.MySqlDataComponentBase.ExecuteScalar(String sql, DataParameter[] dataParameters)
at NetQoS.ReporterAnalyzer.Data.ReporterAnalyzer.ParameterDescriptionsDc.GetValueByParameter(String parameter)
at NetQoS.ReporterAnalyzer.Business.SystemSettings.GetValueByName(SystemSettingName name)
at NetQoS.ReporterAnalyzer.PumpService.Pump.StartPump()
This usually will indicate an issue with the Pump service on the console.
Checking the \CA\NFA\Reporter\logs\Pump*.log we saw the message below which can happen if the pump service fails to connect to mysql for some reason:
Pump log was showing:
10:14:35 -1 - Pump: Pump started.
10:14:54 -1 - OnStart() - :
Connection must be valid and open.
System.InvalidOperationException: Connection must be valid and open.
at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)
at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex)
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at NetQoS.Data.MySqlDataComponentBase.ExecuteScalar(MySqlConnection connection, String sql, DataParameter[] dataParameters)
at NetQoS.Data.MySqlDataComponentBase.ExecuteScalar(String sql, DataParameter[] dataParameters)
at NetQoS.ReporterAnalyzer.Data.ReporterAnalyzer.ParameterDescriptionsDc.GetValueByParameter(String parameter)
at NetQoS.ReporterAnalyzer.Business.SystemSettings.GetValueByName(SystemSettingName name)
at NetQoS.ReporterAnalyzer.PumpService.Pump.StartPump()
11:45:01 -1 - Pump: Pump started.
11:45:24 -1 - OnStart() - :
Connection must be valid and open.
System.InvalidOperationException: Connection must be valid and open.
at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)
at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex)
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at NetQoS.Data.MySqlDataComponentBase.ExecuteScalar(MySqlConnection connection, String sql, DataParameter[] dataParameters)
at NetQoS.Data.MySqlDataComponentBase.ExecuteScalar(String sql, DataParameter[] dataParameters)
at NetQoS.ReporterAnalyzer.Data.ReporterAnalyzer.ParameterDescriptionsDc.GetValueByParameter(String parameter)
at NetQoS.ReporterAnalyzer.Business.SystemSettings.GetValueByName(SystemSettingName name)
at NetQoS.ReporterAnalyzer.PumpService.Pump.StartPump()
Environment
Release : 10.0
Component : NQRPTA - REPORTERANALYZER
Resolution
In this case it looked like mysql had some memory issues around the time of the error but recovered, however the pump service stopped logging anything after that point in time.
To resolve this"
1. Being that the pump was not processing anything for a couple of days, the \CA\NFA\Netflow\datafiles\NFMInput directory on the Harvesters may have a lot of files, if so delete them and allow the pump to just process the new files.
2. Restart the Netqos ReporterAnalyzer Pump Service, then checking the \CA\NFA\Reporter\logs\Pump*.log to see if there are any errors.
3. If there are no errors it takes about 15 minutes to license an interface. It will do it at 1PM then 1:15 then 1:30 etc.
4. If there are no new errors check the Enable interface page in 15 minutes to see if your interfaces are not getting licensed and have last flow times.
5. If there are any errors or you are not seeing the last flows times starting to update and the interfaces are still not getting licensed, please check the pump log for any errors or exceptions or open a support case and attach the Pump*.log to the issue.
To resolve this"
1. Being that the pump was not processing anything for a couple of days, the \CA\NFA\Netflow\datafiles\NFMInput directory on the Harvesters may have a lot of files, if so delete them and allow the pump to just process the new files.
2. Restart the Netqos ReporterAnalyzer Pump Service, then checking the \CA\NFA\Reporter\logs\Pump*.log to see if there are any errors.
3. If there are no errors it takes about 15 minutes to license an interface. It will do it at 1PM then 1:15 then 1:30 etc.
4. If there are no new errors check the Enable interface page in 15 minutes to see if your interfaces are not getting licensed and have last flow times.
5. If there are any errors or you are not seeing the last flows times starting to update and the interfaces are still not getting licensed, please check the pump log for any errors or exceptions or open a support case and attach the Pump*.log to the issue.
Additional Information
Feedback
Yes
No
Powered by
