search cancel

Events are not getting updated in SRM - Spectrum Report Manager


Article ID: 242949


Updated On:


CA Spectrum DX NetOps


The reporting database is out of sync.

The following error was found in the $SPECROOT/tomcat/logs/stdout.log file:

May 30, 2022 18:54:56.227 (SRM/LandscapeManager/LandscapeThread_0) (ReportManager) - (ERROR) - Error initializing event polling
Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT log_id FROM instanteventactivitylog WHERE landscape_h=? ORDER BY poll_start_time DESC LIMIT 1]; SQL state [HY000]; error code [145]; Table '.\reporting\instanteventactivitylog' is marked as crashed and should be repaired; nested exception is java.sql.SQLException: Table '.\reporting\instanteventactivitylog' is marked as crashed and should be repaired
 at org.springframework.jdbc.core.JdbcTemplate.translateException(
 at org.springframework.jdbc.core.JdbcTemplate.execute(
 at org.springframework.jdbc.core.JdbcTemplate.query(
 at org.springframework.jdbc.core.JdbcTemplate.query(
 at org.springframework.jdbc.core.JdbcTemplate.query(
 at org.springframework.jdbc.core.JdbcTemplate.query(
 at org.springframework.jdbc.core.JdbcTemplate.queryForList(
Caused by: java.sql.SQLException: Table '.\reporting\instanteventactivitylog' is marked as crashed and should be repaired
 at com.mysql.jdbc.SQLError.createSQLException(
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(
 at com.mysql.jdbc.MysqlIO.sendCommand(
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
 at com.mysql.jdbc.ConnectionImpl.execSQL(
 at com.mysql.jdbc.PreparedStatement.executeInternal(
 at com.mysql.jdbc.PreparedStatement.executeQuery(
 at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
 at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(
 at org.springframework.jdbc.core.JdbcTemplate.execute(
 ... 11 more


The instanteventactivitylog table is corrupted.


Release : 21.2

Component : Spectrum Reporting


1st option - repair the corrupted table:

oscommandline> mysqlcheck -u<username> -p<password> <database_name> [<table_name>]

$ cd $SPECROOT/mysql/bin/

$ ./mysqlcheck --repair --defaults-file=../my-spectrum.cnf -uroot -pMySqlR00t reporting instanteventactivitylog



2nd option - recreate the corrupted table and initialize the reporting database:

1. First stop the Spectrum Tomcat service.

2. Drop the corrupted table.

mysql> drop table instanteventactivitylog;

3. Ensure the physical files associated with the corrupted table were removed. (instanteventactivitylog.MYD, instanteventactivitylog.MYI, and instanteventactivitylog.frm)

4. Recreate the table by running the following syntax:

CREATE TABLE `instanteventactivitylog`(`log_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `landscape_h` int(10) unsigned NOT NULL, `poll_start_time` datetime NOT NULL, `poll_end_time` datetime DEFAULT NULL, `nbr_of_events` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`log_id`), KEY `landscape_h` (`landscape_h`)) ENGINE=MyISAM AUTO_INCREMENT=32613 DEFAULT CHARSET=utf8;

5. Initialize the reporting db.

$ cd $SPECROOT/bin/ 

./RpmgrInitializeLandscape root MySqlR00t -initHist 45 -all

6. Start the Spectrum Tomcat service.

Additional Information

1. Open a bash shell on the OneClick + SRM machine

2. Navigate to the $SPECROOT/mysql/bin/ directory

3. Run the following syntax to connect to the MySQL command line:

$ ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting -A (Linux)
$ ./mysql --defaults-file=../my-spectrum.cnf -uroot -pMySqlR00t reporting -A (Linux) (Spectrum 21.2.4 onwards)
$ ./mysql.exe -uroot -proot reporting (Windows)
$ ./mysql.exe -uroot -pMySqlR00t reporting (Windows) (Spectrum 21.2.4 onwards)