Alert Queue Duplicates in DB AlertQueue Table

book

Article ID: 125654

calendar_today

Updated On:

Products

CA Service Operations Insight (SOI)

Issue/Introduction



I see duplicate entries for several queues, one is active and the rest are "deleted" status. I assume this is normal?

Environment

Release: SAMBDL99000-4.2-Spectrum-Service Assurance Manager-Promotional Bundle
Component:

Resolution

If you create and delete a queue with same name or with different name the deleted queue stays back in AlertQueue table as inactive. The "Deleted" column hold the value for the deleted alert queue and it'll change from 0 (active) to 1 (inactive), you'll also notice the deleted time value inserted in to "Deleted Time" column. This is normal.