Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Schedule status = queue

prpatel
11 - Bolide

I have a workflow that I setup a schedule to run every 15 minutes past the hour.

 

It takes excel files from a sharePoint site, does what it needs to then dump to an Azure Data Lake Storage, Gen2. 

 

Because I dump to Azure, the Azure fileout out tool requires the AMP Engine to be running.

 

When I look at the workflow to see if it has been executed, I do not see a status symbol (green = good; red = not good), instead, I see a gray clock, that looks like this....

 

prpatel_0-1664989302016.png

When I hover over the gray clock, I see this...

prpatel_1-1664989352447.png

 

 

What does this mean?  It it run successfully?  If so, how can I tell?  If it did not...how can I tell?

 

Thanks....really confused on this one.

 

-Prpatel.

13 REPLIES 13
Kakuffo
Alteryx
Alteryx

Hi @prpatel 

 

Have you enabled schedules globally and on the user level?

1. Configuration page: https://help.alteryx.com/20221/server/alteryx-server-configuration

2. Users page - each user needs to have this permission enabled: https://help.alteryx.com/20221/server/user-roles-and-permissions

prpatel
11 - Bolide

Yes...I've already done that.

fmvizcaino
17 - Castor
17 - Castor

Hey @prpatel ,

 

What does this mean? This means that the workflow is stuck on the queue waiting to be executed. 

It it run successfully? No

If so, how can I tell? The green status

If it did not...how can I tell? The red status

 

 

 

For workflows stuck in the queue, a few reasons:

  1. You already have other workflows being executed and this one is waiting in the queue to be executed next.
  2. Your Alteryx server doesn't have the AMP enabled in the system settings configuration, so the workflow will never run. You need to enable in two different places. 
    1. If workflows with AMP engine disabled are running successfully, this could be the reason.
    2. https://help.alteryx.com/20221/server/controller
    3. https://help.alteryx.com/20221/server/engine
  3. If none of the above works for you, restarting the Alteryx Service could help correct it.

Best,

Fernando Vizcaino

prpatel
11 - Bolide

Hi.

 

Nothing works.

I'm running a test workflow whereby I take a dataset from SharePoint and place it in my ADLS.  The Azure output file tool needs the AMP engine on.

 

Very simple workflow.

 

AMP Engine is checked in the server properties as well as checked in the workflow.

 

I'm running the workflow manually to test it out, and the status bar is showing as "queued to run".  Its been like this for the past 30 minutes.

 

 

fmvizcaino
17 - Castor
17 - Castor

Hi @prpatel ,

 

Are you able to run workflows with the AMP engine disabled?

In the system settings, did you configure the controller and the engine?

fmvizcaino_1-1665430393095.png

 

fmvizcaino_0-1665430370802.png

 

prpatel
11 - Bolide

@fmvizcaino 

I have other workflows that do not output datasets to my Azure DL, and they work fine.  It's just the ones that output data to my Azure DL that are having problems.

 

Let me go back and check for the Engine "Both Engine" options.

 

I'll need help from my IT guys.  I'll revert back soon.

 

Thanks.

 

-prpatel.

prpatel
11 - Bolide

That worked!!! When I selected both engines, I got it going, but then the workflow failed due to it not finding the azure tool, see below....

prpatel_0-1665432557576.png

but I know its added to the designer that is on my server...any thoughts as to why I'm getting this error?

fmvizcaino
17 - Castor
17 - Castor

Hey @prpatel ,

 

The best option is to install the connector for all users in your server. Here is a link showing how to do it.

https://help.alteryx.com/20221/server/install-connectors-and-custom-tools

 

Best,

Fernando Vizcaino

prpatel
11 - Bolide

thank you....that helped, but now more issues....

 

The flow worked well in Designer, but now when validating and uploading to server, I get these errors....

prpatel_0-1665435341934.png

...but workflow works well in designer, like I said.

 

Running in designer I get the same failure as above.  

 

Any thoughts...?