Hello community,
Our organization is currently experiencing a very annoying issue with scheduled workflows on the Alteryx server which we have not been able to resolve. So far support has not come up with a solution either, so I am now posting here in the community forum hoping that someone might have seen this issue before.
Short description of the issue:
We are running an Alteryx Server with Gallery, which we use to schedule workflows. On a frequent basis - but with no apparent pattern - we see that all our scheduled workflows simultaneously goes from the "Active" state and into being "Disabled" (see image below). When we click "edit schedule" on the disabled workflows it shows this error in red text: "The workflow cannot be accessed. Request access or delete the schedule." The admin then have to re-enable all scheduled workflows manually by checking the "Enable this schedule" box.
As mentioned, we have not found any cause or pattern for this to happen - sometimes it happens within a week, sometimes a month.
Our setup and what we have tried:
Alteryx server version: 2018.4.5.55178
Alteryx Designer version: 2018.4.3.54046
We have a handful of users (Artisans) who schedule workflows from their Alteryx Designer and onto our internal Alteryx Server Gallery. We use "built in authentication" which enables us to lookup users in our current AD and let them run workflows in their own user context (after they have supplied their AD credentials in the "Workflow credentials" admin section).
The scheduled workflows seem to run fine for quite a while (sometimes a few weeks, sometimes a month), but then at some point they all simultaneously change to the "Disabled" state. We have investigated and tried the following:
If anyone has seen this issue before, or have any input for the troubleshooting I would be very happy to hear it!
Thank you
For my problem I think we traced it back to credential management in that the scheduled workflow has password protected Oracle database. The designers credentials are encrypted to the workflow, so to manage this we will have to disable the schedule, download the workflow to desktop, relink the input using new credentials, resave to server, and then reschedule.
We are looking into using Gallery Connection XML to ease this pain.
Hello everyone,
Just wanted to give an update on this issue and the original post from 2019.
We never found a real solution to the issue but our organization moved our Alteryx server setup from an internal data center to the cloud in the fall of 2020. We installed the latest 2020 version of the Server application and fortunately we have not seen this specific issue since.
Thank you for all the inputs!
Best regards
Has there been any other movement / discovery on this issue?
We are on Alteryx 2021.3 and I am seeing this behavior of my scheduled workflows getting randomly disabled.
We have had this issue as well in earlier versions of Alteryx like 2018 and 2019 and upgrading has fixed this issue.
We are having this issue on server version 2022.1.1.42619. I assume no resolution or cause has ever been found in all these years? I believe our admins have a ticket open but if anyone here has a resolution, please do share!