CA Spectrum Report Manager fails to insert event into event table

Products

• CA Spectrum
• DX NetOps

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

 

Environment

Release:
Component: Spectrum Report Manager

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.

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 = {X 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 = {X 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.

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/spectrum/22-2/managing-network/event-configuration/working-with-events-and-alarms.html

{o #} 
Inserts an object ID.

{O #} 
Inserts an octet string.

{X #} or {x #} 
Inserts an octet string that is displayed in hexadecimal format.

{S #} 
Inserts a text string.

{B #} 
Inserts a Boolean value. Zero denotes false. Any other value denotes true.

{I #} 
Inserts an integer.string that is displayed.

{L #} 
Inserts a Counter64 counter.

{U #} 
Inserts an unsigned integer or Counter64 counter.

{R #} 
Inserts a real number in the range: 10E37 to 10E37.

{H #}
Inserts a 32-bit hex number with a 0x prefix.

{K #}
Converts a DateAndTime attribute value from an octet string to a text string, and inserts the formatted text string.

{G #}
Calculates and inserts the device up time that is based on the value of the event variable (#). The value is displayed as days+hours:mins:secs.

{D #}
Used with an event variable (#), which contains an integer representing the number of seconds from 1969. Converts that value to a string that represents the date and time.