Flow: QueryDatabaseTable >> PutDatabaseRecord (using the same MS SQL table)   Original Date: '2020-01-01 01:00:00.000' Saved Date: '2019-12-31 22:00:00.000'   Another: Original Date: '1753-01-01 00:00:00.000' (SQL Server minimum date) Saved Date: Routing to failure.: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.   My timezone: (GMT-3)   ... View more

"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: 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. ... View more