Tools

Messages are truncating at 255 characters in MSSQL database

Resolve issue where messages become truncated at 255 characters in MSSQL database.

First published date

10/29/2018 6:34 PM

Last published date

10/29/2018 6:34 PM

Overview

Truncating messages at 255 characters in MSSQL database.

Product section

Kiwi Syslog Server

Cause

When messages are logged to SQL database and exceed 255 characters, Microsoft SQL Query Anaylzer, when used, does not properly view the table data.

Resolution

In Kiwi Syslog Daemon, when logging syslog messages to an MS SQL database, the msgtext field is created with a field length of 1024 by default.

You will need to adjust the default settings of this application. Do this by going to the Tools | Options menu of the SQL Query Analyzer, press Results tab to find a setting that relates to the maximum number of characters per column. This column setting by default, is set to 256 character

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.