Spectrum alarms and events are not showing in jasperSoft reporting

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

CA spectrum SRM is not showing the alarms details.

Environment

Release : 10.3

Component : Spectrum Core / SpectroSERVER

Cause

The tomcat log shows a problem in at least 1 bucket file that needs to be repaired. 

Sep 22, 2020 21:32:22.672 (SRM/AlarmHandler/bucketReader) (SRM_Alarms) - (ERROR) - Unknown exception encountered while processing name events: processing halted for all servers

Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT event_ID, time, event_seq, model_key, vardata, type, model_h, domain, event_key FROM alarmbucket1048576_1598841858155 WHERE event_seq BETWEEN ? AND ? ORDER BY event_seq]; SQL state [HY000]; error code [126]; Incorrect key file for table '.\reporting\alarmbucket1048576_1598841858155.MYI'; try to repair it; nested exception is java.sql.SQLException: Incorrect key file for table '.\reporting\alarmbucket1048576_1598841858155.MYI'; try to repair it

Resolution

The bucket file can be repaired from mySQL.
From a bash shell or cmd line on the OC SRM server, navigate to SPECROOT/mysql/bin


$ mysqlcheck -uroot -proot --repair reporting alarmbucket1048576_1598841858155.MYI

restart tomcat and mySQL on the server and check the synch time to see if it is now updating.