Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Getting error while loading data into oracle using nifi putdatabaserecord

Highlighted

Getting error while loading data into oracle using nifi putdatabaserecord

New Contributor

Hi,

 

I need your assistance for the below error I am getting while loading data into oracle through NIFI.

 

NIFI versions:- 1.5.0

I have used GenerateFlowFile->PutDatabaseRecord.
In the GenerateFlowFile I have given data like below

GenerateFlowFileGenerateFlowFilePutDatabaseRecordPutDatabaseRecordRecord ReaderRecord ReaderTABLE DLLTABLE DLL

Above is the destination table DDL.

 

error which i am getting :-
7:52:13 ISTWARNING016f1035-ebf0-1955-78fc-7b77d02d4fbe
PutDatabaseRecord[id=016f1035-ebf0-1955-78fc-7b77d02d4fbe] Failed to process StandardFlowFileRecord[uuid=d8d4af6a-56b5-4fd0-b6d9-798b2155628d,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1578399700775-1, container=default, section=1], offset=51888, length=46],offset=0,name=956358126100,size=46] due to None of the fields in the record map to the columns defined by the employee table:

 

I have tried all the soluctions on cloudera but still getting above same error.

 

Could you please help me to resolve this issue.

Don't have an account?
Coming from Hortonworks? Activate your account here