Alert being dropped by SOI Manager

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

SOI Manager is dropping with the following message in the connmgr log

com.ca.ssa.sor.persistence.PersistenceManagerException: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'dbo.ca_ssa_ci_detail' with unique index 'mdr_id_idx'

Environment

SOI 4.2 CU5

Resolution

Ran the following SQL queries to look for hostname to remove any existing entries from the database

select * from ca_ssa_computersystem where c_mdrelementid like '%hostname'
Result 1 row

select * from cistaging where label like '%hostname%'
Result 0

select * from ci where label like '%hostname%'
Result 0

select * from dbo.ca_ssa_ci_detail where c_mdrelementid like '%hostname' and type not like 'ComputerSystem'
Result 1

delete from dbo.ca_ssa_ci_detail where c_mdrelement like "%hostname" and c_type like 'ComputerSystem'

delete from ca_ssa_computersystem where c_mdrelementid like '%hostname'

 

NOTE: Change the hostname to the actual hostname of the CI for the queries