Upgrade from UIM 20.3.3 to 20.4 fails

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When upgrading from UIM 20.3.3 to 20.4, the installation fails at 25%.  Looking at the end of the installation log, we see references to an exception:

ERROR impl.UIMServerDBSchemaController:run:173 - NimException caught
(503) , com.microsoft.sqlserver.jdbc.SQLServerException: The statistics 'Columns' is dependent on column 'columns'

Environment

UIM 20.3.3 -> UIM 20.4

Cause

The query being run references altering TABLE "UMPALARMVIEWERINFO" to alter COLUMN "columns".

Checking the database for the UMPALARMVIEWERINFO table, we saw the following:

Only the PK_UMPALARM_* should be there for this command to properly run.

Resolution

The below steps resolved the issue:

1. Ensure that you have a backup of the UIM database.
2. Save off the Columns and Filters entries noted above:
   • Right click each one and select Script Statistic As->CREATE To->New Query Window and save the result. 
3. Right click and delete the Columns and Filters
4. Resume or restart the installation.  It should continue through this and on to the rest of the upgrade.