Alarm details not sync in DB
Please find below screenshot for reference.
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'
Release : 20.2
Component : Spectrum Reporting
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