MS SQL SavePos is not used

Tags: MS SQL | freetds | im_dbi

#1 Robert000

Hello, I send data from MS SQL to SysLog, i use im_dbi+freetds and even if i have set SavePos it always starts from the beginning at startup.

After starting the service 2022-02-15 11:19:32 DEBUG im_dbi sql: SELECT * FROM *** WHERE id > -1

When it is already running, the id is used. 2022-02-15 11:19:35 DEBUG im_dbi sql: SELECT * FROM *** WHERE id > 116407

-rw-r--r-- 1 nxlog nxlog 64 Feb 15 11:20 configcache.dat

OS: Ubuntu 20.04, last NXLog CE 3.0.2272

<Input sql_send> Module im_dbi SavePos TRUE PollInterval 10 Driver freetds Option host *** Option username *** Option password *** Option dbname *** SQL SELECT * FROM *** </Input>