# Indexed records with logstash-input-jdbc not appearing in elasticsearch

**URL:** <https://discuss.elastic.co/t/indexed-records-with-logstash-input-jdbc-not-appearing-in-elasticsearch/76429>\
**Category:** Logstash\
**Created:** [February 24, 2017, 5:29pm UTC](https://discuss.elastic.co/t/indexed-records-with-logstash-input-jdbc-not-appearing-in-elasticsearch/76429 "2017-02-24T17:29:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vinuret](https://avatars.discourse-cdn.com/v4/letter/v/df705f/32.png) [@vinuret](https://discuss.elastic.co/u/vinuret)\
**Post date:** [February 24, 2017, 5:29pm UTC](https://discuss.elastic.co/t/indexed-records-with-logstash-input-jdbc-not-appearing-in-elasticsearch/76429/1 "2017-02-24T17:29:43Z")

</div>

Hi,  
I am new to elasticsearch. I am using elasticsearch version 5.2.1 . I used logstash-input-jdbc plugin to index Oracle table data into elasticsearch. The table has almost 5.5 lakhs records. After indexing is completed when I do a search, I can see only 1 record. The remaining data are missing. I did not see any specific error message in Logstash after completing the indexing. Please find below the elasticsearch output

output {  
elasticsearch {  
index =\> "poc"  
document\_type =\> "tickets"  
document\_id =\> "%{TICKET\_NUMBER}"  
hosts =\> "localhost"  
}  
}

I am able to see only one record with a specific ticket number. When I tried to search other tickets, it is giving empty data.

Can someone please guide me if I am missing anything?

Thanks in advance,  
Vinu

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [February 28, 2017, 7:07am UTC](https://discuss.elastic.co/t/indexed-records-with-logstash-input-jdbc-not-appearing-in-elasticsearch/76429/2 "2017-02-28T07:07:49Z")

</div>

Please show what the document that you do get into Elasticsearch looks like.

---

<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:** [March 28, 2017, 7:07am UTC](https://discuss.elastic.co/t/indexed-records-with-logstash-input-jdbc-not-appearing-in-elasticsearch/76429/3 "2017-03-28T07:07:56Z")

</div>

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