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"

Document ID : KB000032398
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

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"

 

Resolution:

On a Windows Spectrum Server:

1.  Open a command prompt and go to:

  <Install Directory>:\win32app\Spectrum\mysql\bin

2.  Run the command below to login to mysql:

   mysql uroot -proot

3.  Once logged into mysql run:

   drop database netqos_integ;

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

SpectrumTomcat.png

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.

 

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.