We have a workflow that query's a spreadsheet ODBC connection for data.  The issue is that on occasion the lookup will fail and terminate the workflow.  This happens because either multiple workflows are trying to connect to that spreadsheet or the less likely reason that someone may have the sheet open to edit it.  We are trying to think of a good way to make it retry the query data without killing the workflow. 

I can always put in a try catch with Query Data on the Try Branch and a delay on the Catch branch.  To make it do the lookup again, without creating a second query data step is to put the Try-Catch in a repeat look that repeats until the Query Data step has results found. 

The issue with putting the Try-Catch in a Repeat loop is that once I do that the For Each Row activity below the repeat loop now says it can't access the Query Data array.  Here is a screen shot of my workflow steps. 

Before it comes up, yes a SQL table would be better for this usage but not as easy for the end user to edit when changes are needed.  Also, they haven't implemented Forms yet so we could build a nice web interface for them to edit and add data to the SQL table.