Loss of formatDateFrom attribute during PutSQL failure retry in Apache NiFi

Question

Hi,

I'm having a problem with a NiFi flow. I use UpdateAttrubute processor when I create an attribute like this:

formatDateFrom      ${dateFrom:format("yyyy-MM-dd")}

After this I have a PutSql processor that changes a status in DB. When everything is fine, it is ok. However, when something is wrong with the change, this status and my flow go to retry this attribute formatDateFrom disappears and is no longer present in the flow.

Why does this happen and how can I secure this attribute? Attributes created with EvalueateJsonPath didn't disappear, only those created with UpdateAttribute.

MattWho · Answer

@donaldo71 I am trying to follow your flow description here and am not very clear. Can you share your flow definition and indicate where you are seeing the failure.
What version of Apache NiFi are you using?

You have an UpdateAttribute processor that has its success relationship routed via a connection to the PutSQL processor. How is putSQL configured?

When "something is wrong", what exception is being thrown in the nifi-app.log?

The more detail you can provide the better chance. community member may be able to provide guidance and suggestions.

Thank you,
Matt

Support Fragmented Transactions	false
Database Session AutoCommit	false
Transaction Timeout	30 sec
Batch Size	50
Obtain Generated Keys	false
Rollback On Failure	false

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.