# Logstash Oracle setup - Cannot create pipeline

**URL:** <https://discuss.elastic.co/t/logstash-oracle-setup-cannot-create-pipeline/92546>\
**Category:** Logstash\
**Created:** [July 10, 2017, 11:34pm UTC](https://discuss.elastic.co/t/logstash-oracle-setup-cannot-create-pipeline/92546 "2017-07-10T23:34:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![bhrtjoshi](https://avatars.discourse-cdn.com/v4/letter/b/7ba0ec/32.png) [@bhrtjoshi](https://discuss.elastic.co/u/bhrtjoshi)\
**Post date:** [July 10, 2017, 11:34pm UTC](https://discuss.elastic.co/t/logstash-oracle-setup-cannot-create-pipeline/92546/1 "2017-07-10T23:34:26Z")

</div>

I there, I am getting below error in the logstash logs. Can someone please help?

[2017-07-10T19:06:10,405][ERROR][logstash.agent] Cannot create pipeline {:reason=\>"Expected one of #, =\> at line 15, column 11 (byte 546) after output {\n file {\n stdout "}  
[2017-07-10T19:06:17,780][INFO][logstash.pipeline] Starting pipeline {"id"=\>"main", "pipeline.workers"=\>4, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>5, "pipeline.max\_inflight"=\>500}  
[2017-07-10T19:06:17,884][INFO][logstash.pipeline] Pipeline main started  
[2017-07-10T19:06:17,967][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}  
[2017-07-10T19:06:28,826][WARN][logstash.runner] SIGTERM received. Shutting down the agent.  
[2017-07-10T19:06:28,829][WARN][logstash.agent] stopping pipeline {:id=\>"main"}  
[2017-07-10T19:06:48,776][INFO][logstash.pipeline] Starting pipeline {"id"=\>"main", "pipeline.workers"=\>4, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>5, "pipeline.max\_inflight"=\>500}  
[2017-07-10T19:06:48,864][INFO][logstash.pipeline] Pipeline main started  
[2017-07-10T19:06:48,931][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}

Below is my config file, not sure where my query output is going?

input {  
jdbc {  
jdbc\_validate\_connection =\> true  
jdbc\_connection\_string =\> "MyConnectionString"  
jdbc\_user =\> "MyUserName"  
jdbc\_password =\> "MyPassword"  
jdbc\_driver\_library =\> "opt/jdbc/lib/ojdbc7.jar"  
jdbc\_driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver"  
statement =\> "SELECT \* FROM CUSTOMER.CUSTOMER WHERE FULL\_NAME = 'First Last'"  
schedule =\> "\*/2 \* \* \* \*"  
}  
}  
output {  
stdout { codec =\> json }  
}

---

<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:** [July 12, 2017, 3:44pm UTC](https://discuss.elastic.co/t/logstash-oracle-setup-cannot-create-pipeline/92546/2 "2017-07-12T15:44:35Z")

</div>

Somewhere in the configuration that Logstash attempts to load there's something that looks like this:

```nohighlight
output {
 file {
 stdout

```

Perhaps you have additional files in /etc/logstash/conf.d. Logstash reads _all_ files there.

---

<div class="post-metadata">

**Author:** ![bhrtjoshi](https://avatars.discourse-cdn.com/v4/letter/b/7ba0ec/32.png) [@bhrtjoshi](https://discuss.elastic.co/u/bhrtjoshi)\
**Post date:** [July 31, 2017, 4:29pm UTC](https://discuss.elastic.co/t/logstash-oracle-setup-cannot-create-pipeline/92546/3 "2017-07-31T16:29:54Z")

</div>

Thank you magnusbaeck....

---

<div class="post-metadata">

**Author:** ![bhrtjoshi](https://avatars.discourse-cdn.com/v4/letter/b/7ba0ec/32.png) [@bhrtjoshi](https://discuss.elastic.co/u/bhrtjoshi)\
**Post date:** [August 2, 2017, 3:36pm UTC](https://discuss.elastic.co/t/logstash-oracle-setup-cannot-create-pipeline/92546/4 "2017-08-02T15:36:03Z")

</div>

Thank you Magnus... I was able to get the oracle data into Kibana.

When I see the logs in Kibana, I see that few of the fields are logging junk data, not sure why. Upon checking I found that the fields with raw Oracle datatype are the ones for which junk data is being captured in Kibana.

This make reading difficult. Do you know what can be done here?

Below are some junk data which is being logged in Kibana for reference..

w:\_° ¦†PV½"  
w:\_°@¦†PV½"  
w:\_°'Ц†PV½"  
3 yßNmD«àS:  
Ý  
w:e¯ÉÀ›œPV½3œ  
w:\_°"a°¦†PV½"

This is my configuration file...

input {  
jdbc {  
jdbc\_validate\_connection =\> true  
jdbc\_connection\_string =\> "MyConnectionString"  
jdbc\_user =\> "MyUserName"  
jdbc\_password =\> "MyPassword"  
jdbc\_driver\_library =\> "opt/jdbc/lib/ojdbc7.jar"  
jdbc\_driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver"  
statement =\> "SELECT \* FROM interaction.interaction\_line"  
schedule =\> "0 0 17 \* \* \*"  
}  
}  
output {  
elasticsearch {  
hosts =\> ["MyELSServer:9200"]  
manage\_template =\> true  
index =\> "\<interaction.interaction\_line-{now/d}\>"  
}  
}

---

<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:** [August 30, 2017, 3:36pm UTC](https://discuss.elastic.co/t/logstash-oracle-setup-cannot-create-pipeline/92546/5 "2017-08-30T15:36:16Z")

</div>

Closed on August 30, 2017, 3:36pm UTC

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