We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Server Ideas

Share your Server product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Featured Ideas

0 Likes

It would be helpful to be able to schedule blackout times on the gallery (when users cannot run or schedule jobs), so that the MongoDB can be backed up on a regular schedule without interrupting scheduled jobs.

One of our Server customers has a need to disable all schedules temporarily across all worker nodes.  I do not see an easy way to do this unless we go into each worker's settings and disable from there, but this is not ideal.

 

The reason is for scheduled maintenance windows during a large upgrade or migration.  Currently stopping the Alteryx Service on each worker is time consuming.

 

Thank you! 

0 Likes

More of our customers (we are a premier partner) have Servers with multiple worker nodes.  If a custom macro is needed, currently it has to be added manually on each worker node. 

 

Would love to see a feature in the Admin portal that allows for the upload and distribution of custom macros to all or select workers. 

currently, there isn't any way to fully delete (safely) a user from the gallery. So if there is a previous client or previous employee in gallery, we cannot clean up the gallery settings - only "disable". It would be great to have a "trash can" symbol next to the users where we can remove them from the server and keep all of the users clean. 

0 Likes

We currently have routine server maintenance that happens every Sunday morning. Currently users do not have the ability to schedule around that outage window without significant headache in managing their schedules to run the same Monday - Saturday, but then skip a few hour window on Sundays. Most users simply do not comply which puts manually intervention on the admin side to stop the Alteryx Service and then purge the Mongo Db file so we don't get the 'Check the mongod.lock file is > 0KB in size'.

 

It would be great to either allow more robust scheduling at the user level (pick days of week and frequency per day) and/or to give admins the ability to create an outage window that prevents workflows from running during a designated time period.

0 Likes

The Gallery currently only enables scheduling of the latest version of a workflow, regardless of the published version - for instance, if there are two versions of a workflow and Version 1 is the published version, only Version 2 can be scheduled since it is more recent. There is no straightforward way to schedule Version 1.

 

Currently two workarounds are to:

1) download the older (published) version, export to Designer, and then save as an entirely new workflow in Gallery.

2) re-save the local Designer file of the older (published) workflow as the most recent version in Gallery, for example re-saving Version 1 as Version 3 so that "Version 1" can be scheduled.

 

The ability to publish and schedule older workflow versions would be a helpful new feature to add to Gallery, as this would avoid the need to re-create or duplicate workflows simply because the most recent version has an unexpected issue that the previous version does not have.

When a render tool is run on Designer pointed to a temporary file the log gives you a clickable link to access the output.  When deployed to the Gallery unless you have given it a specific output destination with %temp% in the filename you get... nothing.  

 

What did I expect?  The pdf or other temp file to render on the screen or at least download for me.  Or give me a dropdown selection of the various files render could create for me.

2021-09-29_15-20-05.png

 

When a user publishes and schedules a workflow on the gallery, they have the option to specify their time zone to ensure that the execution of the workflow occurs at the appropriate time. However, if the workflow invokes the DateTimeNow() function, the captured time is in UTC. If it is important for the end-user to have that time that is captured be in their local time zone, they will need to manually (either within the workflow or as a user input for an Analytic App) specify the offset from UTC.

 

Instead, there should be an Engine variable that captures the offset (or the time zone) that the workflow was executed from (or scheduled in), which can dynamically adjust the DateTimeNow() output appropriately.

The current Gallery API executes a job until it reaches a completion state with either success or failure.  Once reaching that state, the callout to /v1/jobs/{jobId}/ will return an array of messages that can then be parsed to gather information about the execution of the job, similar to the output you see in designer or via the CLI when running a job directly.

 

It would be nice if the callout to the jobs endpoint would constantly update and return the messages array with each callout.  With jobs that take longer to execute, our Gallery API wrapper could then report back to us and let us know what messages have come out as the jobs runs.  For example, if a process takes 2 hours to execute, we might want to know how far along the job is or if it has met a special condition that will cause it to run longer, etc.  To do that, we could add in message tools that report info messages to us.  Unfortunately, these messages are ineffective if we are running via the API because we won't see them until the job has fully completed.

0 Likes

Very Simple Request.

 

Just like how you can search for a collection, we would like to be able to search for a schedule. One team has over 5 pages of schedules and it would be nice for them to search for one to update vs having to scroll through 5 pages to find it

 

Search Bar in Schedules.jpg

0 Likes

Currently, we have the functionality to set a recurring schedule with daily frequency with an option to 'Run only during work week (Mon-Fri)' I would like to add this 'Run only during work week (Mon-Fri)' option to the Hourly frequency interface. 

 

