Spectrum upgrade failure with error message "slmWebOp.cus has failed"

Document ID : KB000028712
Last Modified Date : 14/02/2018
Show Technical Document Details

During upgrade of Spectrum it fails with the following messages seen below:

 Script Install-Tools/CUS/slmWebOp.cus has failed

 

Errors occurred during the execution of the custom scripts noted above. Please refer to the appropriate install.log file for specific information on the error. These errors must be resolved before installing any Service Packs or hot fixes.

3. ERROR 1054 (42S22) at line 49 in file: 'D:\win32app\Spectrum\Install-Tools\slm\sql\migrate_to_schema201.sql': Unknown column 'sm_monitors.userMH' in 'field list' D:/win32app/Spectrum\Install-Tools\slm\sql\migrate_to_schema201.sql exitValue: 1

Executing command: 

 4. ERROR 1054 (42S22) at line 49 in file: 'D:\win32app\Spectrum\Install-Tools\slm\sql\migrate_to_schema201.sql': Unknown column 'sm_monitors.userMH' in 'field list' D:/win32app/Spectrum\Install-Tools\slm\sql\migrate_to_schema201.sql exitValue: 1

Executing command: 

D:\win32app\Spectrum\mysql\bin\mysql.exe --defaults-file=D:\win32app\Spectrum\mysql\my-spectrum.cnf -uroot -proot -e source D:/win32app/Spectrum\Install-Tools\slm\sql\migrate_to_schema301.sql 

ERROR 1060 (42S21) at line 42 in file: 'D:\win32app\Spectrum\Install-Tools\slm\sql\migrate_to_schema301.sql': Duplicate column name 'activeTime'

D:/win32app/Spectrum\Install-Tools\slm\sql\migrate_to_schema301.sql exitValue: 1

 

Solution:

The problem is due to a change in JAR file locations with tomcat. Previously the location was in $SPECROOT/tomcat/lib folder and later moved to $SPECROOT/tomcat/custom/lib directory.

While upgrading the JAR files, the install was not able to be locate the above and would result instantly in not finding the files and a failure.

Perform the following steps to resolve:

  1. Copy the lib folder with all its files and folders in it ( $SPECROOT/lib directory).

  2. Create a new custom folder under $SPECROOT/tomcat ($SPECROOT/tomcat/custom).

  3. In this new custom directory paste the lib folder that we have copied with all files and folders in it (It should be $SPECROOT/tomcat/custom/lib).

 

Stop and restart the tomcat service then rerun with the installer again.