Skip to main content
johndcal
Gold ⭐️
July 24, 2020
Solved

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

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.

 

field eccentricity cannot be null.PNG

johndcal
johndcalAnswer
Gold ⭐️
July 27, 2020

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.

2 replies

johndcal
johndcalAuthor
Gold ⭐️
July 24, 2020

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.

Translate
johndcal
johndcalAuthorAnswer
Gold ⭐️
July 27, 2020

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.

Translate