Support Questions
Find answers, ask questions, and share your expertise

Invalid conversion requested error in putdatabaserecord

Explorer

I am trying to load csv file into oracle db using GetFile and PutDatabaseRecord processors using apache nifi

 

Able to read the csv file but unable to insert because of below error in the putdatabaserecord

 

Invalid conversion requested. Please help to resolve this issue

1 REPLY 1

Master Guru

@Chakkara 

More detailed would be needed before I would know if I can offer any advice here.

Can you share:
1. PutDatabaseRecord processor configuration
2. Assuming you are using the CSVReader, please share its configuration
3.  DBCPConnectionPool configuration
4. Complete Exception including any stack trace if exist form nifi-app.log.
5. Any data manipulations made between your GetFile and PutDatabaseRecord processors?
6. Sample input file would also be very helpful.

Thanks,

Matt

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.