Random white space characters appearing in the output of a log message


I am using NXLog EE with the im_odbc module to read application logs from an SQL database table.

After writing these logs to a file or forwarding them to a SIEM I seem to see random white space characters in various fields. Is there anyway possible where I can "cut out" this white space so it no longer appears in the log?

For example, in the below there is white space in the USERID field after sa. Example log here:

AskedJanuary 6, 2022 - 1:11pm

im_odbc query Orcale 12g sys.aud$ table

Hello, I'm trying to query the oracle sys.aud$ table using the nxlog odbc input module (Oracle for new audit-events.
I'm using NXlog and the odbc module 4.3.4308. The Error that NXLog is presenting me is:
ERROR SQLDescribeParam returned zero parameter_size or decimal_digit(999, 0)
I'm querying the table as follows:

AskedOctober 2, 2019 - 6:14pm

im_odbc - incorrect syntax and ERROR id column not found or its type is unsupported


I hope someone can help me. I need to pick application logs from a few MSSQL database tables. 3 of 4 works perfect -there are no issues getting the data, but one table is causing issues.

Below you can see input I am using. As you can see, there is one column name with the Danish character, however, I am not sure if only this is causing trouble. The error I receive is:

AskedApril 9, 2019 - 11:11am

NXLog and ODBC

Hi ,

Trying to create an ODBC connect for NXLog to connect to.   NXLog is installed on the same Windows 2012 server as the SQL Server 2008R2 instance.


Scenario 1:

32-bit ODBC is setup as a System DSN with a SQL Server account that has DBO access to the desired database

NXLog service is setup to run under the System account.   


- I've tried both drivers available on the system ("SQL Server Native Client 10.0"  and "SQL Server")

AskedOctober 11, 2017 - 9:54pm