UIM alerts from a specific instance are not published on SOI

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

Some alarms from the UIM connector to SOI are not showing in SOI and they are not auctioning the subsequent incidents.

Only alarms coming from a specific set of instances are no longer getting through. 

All other alarms from the same connector, but coming from different sources are getting through and processed correctly. 

The alarms affected are visible in the UIM OC console, in SOI no longer since the issue started. No policy that is interfering
Maintenance is not used.

 

 

 

 

Environment

SOI : “4.2"

Catalyst: 3.4.4.4

Catalyst Installer: 3.4.4.12

 

 

Cause

We can see in catalyst logs that the CIs are not creating properly and so, it is failing while creating the sheet with SOI.

There are some corrupted CIs within the SOI Database which we have to remove from SOI.

2022-11-22T17:57:41,584 ERROR [JMS xxxxxxxxxx_CatalystConnector] impl.SessionImpl.createSheet(415) [SOI] - 
createSheet Failed with Exception:Cannot insert duplicate key row in object 'dbo.ca_xxx_xxx_xxxxl' with unique index 'mdr_id_idx'. The duplicate key value is (CI_xxx.xxxx.xxx.com, Zxxxxxxxxx5, CA:00050). :ID:xxx.xxxx.xxx: XML:<?xml version="1.0" encoding="UTF-8"?>

All the alarms are publishing from Connectors but its clearing due to a corrupt CIs.

Resolution

Completely remove the Connector and redeploy:

1. Stop the Catalyst container service.

2. Remove connector from SOI UI Administration --> Connector configuration

3. Once it's removed all the CIs and alert. Please run the below SQL query on the SOI database. There should not be any entries in the below table after removing the connector:

  

select * from ca_ssa_ci_detail where c_mdrproduct='CA:00050';    

4. Start the Catalyst container.

 

 

Additional Information

- If the container cannot be removed due to corruption, the deletion needs to be done manually with delete statements to the DB. Manually Remove A Connector From SOI

- Similar issue seen with other connectors like Spectrum and ConnectorAccelerator, the same process above applies