Hello again,
Sorry for not posting the nxlog version in earlier posts.We are using
version nxlog-3.0.1845-trial.
Maybe the error is related to "." and ","? I refer to the delimiter
betweend seconds and milli seconds.
See the little difference below:
2016-09-16 08:42:45.433
2016-09-16 08:42:45,433
Maybe nxlog is not compatible with our Locale/Regional settings (Sweden)?
Can we solve it by converting to string in the configuration when exporting
from SQL Server to nxlog?
Kind regards, Erik
2017-03-02 19:06 GMT+01:00 Panagiotis Atmatzidis <a...@convalesco.org>:
> Hi Erik,
>
> On 2 Mar 2017, at 16:36, Erik Boström <erik.g.bost...@gmail.com> wrote:
>
> Thanks for you reply Panagoitis!
>
> > First thing that comes to mind is checking if timestamp used by nxlog is
> properly formatted. What happens if you run the query manually?
>
> How do you mean "manually"? We have ran the query from PowerShell
> successfully.
>
> Our NXLog configuration:
>
> <Input ODBC>
> Module im_odbc
> Connectionstring dsn=DSNNAME;database=Databasename;
> SQL Select StartTime as id, AdminId from [Databasename].[view].[view]
> Where StartTime > ?
> Savepos TRUE
> IdIsTimestamp TRUE
> </Input>
>
> AdminId is an Int datatype
> StartTime is a datetime. Example value is 2016-09-16 08:42:45.433
>
>
> Does this datetime format come from nxlog debug log?
>
> The DateTime format comes from MS SQL Server. Displayed in Editor window.
> The NXLog debug log only contains the error message "Invalid precision
> value".
>
> NXLog is successful when we change the query and use AdminId as id.
>
> Any more hints what can be wrong?
>
>
> Not sure yet. Which version of nxlog are you using?
>
> / Erik
>
> […]
>
>
>
> --
> Panagiotis (atmosx) Atmatzidis
>
> email: a...@convalesco.org
> URL: http://www.convalesco.org
> GnuPG ID: 0x1A7BFEC5
> gpg --keyserver pgp.mit.edu --recv-keys 1A7BFEC5
>
> "Everyone thinks of changing the world, but no one thinks of changing
> himself.” - Leo Tolstoy
>
>
>
>
>
>
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
nxlog-ce-users mailing list
nxlog-ce-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nxlog-ce-users
