Spectrum SRM One Click still trying to contact with landscapes that are not present anymore

Products

• CA Spectrum

Issue/Introduction

The Customer has 4 OC's (Spectrum running 20.2.5). One of the OC is integrated with SRM > CABI. There are 32 landscapes (no FT) and when checking the catalina.log, I can see the following lines:

sp-oc-03 ~]$ cat /opt/spectrum/tomcat/logs/catalina.out | grep -i dss
Feb 08, 2021 13:51:31.542 (SRM/Startup/Container) (ReportManager) - (WARN) - Domain xx-yyy-03a cannot be found and will not be reported on
Feb 08, 2021 13:51:31.542 (SRM/Startup/Container) (ReportManager) - (WARN) - Domain xx-yyy-01a cannot be found and will not be reported on
Feb 08, 2021 13:51:31.542 (SRM/Startup/Container) (ReportManager) - (WARN) - Domain xx-yyy-04a cannot be found and will not be reported on
Feb 08, 2021 13:51:31.542 (SRM/Startup/Container) (ReportManager) - (WARN) - Domain xx-yyy-02a cannot be found and will not be reported on

Those landscapes have been gone for more than a year now, but still Spectrum is trying to contact that.

I have been troubleshooting the issue and after cleaning the reporting DB (removed those landscapes) and make sure the mapupdate was correct, the messages are still coming.

Follow the KB:

https://knowledge.broadcom.com/external/article/40274/why-do-i-still-get-errors-in-my-srm-tomc.html

and even after that the messages are still coming. Restarted the box to clear possible data being cached, but still the same situation.

How can we get rid of those messages for good?

 

Cause

Those decommissioned landscapes are still in the registry table of the reporting database.

mysql> select * from registry \G

ServersList: [ xx-yyy-03a, xx-yyy-01a, xx-yyy-04a, xx-yyy-02a, xx-yyy-12, xx-yyy-14, xx-yyy-28]

Environment

Release :

Component :

Resolution

Remove the decommissioned servers from the ServerList row of the registry table from the reporting database.

1. Open a bash shell on the OneClick + SRM machine

2. Navigate to the $SPECROOT/mysql/bin/ directory

3. Run the following syntax to connect to the MySQL command line:

$ ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting -A (Linux)
OR
$ ./mysql.exe -uroot -proot reporting (Windows)

4. Run the following syntax to update the ServerList row in the reporting.registry table:

mysql> update registry set ServersList='[xx-yyy-12, xx-yyy-14, xx-yyy-28  ]';

5. Stop/start the Spectrum Tomcat service.