CA Spectrum Report Manager fails to insert event into event table

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.