# Error while inserting data from oracle db to Elasticsearch using logstash

**URL:** <https://discuss.elastic.co/t/error-while-inserting-data-from-oracle-db-to-elasticsearch-using-logstash/156026>\
**Category:** Logstash\
**Created:** [November 9, 2018, 10:51am UTC](https://discuss.elastic.co/t/error-while-inserting-data-from-oracle-db-to-elasticsearch-using-logstash/156026 "2018-11-09T10:51:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![khurana.savita](https://avatars.discourse-cdn.com/v4/letter/k/f1d935/32.png) [@khurana.savita](https://discuss.elastic.co/u/khurana.savita)\
**Post date:** [November 9, 2018, 10:51am UTC](https://discuss.elastic.co/t/error-while-inserting-data-from-oracle-db-to-elasticsearch-using-logstash/156026/1 "2018-11-09T10:51:43Z")

</div>

**Error Log**

Failed to execute action {:action=\>LogStash::PipelineAction::Create/pipeline\_id:main, :exception=\>"LogStash::ConfigurationError", :message=\>"Expected one of #, input, filter, output at line 1, column 1 (byte 1) after ", :backtrace=\>["/logstash-6.4.2/logstash-core/lib/logstash/compiler.rb:41:in `compile_imperative'", "/logstash-6.4.2/logstash-core/lib/logstash/compiler.rb:49:in`compile\_graph'", "/logstash-6.4.2/logstash-core/lib/logstash/compiler.rb:11:in `block in compile_sources'", "org/jruby/RubyArray.java:2486:in`map'", "/logstash-6.4.2/logstash-core/lib/logstash/compiler.rb:10:in `compile_sources'", "org/logstash/execution/AbstractPipelineExt.java:149:in`initialize'", "/logstash-6.4.2/logstash-core/lib/logstash/pipeline.rb:22:in `initialize'", "/logstash-6.4.2/logstash-core/lib/logstash/pipeline.rb:90:in`initialize'", "/logstash-6.4.2/logstash-core/lib/logstash/pipeline\_action/create.rb:38:in `execute'", "/logstash-6.4.2/logstash-core/lib/logstash/agent.rb:309:in`block in converge\_state'"]}

**Config File:**  
input {  
jdbc {  
jdbc\_connection\_string =\> "jdbc:oracle:thin:@192.168.4.77:1521:DBgg"  
jdbc\_user =\> "baseline"  
jdbc\_password =\> "baseline"  
jdbc\_driver\_library =\> "ojdbc7.jar"  
jdbc\_driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver"  
statement =\> "SELECT \* from ES\_TEST"  
}  
}  
output {  
elasticsearch {  
document\_id =\> "%{id}"  
document\_type =\> "test"  
index =\> "es\_test"  
codec =\> "json"  
hosts =\> ["192.168.2.22:9200"]  
}  
}

**Version:**  
Elastic Search **6.4.1**  
Logstash **6.4.2**

Please do the needful

---

<div class="post-metadata">

**Author:** ![Makra](https://avatars.discourse-cdn.com/v4/letter/m/8491ac/32.png) [@Makra](https://discuss.elastic.co/u/Makra)\
**Post date:** [November 9, 2018, 11:57am UTC](https://discuss.elastic.co/t/error-while-inserting-data-from-oracle-db-to-elasticsearch-using-logstash/156026/2 "2018-11-09T11:57:17Z")

</div>

There is a syntax error in the configuration file. Before running Logstash, check the configuration for syntax using the following command.

`$ /usr/share/logstash/bin/logstash --config.test_and_exit -f /etc/logstash/conf.d/your_conf_file.conf`

---

<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:** [December 7, 2018, 11:57am UTC](https://discuss.elastic.co/t/error-while-inserting-data-from-oracle-db-to-elasticsearch-using-logstash/156026/3 "2018-12-07T11:57:18Z")

</div>

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