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

Products

• CA Spectrum

Issue/Introduction

During the 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

 

 

Environment

Spectrum 10.2.x to 10.3.0 Upgrade

Resolution

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