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.

Release: SPDBIP99000-9.4-Spectrum-Device Based Suite-IP Services Manager
Component: