The restart of Infoview for Spectrum Report Manager can fail with the error message 'SRM has not finished starting' after hotfix H03 has been applied and the required spectrum-wkp-update.bat script has been executed.
The problem is based on the following errors found on the tomcat log file (stdout.log or catalina.out):
May 13, 2011 11:00:22 AM (SRM/Startup/Container)
(ERROR) - Error occurred while initializing SRM components
com.aprisma.spectrum.app.repmgr.exceptions.SRMException: Error occurred
while applying schema changes to reporting database
Error occurred while running schema change script.
These errors occurred because the view create_v_dim_alarm_condition exists as a physical table while you run the spectrum-wkp-update.bat script.
Move to the affected view and check the description of the view using these mysql commands. If you are not familiar with executing mysql commands consult the Spectrum Database Management guide:
mysql> show databases;
mysql> use srmdbapi
mysql> show tables;
mysql> show table status like 'v_dim_alarm_condition'\G
The Comment column should display:
In the case it returns for example:
Comment: Incorrect information in file: '.\srmdbapi\v_dim_alarm_condition.frm'
Drop the table create_v_dim_alarm_condition and rerun spectrum-wkp-update.bat script.
As soon as Infoview is started all views will be built from scratch.
It may be possible that this step has to run for all other views.