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

NiFi PutSQL exception.

Highlighted

Re: NiFi PutSQL exception.

everything is varchar.

Highlighted

Re: NiFi PutSQL exception.

New Contributor

I'm new to NiFi, and I'm not sure your data flow has same condition as mine, but I have a same issue of being occurred the same exception that you mentioned.

I'm using Oracle 11g XE, there was no invalid query nor invalid data. In addition, I had another problem with the Oracle session of PutSQL been locked when I let a lot of flowfile flow to PutSQL processor, e.g., 5,000 flowfile in 0.5 sec.

I have spent all day long to fix this problem today modifying almost every single properties of all processors connected to the flow, and even of DBCP controller service... and finally found the cause.

 

In processor PutSQL, there is a property named 'Support Fragmented Transactions'. I don't know pretty much about this and need to know how it works, but when I have set it false, the problem was solved. And it took some time more than before.

 

I'm not an expert of NiFi, but I hope this might be helpful for you.