I have a workflow that has 1 primary data output that writes my main data table to an SQL database and a secondary data output that is used as a control report, in that it takes the data and checks for a condition (a missing mapping from a join from another file), and outputs just a few columns to show where there is a gap in mapping (again written to an SQL database)
For some reason, when I run this workflow, I am getting the ‘Workflow did not fully execute’ and red square, yet I have set it up with an empty table switch and some other logic so everything is actually successfully running (and have checked by manually running it locally)
Here is a screenshot of the main error messages
and here is a screenshot of the portion that is failing
What have I done wrong?
As a note, when there is indeed an empty table, I have branched off to include a lone data value (NO MISSING VALUES) as I don’t want the workflow to not write anything to the table, as otherwise it would leave old data in the table, and you’d think there is still something unmapped.
I have seen elsewhere people mention, but I’m not sure why there are errors messages for other things, for example, I have a large number of these: