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

[#1]

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

[#2]

@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

[#3]

@Runa27 

Without details of your database table structure/configuration and your test file, it would be challenging to identify your exact issue.

Have you tried setting the "Unmatched Column Behavior" property to "Ignore Unmatched Columns" or "Warn on Unmatched Columns" to see if that makes a difference?

Can you share how your CSVReader has been configured?

Please help our community grow. If you found any of the suggestions/solutions provided helped you with solving your issue or answering your question, please take a moment to login and click "Accept as Solution" on one or more of them that helped.

Thank you,
Matt