# Tracking column failed
**URL:** https://discuss.elastic.co/t/tracking-column-failed/95905
**Category:** Logstash
**Created:** [August 4, 2017, 3:00pm UTC](https://discuss.elastic.co/t/tracking-column-failed/95905 "2017-08-04T15:00:47Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@FR-TheS](https://discuss.elastic.co/u/FR-TheS)
#### Post date: [August 4, 2017, 3:00pm UTC](https://discuss.elastic.co/t/tracking-column-failed/95905/1 "2017-08-04T15:00:47Z")
Hello,
I got an issue on the tracking column with sql server request.
The tracking column is not increment, so i'm reloading the same data always.
```
statement => "SELECT TOP 10000 *
FROM PWODecisionHistory
WHERE XDateInserted > :sql_last_value
ORDER BY XDateInserted"
use_column_value => "true"
tracking_column => "XDateInserted"
last_run_metadata_path => "C:\soft\logstash-5.4.3\inputs\.last_IAG-decisionHistory"
```
value of my file is "--- 2018-08-04 00:00:00.000000000 Z"
value in my database is something like "2017-08-04 00:01:27" (timestamp in sql server format)
How can I proceed to got only new value with the last value increment?
---
### Author:  [@FR-TheS](https://discuss.elastic.co/u/FR-TheS)
#### Post date: [August 4, 2017, 3:25pm UTC](https://discuss.elastic.co/t/tracking-column-failed/95905/2 "2017-08-04T15:25:52Z")
Resolved by my super power colleague : tracking\_column is case sensitive so in my output it was in lowercase so the match wasn’t work. After put this in lowercase, my file is updated now.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 1, 2017, 3:25pm UTC](https://discuss.elastic.co/t/tracking-column-failed/95905/3 "2017-09-01T15:25:55Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.