Tony_Castillo_0-1630671237931.png

 

No current option to run on weekdays only:

Tony_Castillo_1-1630671308224.png

 

0 Likes

As per design Alteryx Server retains all FAILED jobs in the Queue and Results collections even when we set the server to keep run history and results for x days

 

Purging records from Designer involves manual activity

 

Proposing the idea of purging these error records through automation script:

 

Step 1: Stop Alteryx Server

Step 2: Backup Mongo DB

Step 3: Replace big size files: AS_ResultsFiles.Files.bson, AS_Results.bson, AS_ResultsFiles.bson, AS_Queue.bson with Empty .bson files of same name in the backup/AlteryxService

Step 4: restore MongoDB from the backup (with the replaced files

Step 5: restart Alteryx service.

0 Likes

Our company prefers to setup active directory groups to manager our users and resources separately for better tracking of what a group has access to.  We setup global group roles with users as members and local groups with privileges to a resource and the role as a member. We would like to be able to use nested global groups in the User>groups and have it still setup the users once a nested group is setup. Attached his the priv group an role.  We were not able to login with the priv group, but could login once the role group was added.

Thanks

Hello,

We would like to have the option to configure the timeout of the manual running jobs, as already exists for the schedule jobs.

 

Regards

0 Likes

Hi Team,

 

Currently we are using python for calling Alteryx Gallery API. We have configured gallery API access according to Alteryx document to use the OAuth 1.0a  with oauth_signature_method="HMAC-SHA1".  However, other teams have concern on HMAC-SHA1 because it’s 64 encoding only and consider not security assurance. I suggest Alteryx team to use encryption with higher encoding like SHA256.

Thanks.

0 Likes

I try to keep my studio up to date and remove unwanted or older versions of workflows. Yesterday, I inadvertently delete a workflow by mistake and it hadn't saved a copy on my laptop.

 

Talking to your tech team, to my horror I discovered that there is no 'Recycle bin' on Alteryx server. There were suggestions of how to recover it, all of which I was very grateful, but a lot of work to rectify a mistake.

 

My suggestion is for a recycle bin in scheduler so when a mistake is made, you have the ability to retrieve your work. It could have a time limit setting to automatically empty the bin after a set period or size, deleting the oldest files first?

Currently, failed job results stay in the Mongo DB forever.  Please either make it adhere to the same coding in the Server Settings for "Delete queue and results after (days)" setting, or make it a separate option for failed jobs. 

0 Likes

Hello Brainstrust,

 

Small request here (i think) , we are exclusively using Alteryx Gallery to host and orchestrate workflows in our enterprise. 

 

As we are connecting to disparate datasources involving many odbc connections and file paths at times when we are configuring a new source on all of our workers there may be a misconfiguration or misstep in the implementation.

 

When this happens , there is an intermittent failure and unfortunately its not visible what worker ran the workflow, I know this is visible in the thick client scheduler experience but as we are trying to drive Gallery as the one user experience it would be good if it was visible here too... screen shot below.

 

adrianp112_0-1626335611175.png

 

 

 

As a Gallery Admin I would like to be able to add and remove a user from local groups on the User page.

I realise that this would only work for local groups and that AD groups would need to be excluded (and indicated as unavailable for editing)

 

 

Paul_Holden_1-1624525178113.png

 

On the Users page it is quick and easy to see what Role each user has - UNLESS they have been assigned the "Default" role in which case it will depend on Gallery Default Role and which Group(s) they are assigned to.

 

I propose an additional column be added to the page to show the Effective Role for each user. The purpose of this change is to allow an administrator to quickly and easily confirm the effective Role of any Gallery use by viewing the User page, without having to check the user's group membership and the Role assignment that those groups provide.

 

For those users with a assigned Role other than "Default" that value will obviously match the assigned Role.

 

For users assigned the "Default" Role the page should show the result that would be returned by the appropriate permission resolution code when determining their effective Role from the Group membership and the Gallery Default.

 

[Screen image is from 2020.4 - with my suggested positioning for Effective Role added]

 

Paul_Holden_1-1624523596953.png

 

As a further enhancement a set of checkboxes showing the value of the special permissions e.g. Create Collections, would be good but might require a more significant re-design of the page and would only be saving a single click. I suggest instead that it might be useful to have an enhanced filter view of users which allows an administrator to view e.g. all users who can Create Collections etc.

 

 

Top Liked Authors