When alerts gets cleared in SOI, they are not being cleared in Spectrum
Release : 4.2
Component : Service Operations Insight (SOI) Manager
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
3) On the UI Server delete all files in
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.