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 issue was not fixed.

 

Environment

• DX UIM 23.4.* 
• MS SQL

 

Cause

non reproducible issue / orphan record in the database

Resolution

To resolve the issue delete the orphan record by running below queries:

-- you 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='';