An NFA server Data Source was deleted from Performance Management. It was added back again but now shows a synchronization failure. It shows a Bind Failure error for Status in the Manage Data Sources page.
It also reports the problem is in the data source not Performance Management.
This error is present in the DMService.log file found in (default path) /opt/CA/PerformanceCenter/DM/logs. Data Source ID 7 is the NFA Data Source. The error states that users from NFA are missing their Group relationship from NFA.
Incomplete Data Source deletion left incorrect information in the PC database. When the Data Source was added again it failed to update user information with the correct Group relationship, resulting in the error leading to sync failure.
At root the resulting problem is a NULL value for the PermissionItemID column value in the netqosportal.bind_users table for users synced from the NFA Data Source. These users would be referenced by the SourceID value for the NFA Data Source.
This shows the SourceID value for each Data Source by name when run against the Performance Center MySql DB named netqosportal.
Performance Management release r3.7.7
Network Flow Analysis release r10.0.1
In the NFA MySql DB named reporter run the following to determine what PermissionItemID is currently set for the users.
In most instances post Data Source deletion there are going to be Orphaned Groups left over requiring clean up. See the following Knowledge Base article detailing how to remove those groups.