# Logstash error to finding tracking\_column in jdbc input for mongodb

**URL:** <https://discuss.elastic.co/t/logstash-error-to-finding-tracking-column-in-jdbc-input-for-mongodb/283329>\
**Category:** Logstash\
**Created:** [September 4, 2021, 6:10am UTC](https://discuss.elastic.co/t/logstash-error-to-finding-tracking-column-in-jdbc-input-for-mongodb/283329 "2021-09-04T06:10:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![e-fo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/e-fo/32/87474_2.png) [@e-fo](https://discuss.elastic.co/u/e-fo)\
**Post date:** [September 4, 2021, 6:10am UTC](https://discuss.elastic.co/t/logstash-error-to-finding-tracking-column-in-jdbc-input-for-mongodb/283329/1 "2021-09-04T06:10:20Z")

</div>

Hello,  
I using logstash jdbc for pulling data from mongodb and pushing to elasticsearch. I using this pipeline configuration for logstash:

```auto
input {
  jdbc {
    type => "bb_purchaselog"
    jdbc_driver_library => "/usr/share/logstash/logstash-core/lib/jars/mongojdbc3.1.jar"
    jdbc_driver_class => "com.dbschema.MongoJdbcDriver"
    jdbc_connection_string => "jdbc connection string"
    jdbc_user => dbuser
    jdbc_password => "pass"
# jdbc_paging_enabled => true
# tracking_column => "transaction_time"
    last_run_metadata_path => "/usr/share/logstash/lastrun/bb-purchaselog-lastrun.yml"
# use_column_value => true
# tracking_column_type => "numeric"
    schedule => "1 */1 * * * *"
    statement_filepath => "/usr/share/logstash/query/bb-purchaselog.js"
  }
  .
  .
  .
}

```

My configuration works correctly but when I enabling tracking\_column and use\_column\_value features, logstash jdbc returns some error about "can't finding tracking\_column value"

I have three question:

1. can I using tracking\_column and use\_column\_value feature in jdbc input plugin when I using mongojdbc3.1.jar?

2. If I can't using these two features, is there way to set :sql\_last\_value value in input or filter stage in logstash config?

3. If we havn't any solution for two above questions, can you describing any risks about data loss when we not using use\_column\_value feature?

Thanks for any help.

---

<div class="post-metadata">

**Author:** ![e-fo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/e-fo/32/87474_2.png) [@e-fo](https://discuss.elastic.co/u/e-fo)\
**Post date:** [September 12, 2021, 9:35am UTC](https://discuss.elastic.co/t/logstash-error-to-finding-tracking-column-in-jdbc-input-for-mongodb/283329/2 "2021-09-12T09:35:44Z")

</div>

Any response? ☹

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 10, 2021, 9:36am UTC](https://discuss.elastic.co/t/logstash-error-to-finding-tracking-column-in-jdbc-input-for-mongodb/283329/3 "2021-10-10T09:36:35Z")

</div>

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