SRM won't complete start up

book

Article ID: 182917

calendar_today

Updated On:

Products

CA Spectrum CA eHealth

Issue/Introduction

When trying to launch the report manager the customer is seeing the following error:

SRM has not finished starting. 

The catalina.out file shows the following exceptions indicating a corrupt table. 

Caused by: java.sql.SQLException: Table './archive/archive_activity_log' is marked as crashed and should be repaired
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2690)
 at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1648)
 at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1567)
 at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
 at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:538)
 at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:535)
 at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)

Cause

The './archive/archive_activity_log' log table is corrupt and needs to be repaired. 

Environment

Release : 10.3.2

Component : Report Manager

Resolution

On the SRM server:

Navigate to the $SPECROOT/mysql/bin directory in a bash shell.


Run the following command:

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


Run the following command from the mysql prompt:

repair table archive_activity_log;

Restart Tomcat.