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.

Error SQL statement in PutSQL processor not routed to failure relationship

Highlighted

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,

1 REPLY 1

Re: Error SQL statement in PutSQL processor not routed to failure relationship

Master Collaborator

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

 

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

 


 


If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.  


 


Thanks,



Steven @ DFHZ

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