Event manager can't be added as a data source

Products

• CA Infrastructure Management
• CA Performance Management

Issue/Introduction

Event Manager Missing As Data Source in NetOps Portal.  When trying to add the Event Manager as a Data Source, I receive an error saying

"Data Source  is already registered to another NetOps Portal instance."

Environment

Dx NetOps Performance Management any version
 

Cause

If the Event Manager Data Source gets deleted from NetOps Portal
(during a NetOps Portal upgrade for instance) you will need to add it back into NetOps Portal.
 
Performing a Data source test you might get "Data Source Test Successful"
However when you try to save the data Source you get the following error :
 
Adding Data Source Failed          
Data source is already registered to another NetOps Portal instance

This error is caused by NetOps Portal containing information about the original instance of the EM data source and when you try to add it again NetOps Portal wants to create a new instance.
 

Resolution

In order to have NetOps Portal and EM back in sync, please do the following procedure
 

1. From Admin UI, remove EM data source (if present).
2. Remove all NPC related properties from em.general table in mysql:
   • mysql em -unetqos -pnetqos
   • DELETE from em.general where Attribute LIKE '%NPC.%';
   • exit    
3. Restart EM: service caperfcenter_eventmanager restart
4. Manually add the EM data source again.

 
 ** Please note that any configured notifications or stored events will be lost, and notifications will need to be recreated.