Device not showing up in NFA after delete

Document ID : KB000112646
Last Modified Date : 31/08/2018
Show Technical Document Details
Issue:
there were interfaces not matching customer details regarding numbering and naming. So we suggested, that this device can be deleted from MySQL and with next poll it will be added back. Unfortunately it is not added back and not visible in NFA and in MySQL
reporter base But  we see incoming flow in Wireshark
Environment:
Win2012
NFA 9.3.3
Cause:
Delete from the NFA console was not trigerring delete in the harvester base
Resolution:
delete the device from the harvester.routers + interfaces tables using :
mysql harvester
delete from routers where RouterID=xxxxxx;
delete from interfaces where router=xxxxxxxxx;
quit;

and recycle the harvester service
device must appear in the NFA console after 10 minutes