Upgrade from UIM 20.3.3 to 20.4 fails
search cancel

Upgrade from UIM 20.3.3 to 20.4 fails


Article ID: 276352


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


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'


UIM 20.3.3 -> UIM 20.4


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.


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.