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

book

Article ID: 205534

calendar_today

Updated On:

Products

CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) NIMSOFT PROBES DX Infrastructure Management

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. 

 

 

 

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.

Environment

Release : 20.3.1/20.3.2

Component : UIM - HUB

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. 

Attachments