Spectrum Report Manager error running the alter registry add customlogopath sql

Products

• Spectrum

Issue/Introduction

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