After deleting Spectrum as a data source from CAPC, and trying to add it back, there is an error stating "Adding Data Source Failed, Data Source is already registered to another Performance Center instance"

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

After deleting Spectrum as a data source from NPC, and trying to add it back, there is an error stating:

Adding Data Source Failed, Data Source is already registered to another Performance Center instance

Environment

Spectrum 10.x
CAPM 3.x

Resolution

On a Windows Spectrum Server:

1. Open a command prompt (bash -login) and go to:

 $SPECROOT/mysql/bin

2.  Run the command below to login to mysql:

  ./mysql -uroot -proot

3.  At the MySQL command prompt, run:

   drop database netqos_integ;

4.  Then, restart the "Spectrum Tomcat" service.

5.  Wait for Spectrum One Click to become available after the recycling of the "Spectrum Tomcat" service.
   
   
6.  Then in  NPC/CAPC and go to the Admin->Data Sources page and add the Spectrum Data Source.
   
   
7.  Only after adding the Spectrum Data Source back to NPC/CAPC will the netqos_integ table be populated.

 

On a Linux Spectrum Server:

1.  Go to the /usr/Spectrum/mysql/bin directory.
   
   
2. Type the following to login to mysql:

  ./mysql--defaults-file=../my-spectrum.cnf -uroot -proot

3.  Once logged into mysql run:

  drop database netqos_integ;

4.  Recycle the Spectrum Tomcat Service
   
   
5.  Wait for Spectrum One Click to become available after the recycling of the "Spectrum Tomcat" service.
   
   
6.  Then in  NPC/CAPC and go to the Admin->Data Sources page and add the Spectrum Data Source.
   
   
7.  Only after adding the Spectrum Data Source back to NPC/CAPC will the netqos_integ table be populated.

NOTE: If you get the following message to drop the netqos_integ database, follow these steps:

mysql> drop database netqos_integ;
ERROR 1010 (HY000): Error dropping database (can't rmdir '.\netqos_integ', errno: 41)

a) Stop the Spectrum Process Daemon service, which will also stop the Spectrum MySQL Database Server service

b) Manually move any file that remains in the $SPECROOT/mysql/data/netqos_integ/ directory to a temporary folder

c) Start the Spectrum Process Daemon service, which will also start the Spectrum MySQL Database Server service

d) Rerun the "drop database netqos_integ;" to drop the netqos_integ database

Additional Information

This procedure may also be needed in other situations where Events from NPC are no longer displayed as Alarms in NPC.

**Note** if you are running NPC 6.2, it will require a patch on the Spectrum side in order for this integration to work.  If you should be running NPC 6.2 with Spectrum please open an issue with Spectrum Support.