Spectrum Report Manager failing to update events

book

Article ID: 5700

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

The Spectrum Report Manager (SRM) is failing to update the events for the landscapes being monitored. The Last Event Time is not updating in the OneClick Administration -> Report Manager -> SPECTRUM status page for the landscapes being monitored.

Cause

Check the $SPECROOT/tomcat/logs/stdout.log (Windows) catalina.out (Linux) file for the following error message:

 

ERROR 1146 (42S02) at line 21 in file: '/app/spectrum/Install-Tools/rpmgr/sql/srmdbapi/ddl/create_v_fact_event.sql': Table 'reporting.event' doesn't exist

 

Environment

Release: a7n0c000000PBNr
Component:

Resolution

If the above error is seen, the reporting database will have to be rebuilt from scratch.

  1. Log into the system as the user that owns the Spectrum installation
  2. Shutdown all the Spectrum processes that are running; SpectroSERVER, tomcat, mysql, processd
  3. Remove the ib_logfile* and ibdata files from the $SPECROOT/mysql/data directory
  4. Remove all of the files from the $SPECROOT/mysql/data/reporting directory
  5. Restart the Spectrum processes
  6. Log into the OneClick web pages as an ADMIN user
  7. Go to the Administration -> Report Manager -> SPECTRUM status page
  8. Ensure the landscapes needed are configured for monitoring. If not, configure them for monitoring and verify the Last Event Time is updating.

If the following error is seen when trying to configure landscapes to be monitored, see knowledge document KB000029380 " Getting Error "Unable to access the SRM preferences" when trying to enable monitor option" located at https://comm.support.ca.com/kb/Getting-Error-Unable-to-access-the-SRM-preferences-when-trying-to-enable-monitor-option/KB000029380

<Please see attached file for image>

653448_1.png

Attachments

1558693135766000005700_sktwi1f5rjvs16h7h.png get_app