Workflow running in Gallery since long time but no responses
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
A user tried to run a workflow (which works fine on his local designer) but seems to run continuously on the Server’s Gallery. I found no options to cancel the long running job, so stopped Alteryx service & restarted again.
The workflow is not throwing any error messages in Gallery, just showing running since long time.
What should I check? How can I fix this?
Please help.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @EN6924 ,
Does this workflow connect to an external data source or something like that?
Do you have access to the server`s designer? A good test would be to run from that designer so you can see where the delay is occurring.
Best regards,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi fmvizcaino
Yes, I have access to the server's designer but not to the workflow. The workflow has been designed and tested by a business user and he raised the query. It's running completely fine in his designer desktop, but in Gallery it's showing only running since long time but nothing appears in result.
Yes the workflow connects data from a shared drive.
When I examined, I discovered that the service account that Alteryx has been utilizing does not have read-write access to the shared drive where the data files are stored. Is this the problem or is there another one?
Please assist.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @EN6924 ,
The workflow will throw an error if it were an access issue, but since this is a very weird behavior, let`s test if that is the case.
What is your Alteryx Server version?
Here are some ideas:
- AMP engine: Ask the user to enable/disable the AMP engine and check the results. Sometimes your server doesn`t allow AMP engine and the workflow will stay in the queue
- Access issues:
- Since you mentioned the service account not having access, ask the user to send the files with the workflow when publishing instead of reading from a shared folder so that you can eliminate this as an issue or
- Ask the user to simplify the workflow and only add an input and an output to a shared folder to check if that works
Best regards,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have the same problem with the alteryx version 2022.1. The workflow is running fine in the local designer but not working well in the gallery. There is no access issue. But the reading time of the data from the database differs between the gallery schedule and the local run. How can we fix this issue? It's SQL server and I tried the SQL server and native client odbc connection as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @srajkumarece ,
Are you using a service account or Windows authentication? Does your server has a service account or run as credentials?
If you can, please access the Server`s designer and check if the performance issue is also occurring there.
Best,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How did you resolve it and can you explain it what are the tools used
