How to delete a harvester that is no longer running

Products

• Network Flow Analysis

Issue/Introduction

How to delete a Harvester which remains present under NetOps Portal / System Health

You may see an error like the below error when trying to delete a Harvester that no longer exists.

- Object reference not set to an instance of an object. at NetQoS.Common.EnumUtility.GetDescriptionByDescriptionContext(Enum value, String descriptionContext) at NetQoS.ReporterAnalyzer.Business.AgentPhysical.InitializeFromDataRow(DataRow row) at NetQoS.Business.DatabaseEntity.GetDatabaseEntityArrayFromDataTable[T](DataTable table) at NetQoS.ReporterAnalyzer.Business.AgentPhysical.GetByInterfaceIds(UInt32[] ids) at NetQoS.ReporterAnalyzer.Business.AgentPhysical.DeleteByInterfaceIds(UInt32[] ids) at NetQoS.ReporterAnalyzer.Business.Interface.DeleteByIds(UInt32[] interfaceIds) at NetQoS.ReporterAnalyzer.Business.Interface.DeleteByRouterIds(UInt32[] routerIds) at NetQoS.ReporterAnalyzer.Business.Router.DeleteByIds(UInt32[] routerIds) at NetQoS.ReporterAnalyzer.Business.Harvester.Delete(UInt32[] ids) at NetQoS.ReporterAnalyzer.WebService.HarvesterWS.DeleteHarvesterData(UInt32 harvesterID) Error when trying to delete interfaces: - Connection must be valid and open. at MySql.Data.MySqlClient.MySqlCommand.CheckState() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at NetQoS.Data.MySqlDataComponentBase.ExecuteNonQuery(MySqlConnection connection, String sql, DataParameter[] dataParameters) at NetQoS.Data.MySqlDataComponentBase.ExecuteNonQuery(String sql) at NetQoS.ReporterAnalyzer.Data.Archive.ArchiveDc.DeleteByRouterAndPersistentId(String sourceTable, UInt32 router, UInt32 persistentId) at NetQoS.ReporterAnalyzer.Business.Agent.DeleteById(UInt32[] ids) at NetQoS.ReporterAnalyzer.Business.Router.DeleteLicensedOnlyByIds(UInt32[] routerIds) at NetQoS.ReporterAnalyzer.WebService.RouterInterfaceWS.DeleteRouterInterfaces(String routerIds, String interfaceIds)

Error when trying to delete interfaces from a harvester that no longer exists:

- Connection must be valid and open.

at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at NetQoS.Data.MySqlDataComponentBase.ExecuteNonQuery(MySqlConnection connection, String sql, DataParameter[] dataParameters)
at NetQoS.Data.MySqlDataComponentBase.ExecuteNonQuery(String sql)
at NetQoS.ReporterAnalyzer.Data.Archive.ArchiveDc.DeleteByRouterAndPersistentId(String sourceTable, UInt32 router, UInt32 persistentId)
at NetQoS.ReporterAnalyzer.Business.Agent.DeleteById(UInt32[] ids)
at NetQoS.ReporterAnalyzer.Business.Router.DeleteLicensedOnlyByIds(UInt32[] routerIds)
at NetQoS.ReporterAnalyzer.WebService.RouterInterfaceWS.DeleteRouterInterfaces(String routerIds, String interfaceIds)

Environment

Network Flow Analysis all versions

Cause

The Console cannot communicate with the old Harvester to delete or remains present under NetOps Portal / System Health

Resolution

How to remove the harvester manually from the MySQL Reporter database:

1. RDP to the NFA Console.
2. Backup the NFA Reporter Database as described here:
3. mysqldump -uroot -proot@123 reporter > C:\reporter_backup.sql
4. Then, open a CMD prompt and type in your IP address of the Harvester you want to remove where you see 'x.x.x.x' :

1. 1. mysql reporter -unetqos -pnetqos
   2. delete from routers where harvesterID = (select harvesterID from harvesters where Address = 'x.x.x.x');
   3. delete from harvesters where address='x.x.x.x';
   4. delete from agent_definitions_deleted where harvesteraddress='x.x.x.x';
   5. delete from cpuutilization where Address = 'x.x.x.x';
   6. delete from diskutilization where Address = 'x.x.x.x';
   7. delete from harvester_status where Address = 'x.x.x.x';
   8. create table temprouters (  ID int(10) unsigned );
   9. ALTER TABLE temprouters ADD PRIMARY KEY (ID);
   10. Insert into temprouters (ID) select id from routers;
   11. delete from interfaces where routerid not in (select id from temprouters);
   12. drop table temprouters;
   13. delete from agent_definitions where interfaceid not in (select id from interfaces);

Once complete, you can restart the CA MySql Service on the NFA Console Server.