mon_config_service wont start after 20.3 upgrade

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Probe stays red, exhausted all the troubleshooting I can do.

Environment

Release : 20.3

Component : UIM - MON_CONFIG_SERVICE

Resolution

If you're running 20.3.2,

Go to the hotfix site at https://support.broadcom.com/external/content/release-announcements/CA-Unified-Infrastructure-Management-Hotfix-Index/7233

and download this hotfix bundle zip which is cumulative:
mon_config_service_20.31_HF1_bundle.zip

Release Notes:

Hotfix: mon_config_service_20.31_HF1_bundle
Release Date: 11th Dec 2020
Applicable for: UIM 20.3.1

This patch addresses the following:

DE481849: 32283937 - KPN B.V.(2001566) - Update on UIM profile does not always trigger an probe restart
DE483074: 32327952 - KPN B.V.(2001566) - USM does not always assign monitoring profiles to server. We have them in groups that should apply monitoring to them.

This zip bundle contains the following UIM hotfix packages related to mon_config_service and their respective readme files:

mon_config_service_20.31_HF1.zip
mon_config_service_cli_20.31_HF1.zip
mon_config_service_ws_20.31_HF1.zip
mon_config_service_recon_20.31_HF1.zip

Steps to apply the current patch:
Read the respective package readme files

Deployment instructions

These artifacts are to be applied on UIM 20.3.1. Perform the deployment of the packages in the following order:

Deploy mon_config_service_20.31_HF1.zip

mon_config_service_ws_20.31_HF1.zip

mon_config_service_recon_20.31_HF1.zip

mon_config_service_cli_20.31_HF1.zip ( Please refer to the respective release notes)

 

To clear out all of the existing tables and reset MCS you can do the following:

UIM 9.02 and later...

Deactivate mon_config_service probe 

Browse to the Nimsoft\probes\service\mon_config_service\lib directory

Copy the mcs-db-scripts.jar file to the desktop.  (Make sure you do not move this file)

Rename the file to mcs-db-scripts.zip.

Open the ZIP file and extract the following file ONLY (\mcs-db-scripts.zip\legacy\sqlserver or mysql or oracle, depending on the UIM database in use):

SSRV2_drop_all_tables.sql

Copy the .sql file to DB server and run the script to drop the table structure (right-click on the file > Open With > Keep using SQL Server Management Studio). If any table is not removed by the query, please remove them manually, e.g., via Rt-Click->Delete in SQL Server Studio.

Activate the mon_config_service probe - it will create the needed tables automatically.

Deploy mon_config_service packages and probe_templates from Archive. Eg. cdm_mcs_templates, processes_mcs_template, net_connect_mcs_templates etc. 

Create and deploy a profile under Monitoring tab in USM.