SCOM Alert cleared in SOI are not clearing in SCOM

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

We are seeing SCOM alerts cleared in SOI console are not clearing out in SCOM console. So every time SOI re query SCOM, old alerts get populated all over again. Management want to know process involve to ensure alerts cleared in SOI automatically get cleared out in SCOM concurrently. 

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

Steps tp resolved issue:

 

1) Stop all SOI Services

2) Ran SQL queries

delete from ca_ssa_tags where tagname like '%synchronization.inprogress%'
delete from ca_ssa_tags where tagname like '%synched.pending%'
delete from ca_ssa_tags where tagname='synched.known.mdrs'

3) Start all SOI Services