When saving a workflow to the gallery, none of the options I could choose from Set workflow credentials validates a workflow successfully when using database connections due to missing permission on the server (No specific Run As is configured on the Server). Apparently the server validates the workflow as following:
User is not required to specify credentials:No possibility to add credentials when running the workflow on the server. In that case, the workflow validates database connections with errors due to missing permission on the server. This error was expected.
User must specify their own credentials: This option is the most appropriate in case of working with database connections with regard to our use cases and security policies. Unfortunately this option is only enabled when the workflow is saved on the server already and run from the gallery. In case of the validation step when saving the workflow to the gallery, the server evaluates with the system user of the server. As a result, the validation fails. In that case, I expected the server to run the validation with the user from the Alteryx Designer.
Always run this workflow with these credentials: This option is not appropriate in terms of our security policy, since the workflow is permanently set with the users credentials.
So my suggestion would be to:
Otherwise is see no benefit of the validation feature (with respect to our use cases and security policies)
We have more than 100 workflows scheduled in different intervals for a day. Inorder to monitor this we have to manually check in the workflow results if the workflow ran successfully or not.
Say a workflow is scheduled every 30mins then we have to check this 48times in a day manually in the Gallery results if it ran successfully or not.
Similarly we will have N number of workflows scheduled with different intervals.
We feel its too time consuming to manually verify this.
It will be good if there is a notification when there is a failure in the run, so we can check it only then rather than checking it every 30mins.
For whatever reason a schedule is disabled, whether a Studio expires, or for any other legitimate reason, a notification email should be sent to the Admin and the one that created the schedule in advance of it being disabled. When a scheduled workflow is not executed, it leaves us scrambling for answers. A sudden disablement of the schedule is disappointing to discover after all other stones have been turned. Notify us in advance of a schedule being disabled.
I have three team members all in the same private studio. We can see each others' workflows. However, when looking at a workflow that another team member has published to the gallery, it looks like:
This is a massive impediment to collaboration because my team handles ETL for most of the company. If a user complains that their data isn't up to date, whoever receives that support ticket needs to be able to see if the workflow is actually running and whether it was successful or had an error during the last run.
Preventing a team from seeing this for each others' workflow schedules and results means that the only person who can deal with an issue is the person who originally made the workflow. Which makes the idea of a shared private studio wholly pointless as we may as well be operating in different universes.
Please create a studio-level setting where all members of a studio can see all schedules and results of all workflows in that studio.
See following article for background reference: https://community.alteryx.com/t5/Alteryx-Server-Discussions/workflow-exceeded-maximum-runtime-of-30-...
I have a support case (#00278355) advising unsupported changes to the alteryx.config file, involving an undocumented setting for chainedTimeout, as in:
<engine enableAutoLicensing="true" useServiceLayerComposer="true" chainedTimeout="10800"
This setting should be documented, supported, and made user-configurable through the System Settings GUI.
When you save-as a workflow to an Alteryx Gallery, an option is not provided to overwrite an existing workflow with the same name if that workflow wasn't opened directly from the gallery (e.g., if it was opened from disk). This is contrary to how almost every other application works and what you would intuitively expect, and leads to duplication of workflows on the Gallary. For example, when using Tableau, a message would be provided such as "A workbook named ... is already in use. Overwrite it?" Or said another way, why does the Gallery allow multiple workflows of the same name to be published? There seem to be multiple reasons why you may want to save a workflow locally prior to re-uploading to server, including saving during the change process when you don't want updates to be published until they are fully complete.
I am aware that duplicate workflows can be cleaned-up on server (https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Clean-Up-Duplicate-Workflows-In-the-G...), but please consider changing the functionality within Designer to make this process more intuitive. Thank you.
We have several clients that operate in a Multi-Forest environment due to mergers and acquisitions. Currently with Alteryx Server the only option we can offer them is to use Built-In authentication. A lot of corporate and particularly finance institutions prefer a single sign on approach and utilise Windows authentication to do this.
Would it be possible to add support for Multi-Forest organisations into Server to support organisations going through mergers and acquisitions?
This would really benefit us in selling Server in to organisations with complex structures and reduce friction in publishing or preparing workflows.
The Save to Gallery window does not resize. When I try to Save my Workflow to my Gallery and Manage Workflow assets, I can not widen that window to see the full path to my assets.
This makes it very hard when you have many assets to know if they need to be included or not with the promotion. It may take two or three attempts guessing what asset is what to get the correct combination to make my App run correctly.
It would be nice to be able to widen this window much like we can with the Workflow dependencies window.
When an artisan moves positions (within or external) away from their current responsibilities, their collections and workflows should be able to be transferred via an administrator to another user.
Currently on Alteryx it is possible to add visibility of a subscriptions scheduled workflows to all members of that subscription.
What we would quite like is for the ability to turn on or off the ability to edit workflows within that subscription for all members.
As in if a member goes on leave, or leaves the company, or is ill, other members can edit, update and cancel the scheduled workflow as needed without needing to go through an admin for it.
As an Admin, I would like to be able to see, from the Gallery, a single place where the history of workflows that have been run is displayed. Right now I can only see workflows running or queued. I would like to be able to look back at past executions and see status, runtime, errors, etc.
This data is currently available in Designer on our Alteryx Server. But right now our system is just one environment. I'm not sure if when we expand to multiple Gallery and Worker machines where I will have to look for workflow history.
Also, Workflow schedules can only be seen in Gallery, and not Designer. So it would be nice to have everything in one place.
This post illustrates the current state of how the Gallery and Scheduler interact with time zones as of V11.7. The behavior it showed in that test is unintuitive and may lead to issues with setting schedules correctly. One possible correction would be to unify all times on the server to server time, but I think we can do better.
What I suggest instead is to add time zone as an option on the scheduler. This way users that set schedules don't ever have to wonder at what time the workflow is actually going to run. That information can also be passed through to results such that users that want to make sure a schedule is working as planned don't have to back track and figure out if 5pm means 5pm their time or server time. Finally, it would allow a more intuitive way for an employee in Denver, CO schedule a workflow such that his or her boss in Irvine, CA receives the resulting report exactly when needed/expected.
As the Server Admin I'd like to have the ability to view ALL "Workflow Results" for all Subscriptions.This will give the highest level admin the ability to monitor all schedules (on the entire server instance) and monitor if they are unable to complete successfully (example- unable to allocate memory) and any other errors are occurring.
Knowing this information will help the server administrator understand if there are issues with the server itself (e.g. if we need more workers or to simply adjust actual server system settings..etc..)
It would be nice to be able to change the Gallery URL from:
The reason being to make it easier for end users to find the server/content.
Original forum post here: https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Changing-the-Gallery-URL-on-Alteryx-S...
I really want to see this feature in new versions. Its frustrating the lack of options we have with scheduling workflows on the server. I need to have my process run every 10 mins but only on certain days and in certain time windows. Creating a schedule for this is impossible unless I manually create hundreds of schedules.
I have a few workflows that I have hosted on out Gallery Server and I have them scheduled.
Ex: Process A is scheduled to run every 10 mins Mon – Sunday.
Problem: I only need Process A to run Every 10 Mins on Mon – Sat from 2 AM to 6 PM
Currently there is not a scheduling configurations that allow this type of schedule. How can I get my workflow to run every 10 mins but only during certain times and on certain dates?
There is no good way to get server user credentials into a workflow without asking them for it in an App interface. It would be great if we could have a built in Constant that could be used to silently pass user credentials into a workflow for things like API's or logging user information.
When a workflow is run manually in the gallery the user is able to enter input parameters. However when using the schedule functionality this option is not available and a separate workflow needs to be developed to dynamically derive input parameters. Effectively two separate versions of the workflow need to be created and maintained.
If this functionality could be built into a future version of Alteryx this would be of significant benefit.
In response to my question here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Singin-Error-to-Tableau-server-using-P...
The Publish to Tableau Server does not support SAML/SSO. I would like this feature to be added to this tool as it will make our business process more efficient.
Now, gallery does not support AD group , need to setup user one by one.
If gallery support AD group synchronization, it is more convenient for gallery admin to manage large number of users.
By assigning AD users to AD group, it will reduce the maintenance task of gallery admin, since gallery admin don't need to grant rights in the gallery directly.
We have the Local License Server installed. Right now, if a Designer user changes roles, or leaves the company, they have to release their license from their client-side machine. If they don't release it properly, and IT can't get us into their machines, then we have to wait 7 days for that license to roll off the server. There should be a way for a system admin to forcefully revoke someone's license.