I've seen various solutions/workarounds but this seems to be a table-stakes ask? When scheduling a workflow I should be able to specify which parameter values to run with. Just two of many use case examples -
Use case #1 - a single analytic app could be scheduled multiple times, each schedule specifying a different line of business
Use case #2 - credentials, allow the user to schedule a workflow with their saved credentials. When their credentials change all they would have to do is update the schedule parameters
(If you know a better way I'm all ears, not the API thought that isn't a bad way to do it, just not super Easy)
I would like to see the enhancement of being able to schedule a start and stop time for specific jobs that need to run multiple times per day, so they don't run during the nightly backup periods of the Alteryx server. This can cause the daily backups of the Alteryx Gallery to fail. Currently SQL Server Management Studio/SQL Server has the function to able to schedule start and stop times for specific job. Currently Scheduler page on Alteryx Gallery/Server lacks this feature.
SQL Server Management Studio
Schedules on Alteryx Gallery/Server
Using current version of the server - you can see that there is no OAuth managed or published API endpoint for canvas delete (screenshot 1). However this API does CLEARLY exist as you can see if you inspect what happens when you hit the delete button (screenshot 2 clearly shows the API being called - but it requires user login security token)
Please can you enable this API for OAuth - the API already exists, it just needs to be exposed with the others.
I would like to set a retry count when scheduling a job, and also to specify to duration in between retries, e.g. job fails, but then will retry to run 3 times with a 5 minute wait in between each retry.
Also would like a radio button next to all workflow results, so when you get a list of failed jobs you can click all the jobs and then hit rerun. This should be complimented with select all functionality. This will prevent me from having to go into each job and rerunning, i.e. save me loadsa clicks!
We would like a built-in process that would search or, and resolve, workflows that are stuck in the "initializing" state. These seem to happen for various reasons but communication problems between the controller and workers .. usually a socket timeout.. which appears to be most problematic. It seems that these type of errors should be expected in all but the most stable environments,
Currently, the only tool that we have to solve this problem is to restart the Alteryx Service on the controller and while this works there tendency to cause some collateral damage in workflows ...erroring or restarting from their beginning.
There may be a way to solve this without restarting the service by editing Mongo using a tool like Robo 3T but that is unproven and has its own risk.
After dealing with this issue and struggling for quiet some time we think that the best option is to implement a "clean up" DB process that will run every 5 min or so, capture a list of workflows in the "initializing" state , then compare that list to one in the next 5 min cycle and fix any workflows that appear in both lists. We think that returning any stuck workflows to the queued state would be the best Fix option.
We just don't want to continue to use Restart the Service process to solve this issue and accept the collateral damage.
Thank you for your consideration
This may be a little controversial. As of today, when you buy an Alteryx Server, the basic package covers up to 4 cores :
I have always known that. But these last years, the technology, the world has evolved. Especially the number of cores in a server. As an example, AMD Epyc CPU for server begin at 8 cores :
So the idea is to update the number of cores in initial package for 8 or even 16 cores. It would :
-make Alteryx more competitive
-cost only very few money
-end some user frustration
Moreover, Alteryx Server Additional Capacity license should be 4 cores.
It would be good to have a new field with the owner of the data connection, when users asks to be part of a data connection, we should know who is the identified owner to contact and ask for approval.
In prior versions, Gallery Admins could easily and quickly reactivate users that were deactivated (e.g., and employee leaves the company so we inactivate their Gallery account, but then they come back to the company in a few months with the same name and email).
Now, the only way to do this is to edit the Mongo page.
We need a way via the UI to reactivate users, like we did in the old UI.
I suggest adding an option in the current User List/Grid to be able to filter for Inactive users.
I am in the process of migrating apps from the old gallery to the new. I have screen captures of the results from the same app in both. In the older gallery version, if there is only a single file type available, it defaults to that file type and you click the icon for the type. In the new gallery version, you must select a file type before you can download the file, even if there is only a single type available. The dropdown makes sense for one that you have multiple types (like pcxml), but it makes no sense to require the user to go through an extra step to select a type before downloading when that's the only type they can download. Please see all the screen captures. The blue-ish background is from the new gallery.
We leverage Active Directory groups to manage user permissions to most of our company's resources like databases, file shares, applications, etc. This idea is for the ability to manage a Gallery Data Connection via an Active Directory group. In many cases, our AD group membership actually dictates what permissions a gallery connection should have, but we must manually add/remove users to the Alteryx connection to keep it synched with AD.
I think there are several ways Alteryx could be enhanced to support this; i.e. the AD group could be specified on the connection itself or it could be inherited from a Studio where the subscription is enhanced to support assigning AD groups to it (which could benefit other areas of Alteryx).
I'm told by Alteryx support that this functionality is unsupported but to post the idea here. If anyone knows of workarounds to this limitation I'd certainly be interested!
Issue: When Workflow names have similar beginnings on server a user cannot distinguish between them because the columns on this GUI are not expandable as would be expected. A user has to make their browser larger and all columns open proportionately.
Solution: Change column settings so users can drag column widths to make changes. A bonus would be to allow a user to set a default along with an option to always auto expand all.
Hello, I would like improved user management features and/or training
The publishing endpoint, a POST to api/admin/v1/workflows/, is useless whenever workflows, apps, or macros contain Gallery Data Connections. The workflow will get published but valid Gallery Data Connections are ignored and the apps will not run.
Please add the same dependency checks against Gallery Data Connections as is performed when a workflow or app is manually published from Designer.
This might be considered a subset of the Idea Server API to extract / submit workflows.
Thank you for your consideration.
Add Admin ability to place the Alteryx Service (Engine) into Maintenance mode allowing current workflows to complete, but all new workflow processing moved into Queue to allow for server configuration and/or maintenance.
Currently, if I want to make a small configuration change (like a memory setting in the Runtime settings) I have to hunt for a quiet window or the lowest level of activity to kill the service (and the running jobs).
It would be helpful to flip a 'switch' and have all new jobs go into 'Queue' allowing for the change and service stop/restart ... then pick right back up with the queue in configured order. (execution time, priority level, etc...)
We have situations where some workflows that are scheduled end up having intermittent connection issues to other databases that result in the workflow running to timeout. The timeout settings are set in the server, but it would be nice if you could set an override value for a lesser timeout in the runtime settings for individual workflows and basically use the server setting as a not to exceed value. We have a multi-node environment with multiple worker nodes and about 250 artisans. We have some regularly scheduled workflows taking the full amount of time in the timeout setting and obviously if a couple of normally quick running workflows ran to timeout that causes issues with the queue.
Ability to change the default workflow settings when to also include [Others may view this workflow's history] in a similar way to the other attributes in workflow settings that are set by default. This would prove beneficial for workflows which are shared across a large team and need to be run on a consistent frequency and are not run headless. The inability to set this by default leaves a risk that the setting remains unchecked and more than one user triggers that workflow in a given month which could result in a material impact if the output of that workflow is posting to another system in the firm.
When saving to our company's gallery, we must deselect dozens of assets for our numerous workflows every time they need to be resaved, which is very frequent.
I would like to suggest a select/deselect all button under manage workflow assets. This would save a considerable amount of time.
Hello Alteryx team,
I would like to propose idea that was mentioned on the community but there is no solution either.
The issue is related to Qlik Analytics Samples and error that it is causing with wrong path error for default macros like eg.CountRecords.
I’m facing issues with scheduling workflow in Europe/London timing. I’m trying to schedule jobs to run at 10pm UK hours everyday (except Fri and Sat) starting from today i.e. 26th Jan (as per UK timing)
However since I’m in India and my local desktop is showing India time (which is 00:15hrs on 27th Jan), the Alteryx Gallery scheduler is picking India hours but not as per the region we selected. The 26th Jan date is greyed out and unable to select.
The workaround for this to change local time on desktop which is not in our control in our case.
Could you please bring a change in this behavior. If I am am scheduling on x date a workflow for a timezone which is x-1 the scheduler should allow me to set up the schedule.
We have been building a solution for a client that involved chaining apps. When we uploaded the workflow to the server, we got the below error: Workflow exceeded maximum runtime of 30 seconds and was cancelled. We were able to rectify this by having the client implement the change here. While I understand the need for the limit, is there any plan to have this fix be more obvious to the average user to implement or avoid needing to reimplement following a server upgrade?
I Would Like a new Email added under [ Admin -> Notifications -> Emails ] where it would send an Email when a Schedule reaches the status "Complete"
This can serve a couple of use cases;
I am an Artisan but not the Owner of the studio - I uploaded the workflow and would like to see all the jobs (including manually triggered) that run for my workflow so I can track any issues i.e. when workflow fails. I checked with the Owner of the studio and he also can see only the runs he triggered.
I understand from the Support team in my company that option to see all the jobs that run is currently available only for the Curator role but would be extremely helpful if you would make it available to all the users that have access to the Private Studio.
When we download from the gallery, please return both the altered gallery code and the original unaltered code so user can choose the base to build next version on.
Most everyone learns the hard way that saving to the gallery alters their code in ways that it may no longer work as it did before when running on desktop. After figuring out what has happened and laboriously un-doing the alterations that happen when saving to the gallery, we develop schemes to keep separate desktop versions of gallery apps in sync. These schemes should not be necessary.