Tracking column failed


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?

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.

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