CA Spectrum Report Manager fails to insert event into event table

book

Article ID: 17384

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

CA Spectrum Report Manager fails to insert event into event table for the ciscoLwappMfpAnomalyDetected1 (0x00210d37) 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

 

    Cause

    The Event Format file for the ciscoLwappMfpAnomalyDetected1 (0x00210d37) event is using the wrong data type to display the values for the cLApMacAddress, cLApIfSmtDot11Bssid, and cLClientLastSourceMacAddress Event Variables. The file is using the "Text String" data type but should use the "OCTET STRING" data type.

    Environment

    Release:
    Component:

    Resolution

    Use the Event Configuration tool to update the 0x00210d37 event to use the "OCTET STRING" data type for the cLApMacAddress, cLApIfSmtDot11Bssid, and cLClientLastSourceMacAddress Event Variables.

    1. Log into OneClick as an ADMIN user

    2. Select Tools -> Utilities -> Event Configuration from the top level menu

    3. In the Navigation panel filter for and select the 0x00210d37 event 

    4. In the Contents panel, update the cLApMacAddress, cLApIfSmtDot11Bssid, and cLClientLastSourceMacAddress Event Variables to use the "OCTET STRING" data type as seen below:

    cLApMacAddress = {o 1}
    cLApDot11IfSlotIdx = {U 2}
    cLApIfSmtDot11Bssid = {o 3}
    cLApIfSmtDot11Bssid.cLApSysMacAddress.cLApDot11IfSlotId = {o 4}
    cLMfpEventType = {T cLMfpEventType 5}
    cLMfpEventTotal = {U 6}
    cLMfpEventPeriod = {I 7}
    cLMfpEventFrames = {T cLMfpEventFrames 8}
    cLClientLastSourceMacAddress = {o 9}

    5. Save the changes

    6. Restart tomcat on the SRM system

    NOTE: If using multiple OneClick/SRM systems, copy the modified $SPECROOT/custom/Events/Event00210d37_en_US file from the SRM system to the $SPECROOT/custom/Events directory on all other OneClick and SRM systems in the environment. Then, restart tomcat on those systems.

    Additional Information

    Please reference the "Event Configuration" section of the documentation for more information.

    Attachments

    1558687499833000017384_sktwi1f5rjvs16fbc.gif get_app
    1558687496879000017384_sktwi1f5rjvs16fbb.gif get_app