Alarm Policy stuck in delete

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Selected to remove an alarm policy in Operator Console and it appears to be stuck in delete:

Environment

• UIM 23.4
• Operator Console
• Alarm Policies

Resolution

1. Determine the policy that is stuck in the database:
   
   select * from policy where name like '%part_of_the_name%'
   
   
2. If the policy is listed with a state = 'PENDING_DELETE' than it can be adjusted back to 'OK' and a delete can be tried in the Operator Console once again:
   
   update policy set state='OK' where id = <policy_id>
   
   
3. Open Operator Console and select to remove the policy again