Error:Unable to find connection

Question

Hi Everyone,

I am trying to run an app in Alteryx Gallery. Inside this app I have regular input connections and in-db connections. The regular inputs point to a data connection that I set up under the manage data connection option(call it X). These regular input tools work just fine. For the in-db input tool I had to create an in-db connection in which I pointed the connection string to X (it appeared as aka:X).

Now when I run the app locally I get no issues but when I run on gallery there seems to be an issue with the in-db tools. The error I get is "Unable to find connection". Any reason for this?

rkapoor · Answer

@jaipersr this looks like a similar error as per the link below:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/In-database-quot-Unable-to-find-connection-x-quot-when-workflow/ta-p/451570

Can you try to use a System in-db connection?

Another way to fix this, is to have the in-db connection set up on the Alteryx Designer installed on the Server machine. You can then synch the connections up from the Server to your Designer and refer to that in your workflow.