Spectrum Report Manager error running the alter registry add customlogopath sql

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

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) 
Spectrum Report Manager in 10.2.x
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.