Support Questions

Find answers, ask questions, and share your expertise

Nifi 1.13.2 PutDatabaseRecord (Avro) causes conversion error when writing UniqueIdentifier column (MS SQL)

avatar
Contributor

"The conversion from UNKNOWN to CHAR is unsupported."


I'm using only 2 processors:
QueryDatabaseTable (reading UniqueIdentifier Column) >> PutDatabaseRecord (writing in the same table and column)

Table:
CREATE TABLE TableTest(
OID [uniqueidentifier] NULL,
Bit1 [bit] NULL
)

QueryDatabaseTable:

GabrielNifi_0-1626356177750.png

PutDatabaseRecord:

GabrielNifi_1-1626356233224.png

Error:

The conversion from UNKNOWN to CHAR is unsupported.

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.
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.

1 ACCEPTED SOLUTION

avatar
Contributor
1 REPLY 1

avatar
Contributor

Fixed in 1.14!!!