Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Unable to translate alias when scheduling workflows on Alteryx Server

RonnieH
5 - Atom

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.

Capture.PNG

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

Capture1.png

 

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

 

Regards,

Ronnie

12 REPLIES 12
AnupD
8 - Asteroid

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.

 

 

clipboard_image_0.png

cam_w
11 - Bolide

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.

MPohlers
8 - Asteroid

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.