DX NetOps

Expand all | Collapse all

Spectrum Report Manager reporting database not updating

  • 1.  Spectrum Report Manager reporting database not updating

    Posted 30 days ago
    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.


  • 2.  RE: Spectrum Report Manager reporting database not updating

    Broadcom Employee
    Posted 29 days ago
    Edited by Silvio Okamoto 29 days ago

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



  • 3.  RE: Spectrum Report Manager reporting database not updating

    Posted 23 days ago
    Hi Silvio,

    Thanks for the response.

    below is the current environment landscape 


    Thanks,
    Uchira.



  • 4.  RE: Spectrum Report Manager reporting database not updating

    Posted 23 days ago
    How can we check below info in the current environment? 




  • 5.  RE: Spectrum Report Manager reporting database not updating

    Broadcom Employee
    Posted 22 days ago
    Edited by Silvio Okamoto 22 days ago
    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
    ------------------------------



  • 6.  RE: Spectrum Report Manager reporting database not updating

    Posted 16 days ago
    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.



  • 7.  RE: Spectrum Report Manager reporting database not updating

    Broadcom Employee
    Posted 15 days ago
    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
    ------------------------------



  • 8.  RE: Spectrum Report Manager reporting database not updating

    Posted 15 days ago
    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.