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

Document ID : KB000029380
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

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

 TEC1083987-Unable to access the SRM preferences.docx

 

Solution:

Check the tomcat stdout.log or catalina.out 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

 

We need to check the registry table under MySQL, below are the steps:

 

1. Windows:

bash -l

    Unix:

 cd $SPECROOT

 

2. cd mysql/bin

./mysql--defaults-file=../my-spectrum.cnf -uroot -proot reporting;

tee registryoutput.txt

select * from registry \G

Note:  A registryoutput.txt file will be created under %SPECROOT%\mysql\bin folder this can be stored as backup.

 

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: +@ --e-?

CrystalReportsHost: localhost

DBHost: localhost

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

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

BOInfoViewCredentials: none

BOInfoViewAuthType:

UniverseUser: WEBI_user

UniversePassword: +@ --e-?

is_security_enabled: false

DefaultBOXIUserPassword:

isPerformanceMonitorEnabled: true

install_version: 9.2.3.10.159

PollTaskMaxTardy: 750

BOSharedSecret: Okv<+

 

From the above output serverslist column is blank hence we are getting the error, we need to update the column using below sql command:

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

output:

Query OK, 1 row affected (0.00 sec)

 Rows matched: 1  Changed: 1  Warnings: 0

 

Reboot the box or Restart the all the Spectrum services.  Now you will be able to enable the Monitor option without any error.

 

If still issue persists please contact CA Support

File Attachments:
TEC1083987.zip