Device showing up in Enabled interfaces but not licensed and last flow is never for all interfaces.

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

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.

Additional Information

See also this kb for another common reason for the last flow not updating.