Flowfile is currently penalized and data cannot be processed at this time . How to solve this issue ?

[#1]

I am facing below issue in my flow..

flowfile is currently penalized and data cannot be processed at this time .

Any idea how to solve this issue .

Thanks in advance .

[#2]

@Madhav_VD 

How has yoru PutSQL processor been configured (all tabs)?
For a FlowFile(s) to be penalized a processor needs to apply that penalty.  
That could be applied by the PutSQL if you configure retry on a relationship or being applied by the processor feeding the connection.  Looking at your attached dataflow, I don't believe the EvaluateJsonPath processor is applying any such penalty.

If you found any of the suggestions/solutions provided helped you with your issue, please take a moment to login and click "Accept as Solution" on one or more of them that helped.

Thank you,
Matt

[#3]

Hi this is how i have configured my  PutSQL processor . Let me know if i missed or need to Change any configuration. 

 

@MattWho 

[#4 · Accepted solution]

@Madhav_VD 

What about the "Relationship" tab?

My guess here is that you have checked the "retry" box on the success relationship of the putSQL processor.  If that is the case, unchecking "retry" on the success relationship should resolve your FlowFile penalization issue:

When this processor is running, does it produce any bulletins or exceptions in the log output?  If it is producing bulletins, warn, or error logs, it is likely failing to write to your SQL DB.  The FlowFIle would then be routed to retry or failure relationship depending on exception where "retry" if checked would be applied based on retry property configurations. 

If you found any of the suggestions/solutions provided helped you with your issue, please take a moment to login and click "Accept as Solution" on one or more of them that helped.

Thank you,
Matt

[#5]

In PutSql Processor, there is a property "Support Fragmented Transactions". If set its value to be false, then it is proceeding and not penalising the flow files.

[#6]

In PutSql Processor, there is a property "Support Fragmented Transactions". If I set its value to be false, then it is proceeding and not penalising the flow files.