Deleted Alarm Policies are still visible within the OC

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We have several Alarm Policies that were deleted some time ago but they are still being displayed in the Alarm Policies OC Page. 

These alarm policies are displayed in the list but are greyed out. How can we delete/remove these alarm policies?

Environment

Release : 20.4, 20.3

Component : UIM OPERATOR CONSOLE - ALARM POLICY

Resolution

1. Run the query below to obtain a list of all Policies and check the state status

select * from policy

2. Confirmed if suspect policies are in PENDING_DELETE state

Example

3. Run the query below against each policy ID with the PENDING_DELETE state and delete the Policy from the OC Alarm Policies page

Example for policy id 78:

update policy set state = 'OK' where id = 78

NOTE: Please be aware this will permanently delete from the UIM database. You should consult your DBA or Broadcom Technical Support if you have concerns. 

4. Then delete the Policy from Alarm Policies OC Page.