https://community.cloudera.com/t5/Support-Questions/A-problem-with-convert-to-Avro-in-QuaryDatabaseTable-Nifi/m-p/319550#M227874 <P>Hello everyone,<BR />My NIFI pipeline gets data from DB2 using QuaryDatabaseTable processor. When I launch it get exception (org.apache.nifi.processor.exception.ProcessException: Error during database query or conversation of record. I found out that the problem with some char in a table's field. I see this in the nifi log (nifi-app.log) and I see there that it falls with an exception java.nio.charset.UnmappableCharsetException: Input length = 1.<BR />What I tried. I used another JDBC connection driver. I tried to set UTF8 in bootstrap.conf and nifi-env.sh (I found this tip here). It has not helped.&nbsp;<BR />Could you help me, please?</P><P>&nbsp;</P> Wed, 30 Jun 2021 06:28:36 GMT AndreyDM 2021-06-30T06:28:36Z https://community.cloudera.com/t5/Support-Questions/A-problem-with-convert-to-Avro-in-QuaryDatabaseTable-Nifi/m-p/319550#M227874 <P>Hello everyone,<BR />My NIFI pipeline gets data from DB2 using QuaryDatabaseTable processor. When I launch it get exception (org.apache.nifi.processor.exception.ProcessException: Error during database query or conversation of record. I found out that the problem with some char in a table's field. I see this in the nifi log (nifi-app.log) and I see there that it falls with an exception java.nio.charset.UnmappableCharsetException: Input length = 1.<BR />What I tried. I used another JDBC connection driver. I tried to set UTF8 in bootstrap.conf and nifi-env.sh (I found this tip here). It has not helped.&nbsp;<BR />Could you help me, please?</P><P>&nbsp;</P> Wed, 30 Jun 2021 06:28:36 GMT https://community.cloudera.com/t5/Support-Questions/A-problem-with-convert-to-Avro-in-QuaryDatabaseTable-Nifi/m-p/319550#M227874 AndreyDM 2021-06-30T06:28:36Z https://community.cloudera.com/t5/Support-Questions/A-problem-with-convert-to-Avro-in-QuaryDatabaseTable-Nifi/m-p/319648#M227913 <P>Sorry, I forgot to specify the NiFi version. We use 1.11.4</P> Thu, 01 Jul 2021 11:29:14 GMT https://community.cloudera.com/t5/Support-Questions/A-problem-with-convert-to-Avro-in-QuaryDatabaseTable-Nifi/m-p/319648#M227913 AndreyDM 2021-07-01T11:29:14Z https://community.cloudera.com/t5/Support-Questions/A-problem-with-convert-to-Avro-in-QuaryDatabaseTable-Nifi/m-p/319865#M228002 <P>Seems like db2 is using some data type which is not recognizable to Avro. You can try to Disable Avro logical types to false in QueryDatabaseTable and then parse the data correctly within the flow.</P><P>&nbsp;</P><P>If you find the answer helpful please accept this as a solution.</P> Mon, 05 Jul 2021 12:14:02 GMT https://community.cloudera.com/t5/Support-Questions/A-problem-with-convert-to-Avro-in-QuaryDatabaseTable-Nifi/m-p/319865#M228002 SagarKanani 2021-07-05T12:14:02Z https://community.cloudera.com/t5/Support-Questions/A-problem-with-convert-to-Avro-in-QuaryDatabaseTable-Nifi/m-p/319931#M228040 <P>Thank you for your answer.<BR />Yes, sure I tried this option. I know exactly which field is causing the problem. I even know the symbol. The field has char type. I tried to apply UTF-8, but it didn't help</P> Tue, 06 Jul 2021 09:22:16 GMT https://community.cloudera.com/t5/Support-Questions/A-problem-with-convert-to-Avro-in-QuaryDatabaseTable-Nifi/m-p/319931#M228040 AndreyDM 2021-07-06T09:22:16Z https://community.cloudera.com/t5/Support-Questions/A-problem-with-convert-to-Avro-in-QuaryDatabaseTable-Nifi/m-p/320890#M228209 <P>Is it possible to show what the character is exactly? With logical type string it should accept any character as long as is it not a invalid or garbage value....</P> Wed, 14 Jul 2021 07:36:18 GMT https://community.cloudera.com/t5/Support-Questions/A-problem-with-convert-to-Avro-in-QuaryDatabaseTable-Nifi/m-p/320890#M228209 SagarKanani 2021-07-14T07:36:18Z