Created 04-11-2020 04:34 AM
I am trying to load a csv file with headers with exactly same spelling and caps as in the PostgreSQL DB table.
Created 04-11-2020 01:49 PM
The table name is different in than the one which you are trying to load data.
Please notice carefully that the error in Nifi is complaining about below table, whereas in your create table there is no prefix with the name "op"
Created 04-12-2020 12:52 PM
Hey that's a mistake in my typing as I had to mask col and table name. That's not an issue. Can you find anything else? It would be a good help in solving this then.
Created 04-13-2020 05:52 AM
@Raj2cool16 Can you update the original post, or send a reply here, showing the processor configuration and associated reader configurations? I believe there are some settings in the Processor and the Reader to effect your issue.
Created 04-13-2020 07:06 AM
PFB the full configuration details of PutDatabaseRecord and CSVReader.
PutDatabaseRecord SS Part 1:
PutDatabaseRecord SS Part 2:
CSVReader ss part 1:
CSVReader ss part 2:
CSVReader ss part 3:
Please let me know if anything else is needed, also if I need to tweak on settings or add/remove processors.