'Nifi throwing None of the fields in the record map to the columns defined by [table name]

Am trying execute a sql query on oracle database and inserting the result into another table, for my trial am just performing a simple query as select 1 COUNT from dual and trying to insert that into a single column table which has the name COUNT. The content of the record on Nifi seems to be as follow [{"COUNT":"1"}] but the logs keeps throwing the error due to java.sql.SQLDataException: None of the fields in the record map to the columns defined by the schem_name.table_name table: any ideas ?

enter image description here

apache-nificloudera


Solution 1:[1]

I believe you get that same error message if your table name doesn't match. The Translate Field Names property only translates the fields (columns), not the table name. Try specifying the schema/table in uppercase to match what Oracle is expecting.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 mattyb

Related Questions