Sysload Monitor: event cannot be written "Could not insert into event table"

Products

• CA Automic Sysload

Issue/Introduction

In Sysload Monitor,  URL Scan Monitor Tasks fails to generate an Event when it fails because the the URL is too long.

In the web page/ sysload log we have the following kind of error:

Could not insert event into database (rc=-1). Could not insert into event table. Query error. Data too long for column 'EVMESSAGE' at row 1 (INSERT INTO SPM_EVENTS_DATA( EVGUID, EVTYPE, EVSTATUS, EVSEVERITY, EVDATE, EVTIME, EVDATETIME, EVSOURCE, EVMESSAGE, EVCOMMENTS ) VALUES

Environment

Sysload Monitor 6.0

Cause

The issue is due to the EVSOURCE that is limited to 255 chars.

Resolution

In order to test long URLs, the field "'Output Resource Name" should be filled, for example adding the first 15 characters of the URL, this is the value that will be used instead of the URL in the field EVSOURCE when inserting the Event in the Database.

This will allow the Event to be created.

Additional Information

More information in the Sysload Monitor Documentation:

https://docs.automic.com/documentation/webhelp/english/ALL/components/SYS/6.0/Monitor%20Guide/help.htm#Sysload_6.0_Admin_Guide/Monitors.htm%3FTocPath%3DSysload%2520Monitor%2520Administrator%2520Guide%2520-%2520v6.0%7C_____9