# Sql\_last\_value and Tracking files are no longer updated

**URL:** https://discuss.elastic.co/t/sql-last-value-and-tracking-files-are-no-longer-updated/169208
**Category:** Logstash
**Created:** [February 20, 2019, 12:21pm UTC](https://discuss.elastic.co/t/sql-last-value-and-tracking-files-are-no-longer-updated/169208 "2019-02-20T12:21:19Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Roger\_Lavoie](https://avatars.discourse-cdn.com/v4/letter/r/9e8a1a/32.png) [@Roger\_Lavoie](https://discuss.elastic.co/u/Roger_Lavoie)
#### Post date: [February 20, 2019, 12:21pm UTC](https://discuss.elastic.co/t/sql-last-value-and-tracking-files-are-no-longer-updated/169208/1 "2019-02-20T12:21:19Z")

</div>

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"

---

<div class="post-metadata">

### Author: ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)
#### Post date: [February 20, 2019, 2:37pm UTC](https://discuss.elastic.co/t/sql-last-value-and-tracking-files-are-no-longer-updated/169208/2 "2019-02-20T14:37:51Z")

</div>

Is SQL Server case sensitive?

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

---

<div class="post-metadata">

### Author: ![Roger\_Lavoie](https://avatars.discourse-cdn.com/v4/letter/r/9e8a1a/32.png) [@Roger\_Lavoie](https://discuss.elastic.co/u/Roger_Lavoie)
#### Post date: [February 20, 2019, 3:30pm UTC](https://discuss.elastic.co/t/sql-last-value-and-tracking-files-are-no-longer-updated/169208/3 "2019-02-20T15:30:06Z")

</div>

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

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 20, 2019, 3:30pm UTC](https://discuss.elastic.co/t/sql-last-value-and-tracking-files-are-no-longer-updated/169208/4 "2019-03-20T15:30:10Z")

</div>

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