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"

book

Article ID: 32398

calendar_today

Updated On:

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

  1.  Run the command below to login to mysql:

  ./mysql -uroot -proot

  1.  At the MySQL command prompt, run:

   drop database netqos_integ;

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

  1.  Wait for Spectrum One Click to become available after the recycling of the "Spectrum Tomcat" service.

  2.  Then in  NPC/CAPC and go to the Admin->Data Sources page and add the Spectrum Data Source.

  3.  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

  1.  Once logged into mysql run:

  drop database netqos_integ;

  1.  Recycle the Spectrum Tomcat Service

  2.  Wait for Spectrum One Click to become available after the recycling of the "Spectrum Tomcat" service.

  3.  Then in  NPC/CAPC and go to the Admin->Data Sources page and add the Spectrum Data Source.

  4.  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.

Attachments