Sql_last_value and Tracking files are no longer updated

Elastic Stack Logstash
1

Hello all, I am using Logstash 6.5.4 and started pulling data from my SQL Server, the first 50,000 records went in fine by batches of 10,000 at a time, but after a couple of hours.. everything stopped updating, the tracking files do not change anymore and no new data is coming in... could someone telle me what is going on... here are my lines of settings..

select top 10000 * from datasource WHERE convert(datetime,LogonDate,126) > CONVERT(datetime, :sql_last_value, 126) ORDER BY logondate"
clean_run => false
schedule => "0 */1 * * * *"
use_column_value => true
record_last_run => true
tracking_column => "logondate"
tracking_column_type => "timestamp"
last_run_metadata_path => "C:\Program Files\Elasticsearch\logstash-6.5.4\Tracking\last_run_LOGIN.txt"

2

Is SQL Server case sensitive?

convert(datetime,LogonDate,126) vs ORDER BY logondate

3

No it's not, il can take lower and upper all mixed-up

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.