NFA Data Sources Synchronization fails in Dx NetOps Performance Management

Products

• CA Infrastructure Management
• CA Performance Management

Issue/Introduction

A CA Network Flow Analysis (NFA) Data Source was added to Dx NetOps Performance Management. In the Dx NetOps Performance Management Dx NetOps Portal web UI it shows as Red with Synchronization failures.

Environment

All supported Dx NetOps Performance Management releases

Cause

The following error is observed in the (default installation path) /opt/CA/PerformanceCenter/DM/logs/DMService.log.

ERROR | pool-2-thread-10 | AAAA-MM-DD HH:MM:SS,354 | com.ca.im.portal.dm.productsync.DataSourcePoller 
Data source Network Flow Analysis@<NFA_HOST> encountered an error while processing a sync request. The problem is in the data source, not Dx NetOps Portal. Check the logs for the data source to determine the cause of the problem. The following stack trace shows the context of the sync request: 
java.lang.IllegalArgumentException: Data source 4 is missing 1 binding group references in the bind_users table 

This is due to the PermissionItemID value from NFA not being synchronized to Dx NetOps Portal for one or more users in the bind_users table.

In this case a default NFA system user, nquser, was missing this value. Other users had it set properly. The users with the problem were identified by running this query in the Dx NetOps Portal  netqosportal MySql DB:
 

select * from bind_users\G;

Resolution

In the MySql prompt on the NFA server, in the reporter database run the following. Replace Name_With_PermissionItemID_NULL_in_bind_users value with the user name with a null PermissionItemID value in the Dx NetOps Portal bind_users table.

select * from user_definitions where name = 'Name_With_PermissionItemID_NULL_in_bind_users'\G; 

Note the PermissionItemID value the affected users should be set with.

In the MySql prompt on the Dx NetOps Portal, in the netqosportal database run the following. Run it for each user affect. Replace <ID> with the PermissionItemID value found in the NFA user_definitions table output. Replace <userName> with the affected user name.

update bind_users SET PermissionItemID = <ID> where UserName = '<userName>'; 

After this the NFA Data Source synchronized successfully.