Tools

Log to database fails on Kiwi Syslog Server

DBLogger.ClearQueue aborted with error: Database error executing SQL statement: Unclosed quotation mark after the character string. The SQL statement is failing because there is a NULL character at the end of the message.

First published date

10/29/2018 6:31 PM

Last published date

10/29/2018 6:31 PM

Overview

DBLogger.ClearQueue aborted with error: Database error executing SQL statement: Unclosed quotation mark after the character string.

Product section

Kiwi Syslog Server

Cause

The SQL statement is failing because there is a NULL character at the end of the message. The NULL is causing the insert statement to chop off so there is no closing quote.

Resolution

From Kiwi Syslog Manager, Click File > Setup > Modifiers.
Enable the following:
- Replace non printable character with <ASCII value>
- Remove CR/LF from end of messages
Restart the service and see if the issue still occurs.

Note: you might need to purge database cache from File > Purge and make sure that \Syslogd\DBCache\ is empty.

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.