Spectrum Report Manager error running the alter registry add customlogopath sql

Document ID : KB000116757
Last Modified Date : 02/10/2018
Show Technical Document Details
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.