When trying to open infoview we are getting "SRM HAS NOT FINISHED STARTING"

Document ID : KB000039738
Last Modified Date : 14/02/2018
Show Technical Document Details

 

 Issue:


      When trying to open InfoView in the Spectrum OneClick web page, the user is seeing “SRM has not finished starting” and is unable to log into InfoView.

Cause:

           “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.

 

Resolution:


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

                    innodb_force_recovery=6

             2.       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 ./processdshutdown.sh

                          ·         Starting service in Unix: : Go to $specrootàlibàSDPM in this path enter ./processdstartup.sh

             3.       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)

             4.       Drop the bo_only_user table by executing:

                   drop table bo_only_user;

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

                   If any bo_only_user.* files exist, delete the

             6.       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

             7.       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.