Support Questions

Find answers, ask questions, and share your expertise

Error SQL statement in PutSQL processor not routed to failure relationship

New Contributor

Hi,

 

I've got an error in the PutSql processor because there is a syntax error in the insert query, but the flowfile did not route to the failed relationship, instead the session is rolled back and stuck to the incoming queue


can someone explain me why this is happen?

or can I force the flowfile that have an error routed to failure relationship
or is there a way to remove specific flowfile that caused error in queue, so the other flowfile can be processed

 

Capture.PNG

 

Thanks,

3 REPLIES 3

There should be a config value for Rollback on Failure.  Change accordingly:

 

Screen Shot 2020-03-23 at 3.08.09 PM.png

New Contributor

This does not work, False works as described for True. I checked.

New Contributor

I had the same issue. Did you get around to resolve this?

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