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

Apache NiFi 1.6.0 Error Post Upgrade


Hi all,

Just upgraded to the latest and grates NiFi 1.6.0 and i am getting a strange error on a ExecuteSQL Processor.

error: cannot insert multiple commands into a prepared statement

So the ExecuteSQL uses a Database Connection Pooling Service that runs some queries against a database in this case Vertica(with the latest jar), and there are multiple sequential queries.

I managed to fix the issue by rolling back my Apache NiFi Install to NiFi 1.5.0 and is all normal now.

I can also replicate the error.

I actually made a short Video on the behavior of the ExecuteSQL on 1.5.0 vs 1.6.0.

Demo of Error

Also Link:

Any ideas ? maybe a bug with new release ?