DX NetOps

Spec KB: CA Spectrum Report Manager fails to insert event into event table

  • 1.  Spec KB: CA Spectrum Report Manager fails to insert event into event table

    Posted 06-24-2015 01:01 PM

    Spec KB: CA Spectrum Report Manager fails to insert event into event table

    Document ID:  TEC617961

    ShowHide Technical Document Details

    • Products
      • CA Spectrum
    • Releases
      • CA Spectrum:Release:9.3
    • Components
      • ALARM
      • REPORTING

    Description:

    Spectrum Report Manager (SRM) stops processing events after a failure to insert event into event table.

    The root cause is because there are garbage/junk characters in the ciscoLwappMfpAnomalyDetected1 (0x210d37) event.

    The following errors are seen in the stdout.log (Windows) or catalina.out (UNIX/Linux) file on the Spectrum Report Manager machine:

    (SRM/LandscapeManager/LandscapeThread_0) (SRM_Events) - (ERROR) - Failed to insert event into event table. SQL Exception code: 1366 SQL Exception message: Incorrect string value: '\xF1\x93\xBF\x91' for column 'event_msg' at row 1 Last known event time = 1403941996000
    (SRM/LandscapeManager/LandscapeThread_0) (SRM_Events) - (ERROR) - event record (mh=0x13e8ca, type=0x210d37, time=2014-06-28 04:53:17.0)
    (SRM/LandscapeManager/LandscapeThread_0) (SRM_Events) - (ERROR) - Database ERROR processing events for domain spectrum1. Will not poll domain


    Please select the following link for more information on this subject:


    Knowledge Document Link:


    http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec617961.aspx