Tracking column failed

Elastic Stack Logstash
1

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?

2

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.

3

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