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

book

Article ID: 29380

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

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

 

  

Environment

Release:
Component:

Resolution

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 -proot 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://Spectrum-03: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: SPECTRUM-03

BOPort: 6404

BOAuthType: secEnterprise

BOTomcatPort: 8087

CrystalReportsUser: CR_user

CrystalReportsPassword: [email protected] --e-?

CrystalReportsHost: localhost

DBHost: localhost

BOInfoView: http://Spectrum-03:8088/InfoViewApp

BOCmc: http://Spectrum-03:8088/CmcApp

BOInfoViewCredentials: none

BOInfoViewAuthType:

UniverseUser: WEBI_user

UniversePassword: [email protected] --e-?

is_security_enabled: false

DefaultBOXIUserPassword:

isPerformanceMonitorEnabled: true

install_version: 9.2.3.10.159

PollTaskMaxTardy: 750

BOSharedSecret: Okv<+

 

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 "Spectrum-04" by entering the following command:

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

6. Log out of mysql

7. Reboot the SRM system

 

Attachments

1558686971173000029380_sktwi1f5rjvs16f5f.png get_app