Devices synchronized from NFA are not present in CA Performance Management

Document ID : KB000100663
Last Modified Date : 14/06/2018
Show Technical Document Details
Issue:
Devices from the NFA Data Source are seen in the Data Aggregator Inventory views.

The same devices are not present in the CA Performance Center CA Performance Management Global Inventory Views.

Some of the same devices are also not being set with the correct Device Type (changing from server default to custom router type) per DeviceTypes.xml file.
Environment:
All supported CA Performance Management releases
Cause:
Duplicate devices are being synchronized to the CA Performance Center Inventory from the NFA Data Source.

The duplication is visible in the MySql netqosportal database on the CA Performance Center server.

A sample, with generic names and IP addresses inserted to show the issue is as follows. Things to note in the output:
  • sourceid is the ID for the Data Source.
    • sourceid 8 is the NFA Data Source
    • sourceid3 is the Data Aggregator Data Source
  • localid is the ID the element is known by in the source database. For NFA DS ID items its from the database on NFA, for DA DS items its from the DR DB.
  • itemid is the shared item the multiple items are consolidated under and are what the CAPC Inventory uses to identify the device
Note in the sample we have two duplicate sets of devices with shared names and IPs coming in from the NFA DS. At the same time each has a unique localid value indicating it is a unique element entry in the NFA database.

The same query can be run in the MySql prompt on the CA Performance Center server. Simple replace the 'CAServer-141' value between quotes with an element name part that matches the device under investigation.

Alternatives using a known localid or itemid might be:
  • select sourceid,itemid,localid,itemname,lifecyclestate,v6_ntoa(address) from dst_device where localid=1234\G;
  • select sourceid,itemid,localid,itemname,lifecyclestate,v6_ntoa(address) from dst_device where itemid=1234\G;
Where 1234 is the localid or itemid of the device element under investigation.

mysql> select sourceid,itemid,localid,itemname,lifecyclestate,v6_ntoa(address) from dst_device where itemname like 'CAServer-141%'\G;
*************************** 1. row ***************************
        sourceid: 8
          itemid: 3275049
         localid: 173058306
        itemname: CAServer-141-123456789
  lifecyclestate: ACTIVE
v6_ntoa(address): 1.1.1.2
*************************** 2. row ***************************
        sourceid: 3
          itemid: 3275049
         localid: 4212027
        itemname: CAServer-141-123456789
  lifecyclestate: ACTIVE
v6_ntoa(address): 1.1.1.2
*************************** 3. row ***************************
        sourceid: 8
          itemid: 3275049
         localid: 1501196
        itemname: CAServer-141-123456789
  lifecyclestate: ACTIVE
v6_ntoa(address): 1.1.1.2
*************************** 4. row ***************************
        sourceid: 8
          itemid: 3275050
         localid: 173058307
        itemname: CAServer-141-ethe-123456789
  lifecyclestate: ACTIVE
v6_ntoa(address): 1.1.1.3
*************************** 5. row ***************************
        sourceid: 3
          itemid: 3275050
         localid: 4212012
        itemname: CAServer-141-ethe-123456789
  lifecyclestate: ACTIVE
v6_ntoa(address): 1.1.1.3
*************************** 6. row ***************************
        sourceid: 8
          itemid: 3275050
         localid: 1501197
        itemname: CAServer-141-ethe-123456789
  lifecyclestate: ACTIVE
v6_ntoa(address): 1.1.1.3
Resolution:
Clean up the duplicate device elements in the NFA system and allow synchronization to complete between Data Sources in the CA Performance Management system.

If normal synchronization update cycles don't resolve the problem, some instances may require a full synchronization for the problem to resolve in CA Performance Center. In these situations be sure to check the box to request a Full Synchronization when requesting an on-demand synchronization of the NFA Data Source in the CA Performance Center Manage Data Sources page.