run the following SQL queries

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

I need to run the following SQL queries after enabling alert synchronization

 

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'

 

Environment

Release : 4.2

Component : SOI REPORTS

Resolution

In the Administration page, go to the Manager Configuration page. Enable the alert synchronization in the Synchronization Configuration page.

 

 Stop all SOI services.

 

Open the SQL Server Management Studio, run the following SQL queries against the SAMStore DB.

 

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'