Not able to get data using tracking_column as not found in data_set

Elastic Stack Logstash
1

Getting below

tracking_column not found in dataset. {:tracking_column=>"LOG_ID"}

Here is my JDBC Input:

jdbc {

  jdbc_driver_library => "/deploy/libs/ojdbc6-11.2.0.4.0.jar"
  jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
  jdbc_user => "user"
  jdbc_password=> "pass"
  jdbc_connection_string => "jdbc:oracle:thin:@host:port/db"
  jdbc_validate_connection => true
  schedule => "*/15 * * * * *"
  statement => "select  LOG_ID, CP_ID, SEME, STATUS,CREATED_ON, UPDATED_ON, REMARKS from log WHERE LOG_ID > :sql_last_value"
  tracking_column => "LOG_ID"
  use_column_value => true
  clean_run => true
  tracking_column_type => "numeric"
  type => "log"

  }

Please assist

2

seems re-adding worked fine

3

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