# Error while injecting data from sqlite3 database

**URL:** <https://discuss.elastic.co/t/error-while-injecting-data-from-sqlite3-database/240509>\
**Category:** Logstash\
**Created:** [July 9, 2020, 10:42am UTC](https://discuss.elastic.co/t/error-while-injecting-data-from-sqlite3-database/240509 "2020-07-09T10:42:05Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vikash\_Singh1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikash_singh1/32/42119_2.png) [@Vikash\_Singh1](https://discuss.elastic.co/u/Vikash_Singh1)\
**Post date:** [July 9, 2020, 10:42am UTC](https://discuss.elastic.co/t/error-while-injecting-data-from-sqlite3-database/240509/1 "2020-07-09T10:42:05Z")

</div>

Hi  
I am trying to create index for sqlite3 database but I am getting error saying

````auto
Pipeline_id:main
Plugin: <LogStash::Inputs::Sqlite path=>"/home/kagamee/liveshield/api-sqlite/Yogesh/SimpleSocketIO/db/networkdata.db", id=>"c46d1a331470c1776c51a4622fe08bc2a6b6ab59f5bd4face2a0bb0e83b5cb3b", enable_metric=>true, codec=><LogStash::Codecs::Plain id=>"plain_d5107a01-7507-48f4-9ba0-54919f96af0b", enable_metric=>true, charset=>"UTF-8">, batch=>5>
Error: Missing Converter handling for full class name=org.jruby.gen.RubyObject30, simple name=RubyObject30```
My conf file looks like:
 ```input {
 sqlite {
 path=> "home//db/networkdata.db"
 }
 }
output {
 stdout {
 codec => rubydebug
 }
 }```
I've already installed sqlite3 plugin still unable to solve the error.

Thanks in Advance
````

---

<div class="post-metadata">

**Author:** ![Jenni](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jenni/32/29684_2.png) [@Jenni](https://discuss.elastic.co/u/Jenni)\
**Post date:** [July 9, 2020, 10:55am UTC](https://discuss.elastic.co/t/error-while-injecting-data-from-sqlite3-database/240509/2 "2020-07-09T10:55:20Z")

</div>

”Missing Converter‟ usually means that you are trying to load a database column with a datatype that is not supported, Logstash doesn't know how to represent the data with a Logstash data type.

---

<div class="post-metadata">

**Author:** ![Vikash\_Singh1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikash_singh1/32/42119_2.png) [@Vikash\_Singh1](https://discuss.elastic.co/u/Vikash_Singh1)\
**Post date:** [July 9, 2020, 11:02am UTC](https://discuss.elastic.co/t/error-while-injecting-data-from-sqlite3-database/240509/3 "2020-07-09T11:02:40Z")

</div>

But the fields in my database are only integers and characters

---

<div class="post-metadata">

**Author:** ![Vikash\_Singh1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikash_singh1/32/42119_2.png) [@Vikash\_Singh1](https://discuss.elastic.co/u/Vikash_Singh1)\
**Post date:** [July 9, 2020, 11:05am UTC](https://discuss.elastic.co/t/error-while-injecting-data-from-sqlite3-database/240509/4 "2020-07-09T11:05:40Z")

</div>

Even if there are some fields which might not be able to converted can I use mutate to change there data types them?

---

<div class="post-metadata">

**Author:** ![Jenni](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jenni/32/29684_2.png) [@Jenni](https://discuss.elastic.co/u/Jenni)\
**Post date:** [July 9, 2020, 11:12am UTC](https://discuss.elastic.co/t/error-while-injecting-data-from-sqlite3-database/240509/5 "2020-07-09T11:12:42Z")

</div>

If that error occurs within the input plugin you don't ever get an object with a field that you could convert because the code that would create your event object crashes. It seems like you are not alone, but I could not find a solution:

> <https://github.com/logstash-plugins/logstash-input-sqlite/issues/12>
>
> Version: 7.3
> Operating System: OSX
> Steps to Reproduce:
> % sqlite /tmp/example.db
> sqlite\> CREATE TABLE weblogs (
> id INTEGER PRIMARY KEY AUTOINCREMENT,
> ip STRING,
> ...

---

<div class="post-metadata">

**Author:** ![Vikash\_Singh1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikash_singh1/32/42119_2.png) [@Vikash\_Singh1](https://discuss.elastic.co/u/Vikash_Singh1)\
**Post date:** [July 9, 2020, 11:19am UTC](https://discuss.elastic.co/t/error-while-injecting-data-from-sqlite3-database/240509/6 "2020-07-09T11:19:55Z")

</div>

Even though I tried with the example given on "[https://www.elastic.co/guide/en/logstash/current/plugins-inputs-sqlite.html](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-sqlite.html)" but getting the same error.

---

<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 6, 2020, 11:20am UTC](https://discuss.elastic.co/t/error-while-injecting-data-from-sqlite3-database/240509/7 "2020-08-06T11:20:00Z")

</div>

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