ALARMINFO Table Not sync.

Products

• CA Spectrum

Issue/Introduction

Alarm details not sync in DB

Please find below screenshot for reference.

 

Environment

Release : 20.2

Component : Spectrum Reporting

Cause

SRM is unable to update events in instanteventactivitylog

Aug 12, 2021 20:46:18.599 (InstantEventPolling_Thread) (SRM_Events) - (ERROR) - Error while processing instant events for 

 

Caused by: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [INSERT INTO instanteventactivitylog (landscape_h, poll_start_time) VALUES (?, now())]; Duplicate entry '54585' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '54585' for key 'PRIMARY'

Resolution

Please follow below steps

open a command prompt 

bash -l

cd mysql/bin

cleared the entries in instanteventactivitylog

delete from instanteventactivitylog

recycle the spectrum tomcat service