# Error while sending oracle data from logstash - elastic

**URL:** <https://discuss.elastic.co/t/error-while-sending-oracle-data-from-logstash-elastic/275447>\
**Category:** Logstash\
**Created:** [June 9, 2021, 1:51pm UTC](https://discuss.elastic.co/t/error-while-sending-oracle-data-from-logstash-elastic/275447 "2021-06-09T13:51:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rahul\_Choubey](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rahul_choubey/32/90059_2.png) [@Rahul\_Choubey](https://discuss.elastic.co/u/Rahul_Choubey)\
**Post date:** [June 9, 2021, 1:51pm UTC](https://discuss.elastic.co/t/error-while-sending-oracle-data-from-logstash-elastic/275447/1 "2021-06-09T13:51:07Z")

</div>

I am facing below issue while streaming message from logstash to kiabana:

[2021-06-09T10:15:01,047][INFO][logstash.inputs.jdbc][main] (0.067667s) SELECT \* FROM GV$ACTIVE\_SESSION\_HISTORY WHERE SAMPLE\_TIME \> TIMESTAMP '2021-06-09 00:00:00.000000 +00:00'  
[2021-06-09T10:15:02,029][ERROR][logstash.outputs.elasticsearch][main] An unknown error occurred sending a bulk request to Elasticsearch (will retry indefinitely) {:message=\>""\x85" from ASCII-8BIT to UTF-8", :exception=\>LogStash::Json::GeneratorError, :backtrace=\>["path/logstash-core/lib/logstash/json.rb:43:in `jruby_dump'", "path/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.2-java/lib/logstash/outputs/elasticsearch/http_client.rb:122:in `block in bulk'", "org/jruby/RubyArray.java:2577:in `map'", "path/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.2-java/lib/logstash/outputs/elasticsearch/http_client.rb:122:in `block in bulk'", "org/jruby/RubyArray.java:1809:in `each'", "org/jruby/RubyEnumerable.java:1258:in `each\_with\_index'", "path/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.2-java/lib/logstash/outputs/elasticsearch/http\_client.rb:120:in `bulk'", "path/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.2-java/lib/logstash/plugin_mixins/elasticsearch/common.rb:287:in `safe\_bulk'", "path/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.2-java/lib/logstash/plugin\_mixins/elasticsearch/common.rb:219:in `submit'", "path/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.2-java/lib/logstash/plugin_mixins/elasticsearch/common.rb:168:in `retrying\_submit'", "path/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-11.0.2-java/lib/logstash/outputs/elasticsearch.rb:333:in `multi_receive'", "org/logstash/config/ir/compiler/OutputStrategyExt.java:143:in `multi\_receive'", "org/logstash/config/ir/compiler/AbstractOutputDelegatorExt.java:121:in `multi_receive'", "path/logstash-core/lib/logstash/java_pipeline.rb:295:in `block in start\_workers'"]}

logstash config file:

# Sample Logstash configuration for creating a simple

# Beats -\> Logstash -\> Elasticsearch pipeline.

input {  
jdbc {  
jdbc\_validate\_connection =\> true  
jdbc\_connection\_string =\> "jdbc:oracle:thin:@IP:PORT/SID"  
jdbc\_user =\> "username"  
jdbc\_password =\> "password"  
jdbc\_driver\_library =\> "path to /ojdbc7.jar"  
jdbc\_driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver"  
statement =\> "SELECT \* FROM GV$ACTIVE\_SESSION\_HISTORY WHERE SAMPLE\_TIME \> TIMESTAMP '2021-06-09 11:00:00.000000 +00:00'"  
last\_run\_metadata\_path =\> "path/logstash-oradb.lastrun"  
record\_last\_run =\> true  
schedule =\> "\*/5 \* \* \* \*"  
}  
}  
filter {  
# Set the timestamp to that of the ASH sample, not current time.  
mutate { convert =\> ["sample\_time" , "string"]}  
date { match =\> ["sample\_time", "ISO8601"]}  
# Drop "force\_matching\_signature" because its value sometimes blows the limits of the long data type  
mutate { remove\_field =\> ["force\_matching\_signature"] }  
}  
output {  
elasticsearch {  
hosts =\> ["[https://ip](https://ip):port"]  
user =\> "username"  
password =\> "password"  
cacert =\> "path to cer"  
ssl =\> true  
ssl\_certificate\_verification =\> false  
data\_stream =\> "true"  
}  
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:** [July 7, 2021, 1:51pm UTC](https://discuss.elastic.co/t/error-while-sending-oracle-data-from-logstash-elastic/275447/2 "2021-07-07T13:51:54Z")

</div>

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