Try Catch on a Database Reader
Hi, I’m trying to configure a workflow to read from a Database Reader node. The workflow runs in a loop, and for most of my cases the information I need is in a consistently named table, but on some older cases I need to look for a different table name.
My plan was to use a Try Catch loop so if the main reader failed it would pull the results from the backup source:
The database connection is coming from elsewhere and feeds into multiple other points of the workflow, so is outside of this try-catch loop. There aren’t nodes (that I can see?) for Try with anything other than Data or Variable, so I’ve used a variable to just connect into the Database Reader.
When I run the Catch node, both DB Readers execute and the main one fails as expected, but instead of reading the backup source (which is successful) I don’t get an output from the catch. Am I going about this the wrong way?