Issue with INDB Connections in Alteryx Gallery via DCM

[chuckleswk]

I’m encountering a problem with INDB connections in Alteryx workflows when published to the Gallery, despite successful local use. Here’s what I’ve done so far:

1. Set up and tested both INDB and non-INDB connections locally using the Data Connection Manager (DCM).

2. Successfully used non-INDB connections on the Alteryx Gallery.
3. Followed the steps to create an INDB connection on the Alteryx Designer, linked it to the DCM, and then synced with the Gallery.

Despite these steps, when I upload a workflow with an INDB connection to the Gallery, I get an “Error finding connection” message. Has anyone faced and resolved a similar issue? I’d appreciate any insights or solutions. Thank you!

[cjaneczko]

Did you setup the DCM connection on the server? Take a look at the knowledge base and make sure its configured correctly based on the Server setup in the lower section. 

https://knowledge.alteryx.com/index/s/article/How-to-Set-up-DCM-for-Designer-and-Server

[chuckleswk]

I had used the knowledge base to set it up. I am including some screenshots, but everything appears to be setup correctly. I am able to run with the DCM connection locally (both INDB and non-INDB) and when I push it up to the server I am able to run the non-INDB input tool fine but receive the error: Error finding connection "SNFLK_ISTINA_******_*****_DEVELOPMENT (DCM) - SVC_ACT"

[cjaneczko]

When you setup the DCM connection in the server environment, are you able to get a successful connection test via the DCM? Have you also synced Designer with the Server?

To synchronize DCM between Server and Designer, follow these steps: 

• Go to Designer > File > Manage Connections to open Connection Manager. Then select Synchronize in the menu.  
• Select from the list the Server you want to synchronize. 
• Select Synchronize.

After you have synchronized DCM between Server and Designer, any credentials you own and all data sources you have access to will be visible and ready for use in Connection Manager. 

[chuckleswk]

I created the connection on designer and have synchronized DCM between the server and Designer.

I am able to successfully run a connection for both the Connect In-DB tool as well as the Input Data Tool. When I push the same test workflow up to the Gallery, the Input Data Tool creates a successful connection but the Connect In-DB I receive the following error: • Error finding connection "(T) SF_xxxxxxxx_xxIDEV" (ToolId: 1)

[brionyryles]

I had the same problem, and with help from Alteryx support, resolved it using the following steps:

Right-click to open Alteryx as administrator. In the Connect In-DB tool, select Manage Connections from the Connection Type drop-down. Because it has been opened as administrator, a Connection Type of 'System' has appeared.

I used the following settings to create a new connection (using the Oracle OCI driver):

Connection Type: System
Password encryption: Encrypt for Machine

I was advised to use 'Encrypt for User', but this gave us an error of 'the attribute OCI_ATTR_PASSWORD is greater than the maximum allowable length of 255'. Using 'Encrypt for Machine' resolved this error.

The same In-db connection must also be set up on Server, with the same name.