Toad World® Forums

Using "Loop Connections" option in Automation


#1

I am using “Loops Connections” option in my automation workflow where in i define my connections.

Under “loop connections”, I have define “loop dataset” where in i have defined a query. (SELECT * from ADMIN.TEMPLATE).

Under Activity input table of Loop data set i have defined the connection as “root@localhost” , as I want it to use the connection specified under “Loops Connections

When i execute a workflow i am getting following error.

7/30/2018 10:21:31 AM Connecting to root@localhost
7/30/2018 10:21:31 AM Table ‘admin.template’ doesn’t exist

Table Template exist in DB. Workflow executes fine if i explicitly mention the Database name in the in Loop data set activity. But i want the loop dataset activity to take the database name from Loop connections

Let me know if anyone needs more info to resolve this.


#2

The connections you specify in the Loop Connections activity take precedence over any connection specified in an individual activity. But “loop dataset” does not for TDP4.2&4.3 &5.0. it is a bug, and I have created issue to follow it.https://jira.labs.quest.com/browse/QAT-13279


#3

We never coded for this nested support. How many connections do you have in your Loops connections? Hopefully it is a short list so that setting each Loop dataset manually would be a workable solution.