Spec KB: CA Spectrum Report Manager fails to insert event into event table
Document ID: TEC617961 ShowHide Technical Document Details
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: