Welcome to the Alteryx Knowledge Base

Diagnosis

Data connections in Gallery are different than those in Designer. First, identify which type of connection/alias you are using:

• In Designer select Options > Advanced Options > Manage Data Connections
• Determine the type of Data Connection

 

 

If you are using a System/User alias, see Solution A.
If you are using a Gallery alias, see Solution B-E.

Note: If you are using a Gallery alias, and one of the below applies, see Solution E:

• You started seeing this error after upgrading to Server version 2021.1+ OR
• You are on version 2021.1+ and Solution B-D do not apply to you

Cause

Alteryx is not able to find the connection referenced in the workflow.
 

Solution A. Alias is not accessible on the Server

 

The user has created an alias (Saved Data Connection) locally that does not exist on the Server, or is not configured properly. The alias must meet the following requirements:

1. The alias must be created as a System Alias on the Server (all Worker nodes)
2. The alias must have the exact same name

It is a best practice to ensure that all aliases are configured as System aliases on the Server. In rare cases, your Gallery Admin may specify that the User Alias can take preference over the System Alias. Please contact your Admin to confirm if this is the case. If this is selected, then the User alias should execute on the Server. This is not the default option.
 

Solution B. Gallery Connection Sync Issue

 

1. Open File Explorer
2. Navigate to %APPDATA%\Alteryx\Engine
3. Delete or rename GalleryAlias.xml

 

4. Re-launch Alteryx Designer. This will re-sync the file and you should now be able to see and use the data connection.

 

Solution C. Connection shared with Private Studio

 

If the issue only occurs on your Server and runs fine everywhere else, the Gallery Data Connection needs to be shared explicitly with the owner of the workflow rather than their Private Studio/Subscription.

1. Default avatar is a single silhouette
2. User membership icon will appear on the right
3. The user's email will show

 

Please note that in newer versions of Server, the option of sharing to a Studio/Subscription has been removed.

 

Solution D. Asset missing

When sharing the connection, you can differentiate a Studio with User Accounts by checking the following:

The Gallery connection was not included as a workflow asset when publishing the workflow to the Server. The app/workflow will need to be re-published with the following steps:

1. From the Designer, select File > Save As >and select your Gallery
2. Under Workflow Options select Manage workflow assets

 

3. Check the box with the name of your alias

 

4. Select Done and then Save to publish.

By default, this option is selected when you first publish.

 

Solution E. Gallery Data Connection is not shared correctly

This only applies to Server version 21.1+. In this version, how the permissions check applies changed. See this article for more details: Sharing Data Connections with User Groups | Altery... - Alteryx Community

• For versions up to 2020.4 - ensure that the workflow owner has the Gallery data connection shared with them.
• Starting in version 2021.1, the data connection must be shared with all users who run the workflow on the Gallery, not just the workflow owner.