When trying to access Report Manager configuration in OneClick Administration page, the user is seeing “SRM has not finished starting” and is unable to log into Jaspersoft.
“Check the $SPECROOT/tomcat/logs/catalina.out (Linux and Solaris) or the $SPECROOT/tomcat/logs/stdout.log (Windows) for the following error:
Table 'reporting.bo_only_user' doesn't exist.
If seen the above error please follow the below resolution.
Release: Spectrum 10.x
Component: Report Manager / SRM
innodb_force_recovery=6
Spectrum mysql service
Logon to the mysql interface
cd specroot/mysql/bin
mysql -uroot -proot reporting (For windows)
./mysql --defaults-file=../my-spectrum.cnf -uroot –proot reporting (For Unix)
drop table bo_only_user;
If any bo_only_user.* files exist, delete the
mysql interface and executing the following command:
CREATE TABLE `bo_only_user` ( `bo_user_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_name` varchar(255) DEFAULT NULL, `load_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`bo_user_id`), UNIQUE KEY `user_name` (`user_name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
If the table is successfully recreated then restart spectrum processd and tomcat.