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 Knowledge Base

Definitive answers from Server experts.

Jobs stuck in queue

MichaelAd
Alteryx
Alteryx
Created

Environment Details


In certain situations scheduled workflows will stay queued.
  • Server
    • All 


Cause


Cause A


The Service Account AlteryxService.exe has insufficient permissions.
 

 

Cause B


None of the Server nodes has the option "Run unassigned jobs" ticked in System Settings > Worker > General.



Resolution


Solution A


Make sure AlteryxService.exe is running under a Service Account with the permissions listed in https://help.alteryx.com/server/current/admin/Configuration/RunasPermissions.htm.
 

 

Solution B


Make sure at least one Worker node has the option "Run unassigned jobs" ticked.

 

Additional Resources

 

KB Article: Error: Workflows Queued - 500 Server Error Key fields must be a WString AS Schedules ID
Help Doc: Required Run As User Permissions

Comments
mfresques
6 - Meteoroid

I ran into this problem with all our Jobs getting stuck as Queued.  After many hours of investigation, it turned out we had a workflow event command unable to finish processing it's task causing a log jam of queued workflows on our Server's designer.

 

So I'd like to offer up a Solution C:

 

Check for Queued jobs on your server's designer by going to Options --> View Scheduals --> Queue

 

mfresques_0-1648044744291.png

 

In our case, you could see where the event command kicked off a workflow that couldn't finish so it remaind as Queued in this window.  We cleared the Queue and restarted the Alteryx Services*.  This allowed all our other workfows to be begin running and complete. 

 

*To restart your Alteryx Services go to the Start window --> Administrative Tools --> Services --> Alteryx Services --> right click Restart

mfresques_1-1648045179907.png

 

Marcus