Report Manager error - "SRM HAS NOT FINISHED STARTING" - Table 'reporting.bo_only_user' doesn't exist


Article ID: 39738


Updated On:


CA Spectrum


  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


  1. Add the following entry to the specroot/mysql/my-spectrum.cnf file


  1. Stop the spectrum processd service which will also bring down the

                   Spectrum mysql service

  • Stopping services in windows: Click startà Type services.mscàstop the spectrum process daemon.
  • Starting services in windows: Click startà Type services.mscàstart the spectrum process daemon.
  • Stopping service in Unix : Go to $specrootàlibàSDPM in this path enter ./
  • Starting service in Unix: : Go to $specrootàlibàSDPM in this path enter ./
  1. Start the spectrum processd service which will also then start the Spectrum mysql service

                     Logon to the mysql interface

  • Log into the SpectroSERVER system as the user that owns the Spectrum installation
  • On Windows, start a bash shell by running “bash –login”
  • Cd to the $SPECROOT/mysql/bin directory
  • Enter the following command to log into MySQL

                        cd specroot/mysql/bin

                        mysql -uroot -proot reporting (For windows)

                        ./mysql --defaults-file=../my-spectrum.cnf -uroot –proot reporting (For Unix)

  1. Drop the bo_only_user table by executing:

                   drop table bo_only_user;

  1. Go into $SPECROOT/mysql/data/reporting

                   If any bo_only_user.* files exist, delete the

  1. Take the innodb_force_recovery line out of the my-spectrum.cnf file, and then restart the spectrum processd service again as mentioned in step
  2. Attempt to recreate the bo_only_user table by logging back into 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.