UIM - After upgrade to 20.3.x SLM Groups, Accounts, and SLA's are not visible

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We have upgraded UIM to 20.3.x correctly. Our SML Operator Console SLM application is not showing any SLM groups,  Accounts or SLA's.  

We have multiple SLAs and Multiple Accounts and they are in the database. 

 

 

 

Environment

Release : 20.3.1/20.3.2

Component : UIM - HUB

Cause

If there is an SLA alarm with warning_severity = to null this issue may be occur. This would generate an error that prevents the browser to retrieve in the OC the SLM list with the accounts and groups.

Resolution

This issue ( DE488011) will be resolved in a Future Patch of UIM 20.3.x 

 

In the meanwhile, the issue can be resolved with the following steps: 

 

Step 1: Run the below query on DB 

 

select sla_id from S_SLA_ALARM where warning_severity is null 

 

Step 2: Copy the sla_id and run the below update query 

 

update S_SLA_ALARM set warning_severity =0  where sla_id ='<--SLA_ID from first query ---> '

 

-- Repeat the operation with all the warning_severity having null value and replace with a '0'.

 

Step 3:  Log-of and log in again and the issue should be resolved. 

Additional Information

Related KB:
After upgrade to UIM 20.3.x alarms show "Error retrieve alarms" and Groups not visible (broadcom.com)