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
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.