Getting Error "Unable to access the SRM preferences" when trying to enable monitor option

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

Getting Error "Unable to access the SRM preferences" when trying to enable monitor option under Spectrum Status

 

  

Environment

Release:
Component:

Resolution

NOTE: In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.

Check the tomcat $SPECROOT/tomcat/logs/stdout.log (Windows) or catalina.out (Linux) for below error:

SRMDomainListener: unable to obtain servers from mysql registry

Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to java.util.List

If the above error is seen, next check the MySQL registry table for the reporting database on the Spectrum Report Manager (SRM) system by doing the following:

1. Log into the SRM system as the user that owns the SRM installation

2. If on Windows, start a bash shell by running "bash -login"

3. cd to the $SPECROOT/mysql/bin directory and enter the following command to log into mysql:

./mysql --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD> reporting;

4. Enter the following command at the mysql prompt to list the registry:

select * from registry \G

 

The following is sample output:

select * from registry\G

*************************** 1. row ***************************

reg_user: System

OneClickServerEntry: http://<OC_Host>:8080

SRMPollPeriod: 24

SRMPollStartTime: 0

SRMPollEndTime: 24

IFIdleThreshold: 0

ServersList:

CrystalInstallRoot:

CrystalCommonFiles:

CrystalHome:

CrystalPassword:

ReportSuppressedAlarms: false

BOPassword: ` v %?- :

BOCommonFiles:

BOHome:

BOInstallRoot:

ConvertedReportsToBOXI: false

ArchivalRetentionDays: 90

event_archival_retention_days: 90

DataRetentionPolicy: purge

customlogopath: D:win32appSpectrumcustomepmgrlogo.bmp

isReportingReady: true

handler_batch_size: 1000

event_poller_processing_interval: 60

MonitorSRM: true

SRM_Model: 5298329

BOUser: Administrator

BOHost: <OC_Host>

BOPort: 6404

BOAuthType: secEnterprise

BOTomcatPort: 8087

CrystalReportsUser: CR_user

CrystalReportsPassword: <password>

CrystalReportsHost: localhost

DBHost: localhost

BOInfoView: http://<OC_Host>:8088/InfoViewApp

BOCmc: http://<OC_Host>:8088/CmcApp

BOInfoViewCredentials: none

BOInfoViewAuthType:

UniverseUser: WEBI_user

UniversePassword: <password>

is_security_enabled: false

DefaultBOXIUserPassword:

isPerformanceMonitorEnabled: true

install_version: 9.2.3.10.159

PollTaskMaxTardy: 750

BOSharedSecret: <secretValue>

 

5. From the above output notice, the ServersList parameter is blank which is causing the error. The "ServersList" parameter needs to be updated with the hostname(s) of the Landscapes.

In this example, the "ServersList" parameter needs to be updated with (example hostnames shown) "Spectrum-04" by entering the following command:

update registry set ServersList='[Spectrum-04]';

In the case of multiple SpectroSERVERs, the ServerList parameter can up updated with the following command:

update registry set ServersList='[Spectrum-04, Spectrum-05]';

6. Log out of mysql

7. Reboot the SRM system