# Issue Transfer Data to ElasticSearch

**URL:** <https://discuss.elastic.co/t/issue-transfer-data-to-elasticsearch/225825>\
**Category:** Logstash\
**Created:** [March 31, 2020, 9:18am UTC](https://discuss.elastic.co/t/issue-transfer-data-to-elasticsearch/225825 "2020-03-31T09:18:43Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bernard.Thoven](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bernard.thoven/32/46413_2.png) [@Bernard.Thoven](https://discuss.elastic.co/u/Bernard.Thoven)\
**Post date:** [March 31, 2020, 9:18am UTC](https://discuss.elastic.co/t/issue-transfer-data-to-elasticsearch/225825/1 "2020-03-31T09:18:43Z")

</div>

Hi,  
I'm new using ELK and i'm trying to connect logstash to oracle DB.

I try to run logstash.conf and create the index, but not all the data got send to kibana.

Any suggestion ?

Regards,  
Bernard

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 31, 2020, 9:34am UTC](https://discuss.elastic.co/t/issue-transfer-data-to-elasticsearch/225825/2 "2020-03-31T09:34:25Z")

</div>

Hi Bernard

I moved your question to #logstash.  
BTW How do you know that not all the data has been sent?

---

<div class="post-metadata">

**Author:** ![Bernard.Thoven](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bernard.thoven/32/46413_2.png) [@Bernard.Thoven](https://discuss.elastic.co/u/Bernard.Thoven)\
**Post date:** [March 31, 2020, 10:34am UTC](https://discuss.elastic.co/t/issue-transfer-data-to-elasticsearch/225825/3 "2020-03-31T10:34:36Z")

</div>

Hi David,

Because in my oracleDB the query return 33 row , and i manually count the data in logstash window there are 33 data.  
But in elasticsearch only have 30 data.

Thanks

---

<div class="post-metadata">

**Author:** ![Robo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/robo/32/38295_2.png) [@Robo](https://discuss.elastic.co/u/Robo)\
**Post date:** [March 31, 2020, 10:55am UTC](https://discuss.elastic.co/t/issue-transfer-data-to-elasticsearch/225825/4 "2020-03-31T10:55:00Z")

</div>

can you post here your logstash pipeline configuration?

---

<div class="post-metadata">

**Author:** ![Bernard.Thoven](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bernard.thoven/32/46413_2.png) [@Bernard.Thoven](https://discuss.elastic.co/u/Bernard.Thoven)\
**Post date:** [March 31, 2020, 11:09am UTC](https://discuss.elastic.co/t/issue-transfer-data-to-elasticsearch/225825/5 "2020-03-31T11:09:29Z")

</div>

You mean this ?

input{  
jdbc{  
clean\_run =\> true  
jdbc\_driver\_library =\> "D:/Elastic Stack/ojdbc8.jar"  
jdbc\_driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver"  
jdbc\_connection\_string =\> "jdbc:oracle:thin:username/passwd@hostname:port/SID"  
jdbc\_user =\> "apps"  
jdbc\_password =\> "apps"  
clean\_run =\> true  
schedule =\> "\* \* \* \* \*"  
statement =\>  
"  
select  
aia.invoice\_id ,  
aia.invoice\_num,  
aia.invoice\_amount,  
aia.invoice\_date,  
aia.invoice\_type\_lookup\_code,  
aila.item\_description,  
aila.amount  
from ap\_invoices\_all aia,  
ap\_invoice\_lines\_all aila  
where 1=1  
and to\_char(invoice\_date,'RRRR') IN ('2018')  
and aia.invoice\_id = aila.invoice\_id  
and aila.line\_type\_lookup\_code = 'ITEM'  
and aila.discarded\_flag = 'N'  
and aia.invoice\_id \> :sql\_last\_value  
order by invoice\_id  
"  
use\_column\_value =\> true  
tracking\_column =\> "invoice\_id"  
}  
}

output{  
elasticsearch {  
hosts =\> ["[http://localhost:9200](http://localhost:9200)"]  
index =\> "logstash\_oracle\_1"  
}

```
stdout{codec => rubydebug}

```

}

---

<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:** [April 28, 2020, 11:09am UTC](https://discuss.elastic.co/t/issue-transfer-data-to-elasticsearch/225825/6 "2020-04-28T11:09:31Z")

</div>

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