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.