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

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

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