NFA Auto Enable disables on its own

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

While using Network Flow Analysis you may notice that the Auto Enable option in Application Settings becomes disabled. This results in unexpected behavior as new devices which come in are not enabled automatically and there could be a loss of expected data. This issue appears to be rare. 

Environment

Component : NQRPTA - REPORTERANALYZER

Cause

If this problem occurs and you happen to catch the error which allowed it to occur in the Pump log before the log was pruned, it looks like this:

11:32:15 5 - SourceManager: Pull ManagementServer x.x.x.x:8080 Channel 'All Files'
11:32:17 4 - DataConverter - Failed to create agent for y.y.y.y::1 :
Duplicate entry '1020091' for key 'InterfaceId'
MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry '1020091' for key 'InterfaceId'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   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.AgentPhysicalDc.insert(UInt32 interfaceId, String name, String description, String ifType, Boolean linked, Nullable`1 inSpeed, Nullable`1 outSpeed, Nullable`1 domainId)
   at NetQoS.ReporterAnalyzer.Business.AgentPhysical.Persist()
   at NetQoS.ReporterAnalyzer.Business.Pump.DataConverter.CreatePhysicalAgent(Interface snmpInterface, IPAddress routerAddress, IPAddress harvesterAddress, UInt32 persisentIfIndex)
   at NetQoS.ReporterAnalyzer.Business.Pump.DataConverter.CreateAgent(Interface snmpInterface, IPAddress routerAddress, IPAddress harvesterAddress, UInt32 persistentIfIndex)
11:32:17 4 - DataConverter: Due to errors, pump will not attempt to create any more agents until 11:47 AM
11:32:17 4 - DataConverter: Due to errors, disabling all existing interfaces that don't have agents.

There appears to be a issue create interface agents (licensing an interface). When the exception occurs, it turns off Auto Enable to prevent the exception from happening again. This is clearly a defect in the Pump code. 

Resolution

Opened Defect DE525312 and Development has reproduced the issue. They are working towards what the root cause it and a fix. 

This knowledge document will be updated once there is a root cause and ETA for a fix.