In Kibana dashboard, latest logs are not showing

Team,
Even though we have latest records in the table, we are not able to see these latest records in kibana dashboard, below is the logstash jdbc query for fetching latest record. But it was working properly previously. there is no trace or error or exception in elk logs as well. Kindly help me for the solving this.

jdbc {
type => "user_table_list"
jdbc_connection_string => "jdbc:oracle:thin:@//localhost:1521/orcl"
jdbc_user => "user"
jdbc_password => "user@db123"
jdbc_validate_connection => true
jdbc_driver_library => "ojdbc7-12.1.0.2.jar"
jdbc_driver_class =>"Java::oracle.jdbc.driver.OracleDriver"
schedule => "* * * * *"
statement => "select * from user_list WHERE submitted_date > :sql_last_value ORDER by submitted_date"
use_column_value => true
tracking_column => "submitted_date"
tracking_column_type => "timestamp"
last_run_metadata_path => ".logstash_jdbc_last_run_list"
}

Thanks
Shajim

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