2021.3 Server - Unable to translate Alias - Error for DB connection

When i try uploading a workfow with database connection on Gallery or if try running the app with db connection on gallery, i get an error saying 'unable to translate Alias'.

I have been able to use the same db connection and run successfull on Gallery before, but since the Version 2021.3 upgrade i am getting the Alias error.

Gallery

Database Connection

Alias Manager

Accepted answers

SophiaF

Hi all - thank you for reporting. We have identified a defect in the 21.3 version which is preventing the alias file from being packaged when workflows are uploaded from Designer to Gallery. Without this alias file, you get this error.

Please refer to the article here for more details, and for updates: TDES-3766: Designer 2021.3 - Error "Unable to tran... - Alteryx Community

All comments

gpmyers111

Having the same issue here.

My existing data connections work fine after the upgrade, but if I create a new one, I get this error every time.

dataguyW

I have had this error numerous times, but not just because of an upgrade. Check or have your system admin check that the system account running on the server still has permissions to the machine keys folder (where the passwords are hashed (%ProgramData%\Microsoft\Crypto\RSA\MachineKeys). If it is anything else I am subscribing before our group upgrades and finds the same. Good luck

rohan_tibarewala

@dataguyW

Seems the system account has access to the folder you referred to, but the error still persists for us.

gpmyers111

I checked this on our server as well and even explicitly added the service account to full access to that folder. Our issue persists.

I've been looking over older cases, and the problem seems to be that neither an input tool or an output tool using the new gallery connection can be packaged. This used to solve the problem in the past, but now all I get when I go under Manage Workflow Assets before the save is this:

gpmyers111

As an update, I've now discovered that our existing gallery connections are also effected. They work fine if you run an existing workflow on the gallery or scheduler, but if you download the workflow to Designer and then try to save, it errors with "Unable to Translate Alias"

dataguyW

I have had one fluke occurrence where I could open a "broken" workflow and copy/paste it into a new blank workflow and resave, and everything worked great. I then found a bug that wouldn't let the workflow save correctly to the gallery IF AMP was checked as a runtime selection. It worked just fine if I unchecked that selection. That took me days to figure out and maybe worth a check in this case because I also had double-checked every other obvious thing.

SophiaF

Please refer to the article here for more details, and for updates: TDES-3766: Designer 2021.3 - Error "Unable to tran... - Alteryx Community

jamshed23

Run designer as administrator it will allowed you to add connection as system

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703