# Error when importing DATETIME field using sqlite plugin

**URL:** <https://discuss.elastic.co/t/error-when-importing-datetime-field-using-sqlite-plugin/90676>\
**Category:** Logstash\
**Created:** [June 23, 2017, 6:03pm UTC](https://discuss.elastic.co/t/error-when-importing-datetime-field-using-sqlite-plugin/90676 "2017-06-23T18:03:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![abham1](https://avatars.discourse-cdn.com/v4/letter/a/5fc32e/32.png) [@abham1](https://discuss.elastic.co/u/abham1)\
**Post date:** [June 23, 2017, 6:03pm UTC](https://discuss.elastic.co/t/error-when-importing-datetime-field-using-sqlite-plugin/90676/1 "2017-06-23T18:03:23Z")

</div>

I'm unable to import an SQLite db containing a DATETIME field (eg. 2017-03-22 16:04:22) into Logstash using the SQLite plugin (it worked after I modified the db and changed this field to a string). My Configuration file looks like this:

input {  
sqlite {  
path =\> "March Server 25.db"  
}  
}

output {  
elasticsearch {  
hosts =\> ["localhost:9200"]  
index =\> "datetest"  
}  
stdout{ codec =\> rubydebug}  
}

Any pointers on how to import a DATETIME field in SQLite would be greatly appreciated!

---

<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:** [June 26, 2017, 1:24pm UTC](https://discuss.elastic.co/t/error-when-importing-datetime-field-using-sqlite-plugin/90676/2 "2017-06-26T13:24:17Z")

</div>

In what way is it not working?

---

<div class="post-metadata">

**Author:** ![Mittal\_Abha](https://avatars.discourse-cdn.com/v4/letter/m/90db22/32.png) [@Mittal\_Abha](https://discuss.elastic.co/u/Mittal_Abha)\
**Post date:** [June 26, 2017, 2:31pm UTC](https://discuss.elastic.co/t/error-when-importing-datetime-field-using-sqlite-plugin/90676/3 "2017-06-26T14:31:01Z")

</div>

Magnus, I get the following error. If I remove the DATETIME field or change it to string, then the data is successfully imported

Plugin: \<LogStash::Inputs::Sqlite path=\>"dates2.db", id=\>"eac6b3b245781778a59006bd6cd50864208ef05e-1", enable\_metric=\>true, codec=\>\<LogStash::Codecs::Plain id=\>"plain\_c3d7a65b-4bf9-4e6e-b8f9-d4d6b804883a", enable\_metric=\>true, charset=\>"UTF-8"\>, batch=\>5\>  
Error: Missing Valuefier handling for full class name=org.jruby.RubyObject, simple name=RubyObject  
[2017-06-26T09:46:20,397][ERROR][logstash.pipeline] A plugin had an unrecoverable error. Will restart this plugin.

---

<div class="post-metadata">

**Author:** ![And](https://avatars.discourse-cdn.com/v4/letter/a/2acd7d/32.png) [@And](https://discuss.elastic.co/u/And)\
**Post date:** [July 8, 2017, 12:54pm UTC](https://discuss.elastic.co/t/error-when-importing-datetime-field-using-sqlite-plugin/90676/4 "2017-07-08T12:54:27Z")

</div>

Did you try "sqlite-jdbc" recipe?

---

<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 5, 2017, 12:56pm UTC](https://discuss.elastic.co/t/error-when-importing-datetime-field-using-sqlite-plugin/90676/5 "2017-08-05T12:56:22Z")

</div>

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