CABI Reporting for a specific Spectrum Landscape is not showing data past a certain date

Products

• CA eHealth
• CA Spectrum

Issue/Introduction

• CABI reports are not getting data after November 11th.
• Spectrum Report Manager (SRM) is showing that it has data up to November 19th but there is no data past November 11th in the reports.

Cause

• Any Spectrum Server incidents which trigger a large number of events might delay what data is retrievable from SRM.

Environment

Release : 10.3

Component : Spectrum Core / SpectroSERVER

Resolution

• Depending on the size of the event buckets which have yet to be processed some data might not be available to Spectrum Report Manager.

Connect to MySQL Database on OneClick Server where Report Manager is installed:

./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting

show tables;

Check for the presence of any alarm buckets which correlate to the problematic landscape:

The alarm bucket naming convention spectrumserver landscape handle in decimal_unixtime.

An Alarm bucket containing 16777216 would have a landscape handle of 0x1000000.

select count(*) from alarmbucket16777216_1574177644883;

This query shows this alarm bucket has 45815 events which are still being processed:

select max(time) from alarmbucket16777216_1574177644883;

If you run this command a few times throughout the day and notice the (max)time is incrementing than the bucket is still being processed and this data will soon be available for CABI report generation.