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 : 10/05/2019
Show Technical Document Details
Introduction:

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.



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.

Instructions:
Please Update This Required Field