Could you send a screenshot of your data flow to give us a better idea of what you have implemented? You may have to pull the field down as just a string, check for null in a RouteOnAttribute, and then modify the insert command to a date of your choosing or "" if you wish for it to remain null. For non-null you can format as needed and then direct both branches into a putsql processor to be inserted. ... View more

If it was a hung thread, you wouldn't be able to redirect the queue by stopping the original RouteOnAttribute and pointing it to the new copy. You would have to cycle the NiFi instance first. After you redirect the queue to the new copy of RouteOnAttribute, does it eventually stop processing as well? Could you write down and type up the expression here so we can have a look at it please? ... View more