To resolve this:
1. Get the GUI from the Spectrum server
Under Windows:
a. Run bash -login (command line prompt),
b. cd $SPECROOT/mysql/bin
c. Run; ./mysql -uroot -proot
d. When the MySQL command prompt appears, run the following;
mysql>use netqos_integ
myslq>select * from registry;
This should return something similar to;
+-----------+--------------------------------------+
| attribute | value |
+-----------+--------------------------------------+
| guid | 61982d30-9978-4a2e-9183-a0eb2ef8c3ce |
+-----------+--------------------------------------+
mysql>quit
Under Linux:
e. cd $SPECROOT/mysql/bin
f. Run the following:
./mysql--defaults-file=../my-spectrum.cnf -uroot -proot
mysql>use netqos_integ
mysql>select * from registry;
This should return something similar to;
+-----------+--------------------------------------+
| attribute | value |
+-----------+--------------------------------------+
| guid | 61982d30-9978-4a2e-9183-a0eb2ef8c3ce |
+-----------+--------------------------------------+
mysql>quit
2. Update the SourceGUID on the CAPC system to the guid from the Spectrum system;
mysql -unetqos -p<PASSWORD>
mysql>use netqosportal
mysql>select SourceID,SourceGUID,ConsoleName from data_sources2;
This will return something similar to;
+----------+--------------------------------------+-------------------------------------------------+
| SourceID | SourceGUID | ConsoleName |
+----------+--------------------------------------+-------------------------------------------------+
| 0 | 7ad19999-af87-4cf4-a68c-0bf5c1e3f5f7 | CA Performance Center |
| 2 | 41e28329a7934bf48b8f4c32d2639b3e | EventManager@verri01-F170346 |
| 3 | 9f2dff7b6f5f43a2ac72f2cb24d1794f | Data Aggregator@verri01-F170345 |
| 4 | fea5625d-17a1-4229-a7f0-975040ecc3dd | Spectrum Infrastructure Manager@verri01-f165512 |
+----------+--------------------------------------+-------------------------------------------------+
4 rows in set (0.00 sec)
3. Note the SourceID for the Spectrum Infrastructure Manager Console and then update the SourceGUID to the guid you got from Spectrum.
mysql>update data_sources2 set SourceGUID='61982d30-9978-4a2e-9183-a0eb2ef8c3ce' where SourceID=4;
mysql>quit
4. In the CAPC GUI under Administration -> Data Sources, run a full Spectrum sync