# Mssql data into elasticsearch using logstash
**URL:** https://discuss.elastic.co/t/mssql-data-into-elasticsearch-using-logstash/135556
**Category:** Logstash
**Created:** [June 12, 2018, 2:22pm UTC](https://discuss.elastic.co/t/mssql-data-into-elasticsearch-using-logstash/135556 "2018-06-12T14:22:40Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Gauti](https://discuss.elastic.co/u/Gauti)
#### Post date: [June 12, 2018, 2:22pm UTC](https://discuss.elastic.co/t/mssql-data-into-elasticsearch-using-logstash/135556/1 "2018-06-12T14:22:40Z")
Hey Guys,
I have been trying to upload data from mssql database into elasticsearch using logstash.
Have succeeded with uploading some smaller table informations, when i try to upload tables like EVENTS which has around 10k records i'm getting error in the upload. here is the error information.
**[ERROR][logstash.outputs.elasticsearch] An unknown error occurred sending a bulk request to Elasticsearch. We will retry indefinitely {:error\_message=\>""\xCB" from ASCII-8BIT to UTF-8", :error\_class=\>"LogStash::Json::GeneratorError", :backtrace=\>["/usr/share/logstash/logstash-core/lib/logstash/json.rb:28:in `jruby_dump'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-output-elasticsearch-9.1.1-java/lib/logstash/outputs/elasticsearch/http_client.rb:118:in`block in bulk'", "org/jruby/RubyArray.java:2486:in `map'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-output-elasticsearch-9.1.1-java/lib/logstash/outputs/elasticsearch/http_client.rb:118:in`block in bulk'", "org/jruby/RubyArray.java:1734:in `each'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-output-elasticsearch-9.1.1-java/lib/logstash/outputs/elasticsearch/http_client.rb:116:in`bulk'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-output-elasticsearch-9.1.1-java/lib/logstash/outputs/elasticsearch/common.rb:243:in `safe_bulk'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-output-elasticsearch-9.1.1-java/lib/logstash/outputs/elasticsearch/common.rb:157:in`submit'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-output-elasticsearch-9.1.1-java/lib/logstash/outputs/elasticsearch/common.rb:125:in `retrying_submit'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-output-elasticsearch-9.1.1-java/lib/logstash/outputs/elasticsearch/common.rb:36:in`multi\_receive'", "/usr/share/logstash/logstash-core/lib/logstash/output\_delegator\_strategies/shared.rb:13:in `multi_receive'", "/usr/share/logstash/logstash-core/lib/logstash/output_delegator.rb:49:in`multi\_receive'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:477:in `block in output_batch'", "org/jruby/RubyHash.java:1343:in`each'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:476:in `output_batch'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:428:in`worker\_loop'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:386:in `block in start\_workers'"]}**
**[2018-06-12T17:43:00,192]**
Not sure what is the issue here and where to start the troubleshooting, any advice would be deeply appreciated.
Thanks
Gautham
---
### Author:  [@AurelienG](https://discuss.elastic.co/u/AurelienG)
#### Post date: [June 12, 2018, 2:31pm UTC](https://discuss.elastic.co/t/mssql-data-into-elasticsearch-using-logstash/135556/2 "2018-06-12T14:31:19Z")
According to this:
> [@Gauti](#):
>
> error\_message=\>""\xCB" from ASCII-8BIT to UTF-8"
I would say you have special characters in your database, that UTF-8 encoding doesn't recognize.
---
### Author:  [@Gauti](https://discuss.elastic.co/u/Gauti)
#### Post date: [June 12, 2018, 3:34pm UTC](https://discuss.elastic.co/t/mssql-data-into-elasticsearch-using-logstash/135556/3 "2018-06-12T15:34:38Z")
@AurelienG thanks for the response.
This database has all the details of my monitoring tool, i'm trying to get all the events generated there and create dashboards in kibana.
If it is not able to encode the special characters, is there any other way where we can proceed by skipping the special characters (OR) there is no use in continuing with this approach.
Thanks
Gautham
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 10, 2018, 3:34pm UTC](https://discuss.elastic.co/t/mssql-data-into-elasticsearch-using-logstash/135556/4 "2018-07-10T15:34:43Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.