search cancel

Spectrum alarms and events are not showing in jasperSoft reporting


Article ID: 200632


Updated On:


CA Spectrum DX NetOps


CA spectrum SRM is not showing the alarms details.


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


Release : 10.3

Component : Spectrum Core / SpectroSERVER


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.