Default MCS policy locked in PENDING_DELETE state

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We realize that one alarm policy was not correctly deleted after we removed the profile on MCS.

The policy stays 'grayed-out' on Policy window.

Looking at the Policy table on UIM database, this policy is in "PENDING_DELETE" state.

We tried to delete and recreate the device, but the the issue was not fixed.

 

Environment

Release : 20.3

Component : UIM OPERATOR CONSOLE - MCS UI

Resolution

Deleted orphan record by running below queries

Should input the profileId or policyId in the queries and run the queries one by one

delete from SSRV2PolicyProfileBlob where policy_id='';
delete from Policy where id='';
delete from PolicyMetric where profileId ='';
delete from PolicyTarget;
delete from PolicyThreshold where condition_id in (select id from PolicyCondition where policy_id='');
delete from PolicyCondition where policy_id='';