question Records not inserted in Character datatype put database record in Support Questions

Records not inserted in Character datatype put database record

Chakkara — Sat, 30 Oct 2021 11:12:32 GMT

I got an error invalid conversion requested in put database record processor while reading the data from file and loading into table.

I observed one of the table field datatype created as char. When I modify it to varchar datatype I can able to load data using PutDatabaseRecord processor.

Nifi version I am using is 1.13.2 . Kindly advise me how to load char datatype values via nifi without altering table.

Re: Records not inserted in Character datatype put database record

ashinde — Mon, 01 Nov 2021 15:33:32 GMT

@Chakkara The behavior you are seeing is looking similar to NIFI-8470 . A quick fix for the issue on NiFi-1.13 is to alter the table column to varchar. The behavior introduced by NIFI-8223 . This is fixed in NiFi 1.14 so an upgrade can be done if table schema alter is not an option.

Re: Records not inserted in Character datatype put database record

Chakkara — Wed, 03 Nov 2021 14:31:03 GMT

Thanks for the response. Will try with upgraded version

Re: Records not inserted in Character datatype put database record

VidyaSargur — Tue, 09 Nov 2021 05:11:40 GMT

@Chakkara, if the solution provided by @ashinde resolved your issue, can you please mark it as the solution? It will make it easier for others to find the answer in the future.