# Unable to perform incremental load

**URL:** <https://discuss.elastic.co/t/unable-to-perform-incremental-load/134230>\
**Category:** Logstash\
**Created:** [June 1, 2018, 1:17pm UTC](https://discuss.elastic.co/t/unable-to-perform-incremental-load/134230 "2018-06-01T13:17:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Deepak\_Dandotiya](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/deepak_dandotiya/32/31843_2.png) [@Deepak\_Dandotiya](https://discuss.elastic.co/u/Deepak_Dandotiya)\
**Post date:** [June 1, 2018, 1:17pm UTC](https://discuss.elastic.co/t/unable-to-perform-incremental-load/134230/1 "2018-06-01T13:17:25Z")

</div>

Hello,

I am new to elasticsearch and logstash.

Now I am running below emp-index-logstash.conf file using logstash to perform the incremental load using \<./logstash -f /data/deepak/logstash-6.2.4/bin/emp-index-logstash.conf\> but getting below error:-

Exception when executing JDBC query {:exception=\>#\<Sequel::DatabaseError: Java::JavaSql::SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected TIMESTAMP got NUMBER

below is the content of config file:-

input {

```
jdbc {

    jdbc_connection_string => "jdbc:oracle:thin:@//localhost:1521/ORCL"

    jdbc_user => "username"

    jdbc_password => "password"

    jdbc_validate_connection => true

    jdbc_driver_library => "/data/deepak/ojdbc6.jar"

    jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"

    schedule => "*/1 * * * *" #every 3 hours

    statement => 'SELECT empno,ename,job,mgr,hiredate,sal,comm,deptno FROM emp where hiredate >:sql_last_value ORDER BY hiredate ASC'

	use_column_value => true
	
	tracking_column => hiredate
	
	last_run_metadata_path => "metadata/logstash_jdbc_last_run_emp"

}

```

}

output {

```
elasticsearch {

    index => "employee"

    document_type => "emp_data"

    document_id => "%{empno}"

    hosts => ["12.55.95.07:17001"]

}
    stdout{

            codec=>rubydebug

    }

```

}

Below is the data from metadata file:-  
[deepak@hostname metadata]# vi logstash\_jdbc\_last\_run\_emp  
0

Could you please help me out as i have to implement the same approach to my project

---

<div class="post-metadata">

**Author:** ![Wayne\_Taylor](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wayne_taylor/32/45984_2.png) [@Wayne\_Taylor](https://discuss.elastic.co/u/Wayne_Taylor)\
**Post date:** [June 1, 2018, 1:29pm UTC](https://discuss.elastic.co/t/unable-to-perform-incremental-load/134230/2 "2018-06-01T13:29:05Z")

</div>

I'll dig out a working oracle config when in office

---

<div class="post-metadata">

**Author:** ![Wayne\_Taylor](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wayne_taylor/32/45984_2.png) [@Wayne\_Taylor](https://discuss.elastic.co/u/Wayne_Taylor)\
**Post date:** [June 1, 2018, 3:52pm UTC](https://discuss.elastic.co/t/unable-to-perform-incremental-load/134230/3 "2018-06-01T15:52:54Z")

</div>

```
input {
    jdbc {
        jdbc_connection_string => "jdbc:oracle:thin:@//endpoint:1521/service"
                jdbc_user => "user"
                jdbc_password => "password"
                jdbc_driver_library => "/opt/logstash-5.3.0/bin/ojdbc8.jar"
                jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
                statement =>

"select customer_id, user_name, email_address, last_login from customer where last_login > cast(:sql_last_value as timestamp)"

		record_last_run => true
		last_run_metadata_path => "/opt/logstash-5.3.0/bin/customerlogins.txt"
    }
}

output {

	elasticsearch {
	hosts => "url"
	index => "myindex"
	user => "elastic"
	password => "mypassword"
	}

}
```

---

<div class="post-metadata">

**Author:** ![Deepak\_Dandotiya](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/deepak_dandotiya/32/31843_2.png) [@Deepak\_Dandotiya](https://discuss.elastic.co/u/Deepak_Dandotiya)\
**Post date:** [June 7, 2018, 11:06am UTC](https://discuss.elastic.co/t/unable-to-perform-incremental-load/134230/4 "2018-06-07T11:06:56Z")

</div>

Thanks for your help Wayne!!!

---

<div class="post-metadata">

**Author:** ![Wayne\_Taylor](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wayne_taylor/32/45984_2.png) [@Wayne\_Taylor](https://discuss.elastic.co/u/Wayne_Taylor)\
**Post date:** [June 7, 2018, 11:20am UTC](https://discuss.elastic.co/t/unable-to-perform-incremental-load/134230/5 "2018-06-07T11:20:00Z")

</div>

Welcome, hope it worked out for you

---

<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:** [July 5, 2018, 11:20am UTC](https://discuss.elastic.co/t/unable-to-perform-incremental-load/134230/6 "2018-07-05T11:20:01Z")

</div>

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