topic Re: Unable to translate alias when scheduling workflows on Alteryx Server in Alteryx Server Discussions

Unable to translate alias when scheduling workflows on Alteryx Server

RonnieH — Mon, 25 Mar 2019 10:17:41 GMT

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

Re: Unable to translate alias when scheduling workflows on Alteryx Server

CharlieS — Mon, 25 Mar 2019 13:37:37 GMT

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.

Re: Unable to translate alias when scheduling workflows on Alteryx Server

AnupD — Mon, 25 Mar 2019 18:12:27 GMT

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.

Re: Unable to translate alias when scheduling workflows on Alteryx Server

RonnieH — Tue, 26 Mar 2019 06:51:30 GMT

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?

Re: Unable to translate alias when scheduling workflows on Alteryx Server

buddyboy00212 — Wed, 12 Jun 2019 21:04:55 GMT

This post saved me hours of headache and debugging. I ran into this exact same issue and changed the permission on the Data Connection from using the studio to the individual user. Thanks much for the help!

I echo @RonnieH 's comment about this being a bug. Has this been reported to the Dev team?

Re: Unable to translate alias when scheduling workflows on Alteryx Server

AnupD — Wed, 12 Jun 2019 21:27:12 GMT

@buddyboy00212 glad you found the solution helpful.

Yes, it seems to be a bug. One of the Alteryx engineers had confirmed that this is not how the feature was designed.

Re: Unable to translate alias when scheduling workflows on Alteryx Server

TanyaS — Fri, 14 Jun 2019 16:45:03 GMT

Hey all,

This is a known defect that we are planning to have resolved by early next year at the latest. The friction caused by having to share to each user individually is definitely something we want to get out of your way!

Thanks,

Re: Unable to translate alias when scheduling workflows on Alteryx Server

Inactive User — Thu, 29 Aug 2019 11:50:18 GMT

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?

Re: Unable to translate alias when scheduling workflows on Alteryx Server

AnupD — Thu, 29 Aug 2019 12:48:33 GMT

@Inactive User Are you packaging the connection in the workflow while publishing, via Manage Workflow Assets option?

Re: Unable to translate alias when scheduling workflows on Alteryx Server

Inactive User — Thu, 29 Aug 2019 12:56:40 GMT

Hi @AnupD - yes it appears that I've packaged the connection when uploading. If I deselect that under Workflow Assets, the conncetion doesn't work on the Gallery when I upload the workflow either.

Then what on earth is going on then? I've selected the alias from the list of Saved Data Connections, so the alias on the server and in the desktop should be identical?

Re: Unable to translate alias when scheduling workflows on Alteryx Server

AnupD — Thu, 29 Aug 2019 14:25:00 GMT

Yes, you need to select a connection from Saved Data Connections, but you need to make sure you are selecting a Gallery Connection not User Connection. In other words, after you navigate to Saved Data Connections window, select a connection from Your Company's Gallery option, not from My Computer option.

You can also go to Options Menu -> Advanced Options -> Manage Data Connections to review which ones are of type User or Gallery. Always select Gallery type when publishing workflows.

Re: Unable to translate alias when scheduling workflows on Alteryx Server

cam_w — Tue, 12 Nov 2019 17:34:20 GMT

Hi @TanyaS

The same appears to be true for Workflow Credentials shared with a Studio/Subscription when the schedule is edited. Are you also tracking this bug?

Also, can you please help us out by publishing these in the Known issues listed with the Release notes? It would be sooo much easier for us to be able to see them all in a single location rather than digging through the community chats.

Re: Unable to translate alias when scheduling workflows on Alteryx Server

MPohlers — Fri, 20 Dec 2019 15:33:38 GMT

Although I haven't seen it in the release notes, it seems to work now with 2019.4. A connection shared with a studio can be used by a user in the studio.

What still does not work for us is scheduling via the controller token (so not using the gallery). Whenever we do this the same error translating alias appears.

Does someone have information about this?

I reached out to support but haven't heard anything unfortunately.