Hi Uchira,
If you want the number of rows from the event table, run this MySQL query:
mysql> select count(*) from event;
If you want to see the first and last event in the event table, run this MySQL query:
mysql> select from_unixtime(min(utime)) as first, from_unixtime(max(utime)) as last from event;
------------------------------
Technical Support Engineer IV
Broadcom Inc
------------------------------
Original Message:
Sent: 10-08-2020 12:12 AM
From: Uchira Amarasinghe
Subject: Spectrum Report Manager reporting database not updating
Hi Silvio
I tried to run below command
Increase the capacity of the column by changing from text to mediumtext. This will increase the max size from the current 65,535 characters to 16,777,215 for mediumtext.
from the mysql interface in the reporting db use the following command.
ALTER TABLE event MODIFY event_msg MEDIUMTEXT;
While running this command storage space is increasing. under the Spectrum/mysql/data/reporting capacity showing 521GB.
how do we check table record count? and do have any idea on this?
Thanks,
Uchira.
Original Message:
Sent: 10-01-2020 06:02 AM
From: Silvio Okamoto
Subject: Spectrum Report Manager reporting database not updating
Hi Uchira,
It is in the Cause section of the KB article.
Run: desc event;
You can also check the size of the event message based on the following error:
Sep 02, 2020 13:57:21.359 (SRM/LandscapeManager/LandscapeThread_0) (SRM_Events) - (ERROR) - event record (mh=0x10b484b, type=0x1090f, time=2020-08-11 12:58:26.0)
mh=0x10b484b
type=0x1090f
time=2020-08-11 12:58:26.0
Locate the model handle 0x10b484b, and check the event message of 0x1090f event code on 2020-08-11 at 12:58:26
------------------------------
Technical Support Engineer IV
Broadcom Inc
Original Message:
Sent: 10-01-2020 01:05 AM
From: Uchira Amarasinghe
Subject: Spectrum Report Manager reporting database not updating
How can we check below info in the current environment?
Original Message:
Sent: 09-24-2020 11:07 AM
From: Silvio Okamoto
Subject: Spectrum Report Manager reporting database not updating
Hi Uchira,
Did you review the Tomcat log file? ($SPECROOT/tomcat/logs/stdout.log (Windows) or catalina.out (Linux))
Sep 02, 2020 13:57:21.359 (SRM/LandscapeManager/LandscapeThread_0) (SRM_Events) - (ERROR) - Failed to insert event into event table. SQL Exception code: 1406 SQL Exception message: Data truncation: Data too long for column 'event_msg' at row 1 Last known event time = 1597130906000
Sep 02, 2020 13:57:21.359 (SRM/LandscapeManager/LandscapeThread_0) (SRM_Events) - (ERROR) - event record (mh=0x10b484b, type=0x1090f, time=2020-08-11 12:58:26.0)
Sep 02, 2020 13:57:22.901 (SRM/LandscapeManager/LandscapeThread_0) (SRM_Events) - (ERROR) - Database ERROR processing events for domain enms-ca-spectro-server. Will not poll domain
Have you followed this KB article?
https://knowledge.broadcom.com/external/article?articleId=8648
I see a typo in your syntax. There is a missing character ("f") in the my-spectrum.cnf file.
------------------------------
Technical Support Engineer IV
Broadcom Inc
Original Message:
Sent: 09-24-2020 03:13 AM
From: Uchira Amarasinghe
Subject: Spectrum Report Manager reporting database not updating
Hi Team,
I'm facing an issue between spectrum and Jesper report server. We cannot get a report from the spectrum and Spectrum status showing august 11th 2020. Can anyone tell me how to fix this issue? below is the more info.
Thanks,
Uchira.