Unable to Translate Alias error for Oracle DB

[RUSA]

Version: 2020.4.5.12471

I have 4 Oracle databases that are incorporated into workflows and all 4 of them run fine from my desktop. One of them gets an error every time I save it to my gallery. It only happens with this one database and happens the same for every user. The error is "Unable to translate alias".

Any ideas?

[JagdeeshN · Accepted solution]

Hi @RUSA ,

Can you confirm if a data connection has been configured on the 'Designer' instance installed on the machine Gallery is hosted on. I ask as if that connection with the same name as on your desktop does not exist, you might get this error.

One alternative is creating a data connection on the Gallery Interface and share it with users. This way you can use the same connection while developing on Desktop(Designer) and while publishing to the server.

1. https://help.alteryx.com/current/server/data-connections

2. https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Gallery-Data-Connections-FAQ/ta-p/452...

Please do let me know if this helps

Best,

Jagdeesh Narayanan

[RUSA]

@JagdeeshN 

Thank you! That was an easy fix.

[JagdeeshN]

@RUSA 

Awesome!. 

Easy fixes are always the best.:)