Unable to delete/remove Orphaned Devices from NFA/CAPC.

Document ID : KB000005245
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Orphaned devices that show up in CAPM and were tracked back to the NFA.

Checked the reporter.routers table on the NFA Console and empty sets are being returned for my queries. 

Environment:
RA/NFA
Cause:

Devices were deleted from NFA but are still showing up in CAPC. 

They are orphaned devices that they are unable to delete from CAPC.

Resolution:

On the Harvester:

Verified that none of the devices existed in any of the harvester.interfaces and harvester.routers tables.

 

On the NFA console:

Truncated the "reporter.agent_definitions_deleted" table.

Then restarted the services.

Ran a full sync from CAPC and the devices were gone. 

Additional Information:

Case #00650731