Created 07-25-2023 08:09 PM
Hi Team,
I create a dataflow try to insert data into uppercase table in postgesql.
But it does not work.
Appreciate any help on this issue, I am new to Nifi.
Here are my setting for QueryDatabaseTable and PutDatabaseRecord
The error message show
org.apache.nifi.processors.standard.db.TableNotFoundException: Table "ACPMA" not found, ensure the Catalog, Schema, and/or Table Names match those in the database exactly
Here is a uppercase table ACPMA in postgesql.
Created 07-26-2023 05:39 AM
Hi @mandychen ,
Have you tried removing the double quotes from "ACPMA" in the Table Name property of the PutDatabaseRecord? I dont think you need it there.
If that helps please accept solution.
Thanks
Created 07-26-2023 05:39 AM
Hi @mandychen ,
Have you tried removing the double quotes from "ACPMA" in the Table Name property of the PutDatabaseRecord? I dont think you need it there.
If that helps please accept solution.
Thanks
Created 07-30-2023 04:45 PM
I see, it work!
Thanks for your information