DX NetOps

 View Only
  • 1.  Spectrum not populate alarm event on SRM

    Posted Sep 22, 2021 04:24 PM
    Hello, All.

    My Spectrum not populate more the alarminfo table on reporting database.
    I don't no why. Only Event Table is populated.


    Anyone yet was the same problem?


  • 2.  RE: Spectrum not populate alarm event on SRM

    Broadcom Employee
    Posted Sep 23, 2021 07:04 AM

    Hi Gabriel,

    Is there any error for the SRM module in the Tomcat log file (stdout.log for Windows and catalina.out for Linux platform)?

    Thanks,

    Silvio




  • 3.  RE: Spectrum not populate alarm event on SRM

    Posted Sep 23, 2021 08:49 AM
    Yes, Silvio.

    This is the lines that show some errors:

    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '162523' for key 'PRIMARY'

    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'monOutageID' at row 1

    (SRM/AlarmHandler/bucketReader) (SRM_Alarms) - (ERROR) - Unknown exception encountered while processing name events: processing halted for all servers


    And i try run the mysqlcheck and this is the some returns on log file:

    java.sql.SQLException: Table '.\reporting\sm_monitoroutages' is marked as crashed and last (automatic?) repair failed



  • 4.  RE: Spectrum not populate alarm event on SRM

    Posted Sep 23, 2021 11:15 AM
    I repair manually some tables and now return this error on log:
    Data truncation: Out of range value for column 'monOutageID' at row 1


  • 5.  RE: Spectrum not populate alarm event on SRM

    Broadcom Employee
    Posted Sep 23, 2021 11:46 AM
    Hi Gabriel,

    It is tough to say based on the snip you provided, as we don't see the full message.
    Maybe a quick way to resolve this issue is initializing the reporting database.


  • 6.  RE: Spectrum not populate alarm event on SRM

    Posted Sep 23, 2021 01:06 PM
    In this case, i will lost all historic data, correct?


  • 7.  RE: Spectrum not populate alarm event on SRM
    Best Answer

    Posted Sep 23, 2021 02:55 PM
    Silvio,

    After repair manually all tables and restart the tomcat service the reporting database go back populate the table of Alarm Info.