I've created a workspace that reads from six tables in a PGDB file and does mutliple types of validation on each. I have set a global variable at the start of the process to 1 and each failure path writes what went wrong to an error log table in our database. The failure paths also set my global variable to 0. These all connect to a VariableRetriever then a Tester to see if ther were any failures.
What I would like is if even a single feature failed along the way, the workspace writes a failed status to the database using the SQLExecutor and stops. If nothing failed, it continues and writes the PGDB features to the database. The issue here is that the Tester outputs all failed features, so would execute the SQLExecutor multiple times and I just want it to run once.
Is there a way for the SQLExecutor to only run once, even with multiple features being input, or a way to remove the features so only one is passed in?
Thanks,
Nick