CA Spectrum Report Manager stops processing on event_msg with special/unsupported characters

Document ID : KB000048116
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Spectrum Report Manager (SRM) stops processing events when it fails to insert event into the event table.

The root cause is because there is/are special/unsupported character(s) in the event_msg field.

The following error are seen in the stdout.log (Windows) or catalina.out (UNIX/Linux) file on the Spectrum Report Manager machine:

(SRM/LandscapeManager/LandscapeThread_1) (SRM_Events) - (ERROR) - Failed to insert event into event table.  SQL Exception code: 1366  SQL Exception message: Incorrect string value:
 '\xF0\x9F\x99\x8A''...' for column 'event_msg' at row 1  Last known event time = 1402444760000
(SRM/LandscapeManager/LandscapeThread_0) (SRM_Events) - (ERROR) - event record (mh=0x156492, type=0x4b6001d, time=2014-06-10 20:59:21.0)
(SRM/LandscapeManager/LandscapeThread_1)  (SRM_Events) - (ERROR) - Failed to insert event into event table.  SQLException code: 1366  SQL Exception message: Incorrect string value: 
'\xF0\xAB\x81\x93y' for column 'event_msg' at row 1  Last known event time = 1403908636000
(SRM/LandscapeManager/LandscapeThread_1) (SRM_Events) - (ERROR) - event record (mh=0x100000, type=0x10807, time=2014-06-27 17:37:16.0)
(SRM/LandscapeManager/LandscapeThread_1) (SRM_Events) - (ERROR) - Database ERROR processing events for domain .  Will not poll domain

Solution:

This issue is resolved with Spectrum debug patch Spectrum_09.03.00.D48 for Spectrum version 9.3.0 and debug patch Spectrum_09.03.00.D54 for Spectrum version 9.3.0 with hotfix patch H01.

After applying the patch, SRM will process the events, however it will replace the original event message with the following: This message had un-supported characters

To get any of the above mentioned debug patches, please contact CA Support. This same solution will be included in hotfix patch H02.