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: