PutDatabaseRecord :Record does not have a value for the Required column 'name'

Question

I am new to Nifi and trying to load csv data in postgres but I am getting error:

FlowFile[filename=test_data.csv]. Routing to failure.: java.lang.IllegalArgumentException: Record does not have a value for the Required column 'name'

so I have checked everything and the csv file I am uploading contains the data.

I have also checked solutions for issues like this but nothing worked out. I will attach liks to the screenshots it contains the configuration for PutDatabaseRecord and the query for the table I created in postgre and screenshot of the csv file.

https://drive.google.com/file/d/1TCJTcNJHRslG4wEct1eZmuYz54Gp9e9o/view?usp=drive_link

https://drive.google.com/file/d/1Ye6pggRN4YTQVGxylNarjZh4dlX-ByQ1/view?usp=drive_link

https://drive.google.com/file/d/17zLRe88DSssU9DI3rrJLCHQmUgAj9FYX/view?usp=drive_link

https://drive.google.com/file/d/1XKt1jbZks8jE0kO4CrT3nmRR4LFcIn1e/view?usp=drive_link

Note: please let me know how I can upload image here directly

Runa27 · Accepted Answer

@MattWho

I have found the solution for that. The error was because of the semicolon in the CSV file. I have changed it to comma ","because in my configrations the seprator value was comma not semicolon

before:

name;age;email john doe;56;u@gmail.com hamed;25;fff@gmail.com arjun;55;ru@gmail.com ali;21;ffuty@gmail.com saleh;16;djh@gmail.com

After:

name,age,email john doe,56,u@gmail.com hamed,25,fff@gmail.com arjun,55,ru@gmail.com ali,21,ffuty@gmail.com saleh,16,djh@gmail.com

MattWho · Answer

@Runa27

You should be able to take a screenshot and then just right click an paste it to the response window. It may paste small, so click on it and drag the corner to make it large enough that it can be read. Once you click reply, readers of your post will not have option to resize themselves.

Thanks,
Matt

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.