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

No ratings
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