mon_config_services failed during upgrade

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Upgrading to UIM 20.1 mon_config_service probe is failing during 8.51 to 9.0.2 portion of upgrade process.

Environment

Release : UIM 8.51->9.02 (during upgrade)

Component : UIM - MON_CONFIG_SERVICE

Cause

- upgrade issue with mon_config_service table

Resolution

The SSRV2DeviceGroup table in the CA UIM backend database has an attribute/column named 'model_device' AND there is a statistic named 'model_device' as well which is apparently causing a conflict/error during upgrade of 8.51 to 9.0.2. 

SQL State  : S0001
Error Code : 5074
Message    : The statistics 'model_device' is dependent on column 'model_device'.
Location   : flyway/sqlserver/V8_5_0_01__Remove_Device_Type_Template.sql (E:\CA\UIM\probes\service\mon_config_service\file:\E:\CA\UIM\probes\service\mon_config_service\lib\mcs-db-scripts.jar!\flyway\sqlserver\V8_5_0_01__Remove_Device_Type_Template.sql)
Line       : 4
...
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The statistics 'model_device' is dependent on column 'model_device'.
...
etc.

Drop/delete the named statistic, e.g.,

   DROP STATISTICS SSRV2DeviceGroup.model_device

and then deactivate and re-activate the mon_config_service probe and it should go through the table upgrades/modifications, but afterwards double-check to make sure there are no further errors in the mon_config_service log.

Manually dropping model_device in the statistics and restarting the mon_config_service probe allowed the upgrade process to continue and the mon_config_service probe turned green and had a port and a PID.