# Unable to create the Index while using JDBC Plugin
**URL:** https://discuss.elastic.co/t/unable-to-create-the-index-while-using-jdbc-plugin/77779
**Category:** Logstash
**Created:** [March 8, 2017, 7:24am UTC](https://discuss.elastic.co/t/unable-to-create-the-index-while-using-jdbc-plugin/77779 "2017-03-08T07:24:59Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Thangaraj\_Muruganant](https://discuss.elastic.co/u/Thangaraj_Muruganant)
#### Post date: [March 8, 2017, 7:24am UTC](https://discuss.elastic.co/t/unable-to-create-the-index-while-using-jdbc-plugin/77779/1 "2017-03-08T07:24:59Z")
I am facing an Issue in Creating an Index. Meanwhile i was trying to achieve Incremental Load. here i have attached my config file. Here is my config file and the the issue displaying in cmd log,
in cmd log,
`12:37:31.638 [[main]-pipeline-manager] INFO logstash.outputs.elasticsearch - Ne w Elasticsearch output {:class=>"LogStash::Outputs::ElasticSearch", :hosts=>[#]} 12:37:31.641 [[main]-pipeline-manager] INFO logstash.pipeline - Starting pipeli ne {"id"=>"main", "pipeline.workers"=>4, "pipeline.batch.size"=>125, "pipeline.b atch.delay"=>5, "pipeline.max_inflight"=>500} 12:37:31.645 [[main]-pipeline-manager] INFO logstash.pipeline - Pipeline main s tarted 12:37:31.709 [Api Webserver] INFO logstash.agent - Successfully started Logstas h API endpoint {:port=>9600} 12:38:00.308 [Ruby-0-Thread-18: D:/elk/logstash-5.2.1/vendor/bundle/jruby/1.9/ge ms/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:283] INFO logstash.inputs. jdbc - (0.022000s) SELECT * FROM (SELECT count(*) "COUNT" FROM (select * from aw spoc.new_segm where tdate > TIMESTAMP '2017-03-08 06:53:00.142000 +00:00') "T1") "T1" WHERE (ROWNUM <= 1) 12:39:00.027 [Ruby-0-Thread-18: D:/elk/logstash-5.2.1/vendor/bundle/jruby/1.9/ge ms/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:283] INFO logstash.inputs. jdbc - (0.002000s) SELECT * FROM (SELECT count(*) "COUNT" FROM (select * from aw spoc.new_segm where tdate > TIMESTAMP '2017-03-08 06:53:00.142000 +00:00') "T1") "T1" WHERE (ROWNUM <= 1) 12:40:00.106 [Ruby-0-Thread-18: D:/elk/logstash-5.2.1/vendor/bundle/jruby/1.9/ge ms/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:283] INFO logstash.inputs. jdbc - (0.001000s) SELECT * FROM (SELECT count(*) "COUNT" FROM (select * from aw spoc.new_segm where tdate > TIMESTAMP '2017-03-08 06:53:00.142000 +00:00') "T1") "T1" WHERE (ROWNUM <= 1) 12:41:00.197 [Ruby-0-Thread-18: D:/elk/logstash-5.2.1/vendor/bundle/jruby/1.9/ge ms/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:283] INFO logstash.inputs. jdbc - (0.001000s) SELECT * FROM (SELECT count(*) "COUNT" FROM (select * from aw spoc.new_segm where tdate > TIMESTAMP '2017-03-08 06:53:00.142000 +00:00') "T1") "T1" WHERE (ROWNUM <= 1) 12:42:00.294 [Ruby-0-Thread-18: D:/elk/logstash-5.2.1/vendor/bundle/jruby/1.9/ge ms/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:283] INFO logstash.inputs. jdbc - (0.002000s) SELECT * FROM (SELECT count(*) "COUNT" FROM (select * from aw spoc.new_segm where tdate > TIMESTAMP '2017-03-08 06:53:00.142000 +00:00') "T1") "T1" WHERE (ROWNUM <= 1) 12:43:00.060 [Ruby-0-Thread-18: D:/elk/logstash-5.2.1/vendor/bundle/jruby/1.9/ge ms/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:283] INFO logstash.inputs. jdbc - (0.001000s) SELECT * FROM (SELECT count(*) "COUNT" FROM (select * from aw spoc.new_segm where tdate > TIMESTAMP '2017-03-08 06:53:00.142000 +00:00') "T1") "T1" WHERE (ROWNUM <= 1)`
This is how it keeps on pinging, I cant even check whether the data has been loaded into logstash or not. If only the Index gets Created, I can able to check the data using Elasticsearch.
Though I have already mentioned it, I couldn't find any solution to fix this. Please suggest me a solution so that I can proceed further.
Thanks in Advance.
---
### Author:  [@Thangaraj\_Muruganant](https://discuss.elastic.co/u/Thangaraj_Muruganant)
#### Post date: [March 9, 2017, 6:57am UTC](https://discuss.elastic.co/t/unable-to-create-the-index-while-using-jdbc-plugin/77779/2 "2017-03-09T06:57:53Z")
is there any one who can fix / work on it? thank you in advance 🙂
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 6, 2017, 6:58am UTC](https://discuss.elastic.co/t/unable-to-create-the-index-while-using-jdbc-plugin/77779/3 "2017-04-06T06:58:15Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.