Spectrum Report Manager reporting database not updating

[Uchira Amarasinghe]

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.

[Silvio Okamoto]

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.

This is the correct syntax:
./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting -A

------------------------------
Technical Support Engineer IV
Broadcom Inc
------------------------------

[Uchira Amarasinghe]

Hi Silvio,

Thanks for the response.

below is the current environment landscape 

Thanks,
Uchira.

[Uchira Amarasinghe]

How can we check below info in the current environment? 

[Silvio Okamoto]

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
------------------------------

[Uchira Amarasinghe]

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.

[Silvio Okamoto]

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
------------------------------

[Uchira Amarasinghe]

Hi Silvio,

Thanks for the response,

As per the example, how do we check record count in the current environment?

And do you have any idea about below?

While running this command storage space is increasing. under the Spectrum/mysql/data/reporting  capacity showing 521GB.

Thanks,
Uchira.