This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 10-11-201912:26 PM - edited on 09-22-202103:23 PM by gtorres8
The user gets the below error when trying to run or publish a workflow:
Unable to translate alias
This error can be seen when running/opening a workflow on Designer:
Or when publishing the workflow to Gallery:
Or when running the workflow on Gallery:
Or when scheduling a workflow to local scheduler/desktop automation.
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.
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
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:
The alias must be created as a System Alias on the Server (all Worker nodes)
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
Open File Explorer
Navigate to %APPDATA%\Alteryx\Engine
Delete or rename GalleryAlias.xml
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.
When sharing the connection, you can differentiate a Studio with User Accounts by checking the following:
Default avatar is a single silhouette
User membership icon will appear on the right
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
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:
From the Designer, select File > Save As >and select your Gallery
Under Workflow Options select Manage workflow assets
Check the box with the name of your alias
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
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.
Solution F. Workflow has a Macro with a database connection from an Input or Output Tool
Within the main workflow, add Input Data Tools for all Gallery Data Connections referenced within the Macros. You can group all those extra Input Data tools into a container and disable the container so it won't affect your workflow. Then save the workflow back to the Gallery and run it. Doing this will force the Gallery Data Connections used within the Macros to be packed along with the workflow when saving the workflow to the Gallery allowing the Gallery to know which Data Connections you need to use.