I cannot be the first person to ask this question, but my searching has not turned up any results. I have run into the scenario a few times that a process flow becomes unusable, or very difficult to fix, after a fairly minor failure. In this case, I have a somewhat complex process flow with a combination of task nodes and code nodes.
After the failure of a node, the link from the node to the output is removed. The subsequent node is then linked to the output, not to the node that created it. When the issue is corrected, the process flow cannot be executed again because a node attempts to access data that has not yet been created.
The only method to avoid this I have found is frequent save points, but it very easy to forget.
In this screenshot the top is the working process flow. The bottom is the result after a failure step 9. When it is re-run, step 10 kicks off without the input dataset being created.
EG 7.13 HF1 against SAS 9.4
... View more