Issue:
The Spectrum Report Manager (SRM) will not finish starting. The following errors are seen in the stdout.log (Windows) or catalina.out (Linix):
Caused by: com.aprisma.util.mysql.ScriptRunnerException: Error occurred with SQL Script
Script: D:/win32app/Spectrum/Install-Tools/rpmgr/sql/alter_registry_add_customlogopath.sql
Stdout:
Stderr:
ERROR 1060 (42S21) at line 29 in file: 'D:\win32app\Spectrum\Install-Tools\rpmgr\sql\alter_registry_add_customlogopath.sql': Duplicate column name 'customlogopath'
at com.aprisma.util.mysql.SQLScriptRunner.doRunSQLScript(SQLScriptRunner.java:251)
at com.aprisma.util.mysql.SQLScriptRunner.runScript(SQLScriptRunner.java:158)
Environment:
Spectrum Report Manager in 10.2.x
Resolution:
Check the reporting database registry to see if the value for customlogopath is set and if so, update the schemaversion tables. Do the following on the OneClick SRM system:
1. Log into the OneClick SRM system as the user that owns the Spectrum installation
2. If running Windows, start a bash shell by running "bash -login"
3. cd to the $SPECROOT/mysql/bin directory
4. Enter the following command to make a backup of the reporting registry:
./mysqldump --defaults-file=../my-spectrum.cnf -uroot -proot reporting registry > registry.sql
5. Enter the following command to make a backup of the reporting schemaversion:
./mysqldump --defaults-file=../my-spectrum.cnf -uroot -proot reporting schemaversion > schemaversion.sql
6. Enter the following command to log into mysql:
./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting
7. At the mysql prompt, enter the following command to find out the value of customlogopath in the registry:
select customlogopath from registry;
a. If there is a value returned, enter the following command:
update schemaversion set state='A' where name = 'AddCustomLogoPath';
b. If no value is returned, enter the following command:
alter table registry drop column customlogopath;
8. Restart tomcat on the OneClick SRM system.