# \[Input jdbc plugin\] Incorrect value on "last\_run\_metadata\_path" file

**URL:** <https://discuss.elastic.co/t/input-jdbc-plugin-incorrect-value-on-last-run-metadata-path-file/154788>\
**Category:** Logstash\
**Created:** [October 31, 2018, 9:28am UTC](https://discuss.elastic.co/t/input-jdbc-plugin-incorrect-value-on-last-run-metadata-path-file/154788 "2018-10-31T09:28:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vara0855](https://avatars.discourse-cdn.com/v4/letter/v/3da27b/32.png) [@vara0855](https://discuss.elastic.co/u/vara0855)\
**Post date:** [October 31, 2018, 9:28am UTC](https://discuss.elastic.co/t/input-jdbc-plugin-incorrect-value-on-last-run-metadata-path-file/154788/1 "2018-10-31T09:28:16Z")

</div>

Logstash - v.6.3.2 OSS  
ES - v.6.3.2 OSS  
Oracle DB

Example input:

```
	jdbc {
		id => "input_jdbc"
		jdbc_driver_library => "${LOGSTASH_JDBC_DRIVER:ojdbc6.jar}"
		jdbc_driver_class => "Java::oracle.jdbc.OracleDriver"
		jdbc_connection_string => "${LOGSTASH_JDBC_CONNECTION}"
		jdbc_user => "${LOGSTASH_JDBC_USER}"
		jdbc_password => "${LOGSTASH_JDBC_PASSWORD}"
		use_column_value => true
		tracking_column => tracking_number
		last_run_metadata_path => "${LOGSTASH_METADATA_PATH}/main/last_meta"
		statement_filepath => "${LOGSTASH_JDBC_SQL_SCRIPTS_PATH}/main/sript.sql"
		schedule => "* * * * *" #run every minute
	}

```

Example statement :

`select id,name, to_number(to_char(timestamp,'YYMMDDHH24MISSFF')) as tracking_number from test_table where tracking_number > :sql_last_value order by tracking_number`

Example row from table table :

```
 id |name |timestamp
 32718938291| my_name | 30-OCT-18 10.10.00.515454000 AM -04:00

```

Actual result in _ **last\_meta** _ file:

`--- !ruby/object:BigDecimal '0:0.181029072223314735E18'`

Expected result:

`--- 181029072223314735`

Due to this data is read continuously without stopping.  
**With what it can be connected?**

---

<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:** [November 28, 2018, 9:28am UTC](https://discuss.elastic.co/t/input-jdbc-plugin-incorrect-value-on-last-run-metadata-path-file/154788/2 "2018-11-28T09:28:20Z")

</div>

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