Currently working on NiFi flow which reads a table from DB1(SQL Server1) using ExecuteSQL and put records in DB2(SQL Server2) using PutDatabasRecord processor. I'm getting error "None of the fields in the record map to the columns defined by the dbo.Employee table" while running the flow.
NiFi version : 1.7.1
SQL table schema: CREATE TABLE dbo.Employee
Is "Translate Field Names" set to true in PutDatabaseRecord? If not try that. If so, try removing the "namespace":"dbo" from the schema. If that works, then it's probably a bug, as we should be trying to match on fullname but fall back to simple field names.
I am also trying to fetch data from table 1 and insert into table 2. Both data sources are Oracle. I am able to fetch data successfully but getting error in insert, in PutDataBaseRecord getting error 'none of the fields from record map are matching with table 2'
@nkimani when I change table name to "EMPLOYEE" it gives error 'stream has been closed' and when I give table name 'employee' it gives error 'none of the fields are matching with record map with employee table '