Release : 10.3
Component : Spectrum Core / SpectroSERVER
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.