https://community.cloudera.com/t5/Support-Questions/Nifi-1-13-2-PutDatabaseRecord-Avro-causes-conversion-error/m-p/321098#M228264 <P>Fixed in 1.14!!!<BR /><BR /><BR /></P> Fri, 16 Jul 2021 18:10:37 GMT GabrielNifi 2021-07-16T18:10:37Z https://community.cloudera.com/t5/Support-Questions/Nifi-1-13-2-PutDatabaseRecord-Avro-causes-conversion-error/m-p/320999#M228237 <P><SPAN>"The conversion from UNKNOWN to CHAR is unsupported."</SPAN></P><P><SPAN><BR />I'm using only 2 processors:<BR />QueryDatabaseTable (reading UniqueIdentifier Column) &gt;&gt; PutDatabaseRecord (writing in the same table and column)<BR /><BR />Table:<BR />CREATE TABLE TableTest(<BR />OID [uniqueidentifier] NULL,<BR />Bit1 [bit] NULL<BR />)<BR /><BR />QueryDatabaseTable:<BR /></SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="GabrielNifi_0-1626356177750.png" style="width: 400px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/31881iC4065C6345466A22/image-size/medium?v=v2&amp;px=400" role="button" title="GabrielNifi_0-1626356177750.png" alt="GabrielNifi_0-1626356177750.png" /></span></P><P>PutDatabaseRecord:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="GabrielNifi_1-1626356233224.png" style="width: 400px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/31882i430D85260488F9C8/image-size/medium?v=v2&amp;px=400" role="button" title="GabrielNifi_1-1626356233224.png" alt="GabrielNifi_1-1626356233224.png" /></span></P><P>Error:</P><DIV>The conversion from UNKNOWN to CHAR is unsupported.<BR /><BR /></DIV><P><SPAN>Supposedly, Nifi's internal array is inverting the columns, putting the bit column in place of the UniqueIdentifier column, producing this "Unknown to char" error. Bug.<BR />I tried to install Nifi 1.14 but, it keeps asking for username and password and there is no ".bat" to generate username and password, only the shell ".sh". That is, it only works on Linux.<BR /></SPAN></P> Thu, 15 Jul 2021 14:12:32 GMT https://community.cloudera.com/t5/Support-Questions/Nifi-1-13-2-PutDatabaseRecord-Avro-causes-conversion-error/m-p/320999#M228237 GabrielNifi 2021-07-15T14:12:32Z https://community.cloudera.com/t5/Support-Questions/Nifi-1-13-2-PutDatabaseRecord-Avro-causes-conversion-error/m-p/321098#M228264 <P>Fixed in 1.14!!!<BR /><BR /><BR /></P> Fri, 16 Jul 2021 18:10:37 GMT https://community.cloudera.com/t5/Support-Questions/Nifi-1-13-2-PutDatabaseRecord-Avro-causes-conversion-error/m-p/321098#M228264 GabrielNifi 2021-07-16T18:10:37Z