I am seeing errors in my ManagerService*.log trying to deploy traps to Harvester 0.0.0.0 and my Trap Definitions are not updating on my Harvesters.

Document ID : KB000073527
Last Modified Date : 15/03/2018
Show Technical Document Details
Issue:
Manager Service log is throwing errors like below:
Query: 
   harvester@0.0.0.0:3308
Connection must be valid and open.
   delete from trap_definitions                             where lastupdatetime != 1521086512
   (0.0000 ms)
   at NetQoS.Data.MySqlDataComponentBase.ExecuteNonQuery(MySqlConnection connection, String sql, Int32 commandTimeout, IFileLog fileLog, DataParameter[] dataParameters)
   at NetQoS.Data.MySqlDataComponentBase.ExecuteNonQuery(String sql, DataParameter[] dataParameters)
   at NetQoS.ReporterAnalyzer.Data.Harvester.TrapDefinitionsDc.DeleteTrapsNotTimestamp(DateTime timestamp)
   at NetQoS.ReporterAnalyzer.Business.TrapDefinition.Deploy(IFileLog filelog)
   at NetQoS.ReporterAnalyzer.Business.SystemMaintenance.DeployConfiguration()
   at NetQoS.ReporterAnalyzer.Business.SystemMaintenance.SyncConfiguration()
   at NetQoS.ReporterAnalyzer.Business.SystemMaintenance.MaintenanceTask.Run()
   at NetQoS.ReporterAnalyzer.Business.SystemMaintenance.Run()
   at NetQoS.ReporterAnalyzer.Business.SystemMaintenanceThread.ThreadHandler()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()
Environment:
NFA All Versions
Cause:
After deleting a harvester, there may be deleted interfaces that are still in the reporter.agent_definitions_deleted page that are pointing to a harversterID that doesn't exist.
Resolution:
1. RDP to the NFA console server and open a command prompt.

2. Run the following command:
mysql -P3308 -D reporter -t -e "delete from agent_definitions_deleted where harvesteraddress=0;"

3. Recycle the "Netqos ReporterAnalyzer Manager Service" on the NFA Console server.

4. Check that the error is no longer being logged in the \Reporter\logs\ManagerService*.log file.