- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Nifi 1.13.2 PutDatabaseRecord (Avro) causes conversion error when writing UniqueIdentifier column (MS SQL)
- Labels:
-
Apache NiFi
Created ‎07-15-2021 07:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
"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:
PutDatabaseRecord:
Error:
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.
Created ‎07-16-2021 11:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Fixed in 1.14!!!
Created ‎07-16-2021 11:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Fixed in 1.14!!!
