question Re: NiFi MergeRecord Processor throwing "Field Eccentricity Cannot Be Null" Error in Support Questions

NiFi MergeRecord Processor throwing "Field Eccentricity Cannot Be Null" Error

johndcal — Fri, 24 Jul 2020 17:00:29 GMT

Does anyone know what the error in the subject line of this message means? I am using SplitRecord processor, checking for duplicate records (removed for testing), then trying to use MergeRecord to put all the splits back into one file, but MergeRecord fails with "Field Eccentricity Cannot Be Null" Error. I have not found information on the meaning of this error.

Thanks in advance if you know.

Re: NiFi MergeRecord Processor throwing "Field Eccentricity Cannot Be Null" Error

johndcal — Fri, 24 Jul 2020 19:09:13 GMT

I created a small input file that produces 9 splits. In each split, none of the fields contained a null value, so nulls are not the problem as someone in StackOverflow suggested. MergeRecord still threw the error when it tried to merge the 9 records.

Re: NiFi MergeRecord Processor throwing "Field Eccentricity Cannot Be Null" Error

johndcal — Mon, 27 Jul 2020 17:52:39 GMT

Ignore, I figured it out. Hate to say it, but I am working with the UCS satellite database as input - it has 36 fields - Eccentricity is one of the fields. I forgot to add a default value for this field for handling nulls.