# Missing Converter handling for full class Error

**URL:** <https://discuss.elastic.co/t/missing-converter-handling-for-full-class-error/113630>\
**Category:** Logstash\
**Created:** [December 30, 2017, 9:18am UTC](https://discuss.elastic.co/t/missing-converter-handling-for-full-class-error/113630 "2017-12-30T09:18:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nickl1](https://avatars.discourse-cdn.com/v4/letter/n/3e96dc/32.png) [@nickl1](https://discuss.elastic.co/u/nickl1)\
**Post date:** [December 30, 2017, 9:18am UTC](https://discuss.elastic.co/t/missing-converter-handling-for-full-class-error/113630/1 "2017-12-30T09:18:58Z")

</div>

Hi all,

I'm trying to use the Logstash JDBC plugin to sync my Postgres database. For some reason, midway through the data transfer, I get this error:

Exception when executing JDBC query {:exception=\>#\<Sequel::DatabaseError: Java::OrgLogstash::MissingConverterException: Missing Converter handling for full class name=org.postgresql.util.PGobject, simple name=PGobject\>}

I'm not seeing any additional info for what could be happening. Any thoughts?

Thanks!  
Nick

---

<div class="post-metadata">

**Author:** ![arashilen](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/arashilen/32/26142_2.png) [@arashilen](https://discuss.elastic.co/u/arashilen)\
**Post date:** [January 2, 2018, 8:53am UTC](https://discuss.elastic.co/t/missing-converter-handling-for-full-class-error/113630/2 "2018-01-02T08:53:21Z")

</div>

Hi,  
I just encountered this issue, and it seems certain column type in your SQL cannot be well-supported, maybe you can try to simplify columns been "selected" in your SQL first to see which one is not supported.

Regards,  
Allen

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [January 2, 2018, 3:20pm UTC](https://discuss.elastic.co/t/missing-converter-handling-for-full-class-error/113630/3 "2018-01-02T15:20:42Z")

</div>

As @arashilen said, only certain types are supported. If you think about it and work back from the elasticsearch output for example, the output is serialized into JSON and JSON only supports a limited set of types - make sure that the the columns that you are reading are already a compatible type or CAST to a compatible type.

`PGobject is a class used to describe unknown types An unknown type is any type that is unknown by JDBC Standards`

---

<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:** [January 30, 2018, 3:20pm UTC](https://discuss.elastic.co/t/missing-converter-handling-for-full-class-error/113630/4 "2018-01-30T15:20:46Z")

</div>

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