Spectrum not in sync with jasper

Products

• CA Spectrum

Issue/Introduction

Spectrum events are not in sync with jasper.  

Nov 23, 2021 23:38:10.192 (SRM/EventPoller/smr-caspec3) (SRM_Events) - (ERROR) - Error while processing instant events for spec3.

Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO instanteventactivitylog (landscape_h, poll_start_time) VALUES (?, now())]; SQL state [HY000]; error code [1036]; Table 'instanteventactivitylog' is read only; nested exception is java.sql.SQLException: Table 'instanteventactivitylog' is read only
 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)

Caused by: java.sql.SQLException: Table 'instanteventactivitylog' is read only

Environment

Release : 10.4

Component : Spectrum Reporting

Cause

Table got locked

Resolution

Windows:

open services 

restart spectrum tomcat service

 

Unix:

cd $SPECROOT/tomcat/bin

./stopTomcat.sh

./startTomcat.sh

 

If still issue persists open a case with support