Unable to translate alias when scheduling workflows on Alteryx Server

Hi everyone,

I have created a workflow which uses a Input Data connection that reads a SQL server database. The connection is created in Alteryx Designer by selecting the connection from the Gallery. When saving the workflow to the Gallery, I set the workflow to use my specific credentials so that it can be scheduled.

When running the workflow in the Gallery manually, it works fine. However, if I schedule the workflow it suddenly complains to not be able to translate the alias as per the screenshot below

I've read the troubleshooting guide but it does not seem to address this case, or am I missing something?

Regards,

Ronnie

Schedule

Database Connection

Accepted answers

AnupD

Not sure if the Gallery connection is shared with the Studio you are part of, or if it is shared directly with you (as a User). I've faced similar issues: I (Curator) would share the connection with the Studio I'm part of, use that connection in my Designer and publish the workflow. When I ran the workflow manually from my Private Studio, it would run fine. But when I schedule it, I would get 'Unable to translate alias' error.

I then shared the connection directly with me (User not Studio), and I was able to schedule the workflow. Not sure if this is a bug or feature, but connections shared with Studios do not seem to work when workflows are scheduled, whereas connections shared directly with individual users seem to work when workflow are scheduled.

Hope this helps.

All comments

CharlieS

If I'm not mistaken, the alias are both user and machine specific. Try scheduling this on your machine (with your credentials again) and see if that does the trick. If this works, you might need to configure the alias on the worker machine, or change the connection type to an ODBC.

AnupD

Hope this helps.

RonnieH

Yes, the connection was shared with the Studio and not directly to the users. Sharing the connection directly to the users solves the problem, thank you very much!

However, this feels like a workaround and not how it is intended to work?

unknown

I'm having the exact same issue. I have tried to remove my user and studio from the data connection on the server and add them both again. Unfortunately this didn't work. Any other suggestions?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280