Alerts not getting cleared in Spectrum when they are cleared in SOI

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

When alerts gets cleared in SOI, they are not being cleared in Spectrum

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

We did the following to fix the SOI to Spectrum alert synch. problem.

1) Stop all SOI services (Manager, UI, Connectors)

 

2) On the SOI Manager delete all files in

\CA\SOI\apache-activemq\data\kahadb\

\CA\SOI\ucf\ucf_broker_store\

\CA\SOI\tomcat\temp\

 

3) On the UI Server delete all files in

\CA\SOI\SamUI\temp\

 

4) Ran the following 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'

 

5) Start up all SOI services.

 

Once all services and connectors came online and completed the processing, we cleared an alert from SOI and confirmed it got cleared in Spectrum.