Free Trial

Alteryx Server Discussions

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

Scheduled workflow on the server are running but stuck at 0%

kc03
7 - Meteor

Hi

 

I have workflows scheduled on the server which were running fine before. Suddenly they are stuck at 0 percent running stage when I checked in the queue . When I run the same workflows on the server manually, they ran successfully. Attaching screenshots for reference. Can anyone help?

 

Scheduler Server

 

kc03_0-1625650060136.png

kc03_2-1625650082910.png

 

16 REPLIES 16
mbarone
16 - Nebula
16 - Nebula

Maybe stop the jobs and check the logs to see what step(s) they are stuck at.  That would be my first stab at it.

ashokkumar1
8 - Asteroid

Hi @mbarone ,

 

May i know how to check the logs exactly? i am bit new to Gallery wanted to know about this process. I am facing same as one of the workflow stuck in the same level once i stop the workflow there 3 to 4 log files in gallery for today can you help me on the same please?

mbarone
16 - Nebula
16 - Nebula

Engine logs on your server will be stored wherever you coded the following field to:

2022-06-30 10_57_34-Window.png

 

You'll have to parse through the logs (open them up and read them or build a Workflow to parse through them), and that should at least tell you what step it stopped at (it'd be the last step in the log).

ashokkumar1
8 - Asteroid

Hi @mbarone ,

 

Thank you for the response. I tried open that log  but it shows below error. please check.

mbarone
16 - Nebula
16 - Nebula

Are you certain that's the log associated with the workflow that you stopped?  Did you stop the workflow while it was stuck at 0% in the queue?

ashokkumar1
8 - Asteroid

Hi @mbarone 

 

Yes i aborted that, due to this log is not available? if this is case how come we will know in which step workflow hanging? please let me know

mbarone
16 - Nebula
16 - Nebula

Can you open other logs?  If you stopped the job, the log shouldn't be locked.  

ashokkumar1
8 - Asteroid

HI @mbarone ,

 

Yes i am able to open other log files (either finished or failed), even i ran that job now and  i aborted i cant even see the log file generated corresponding to that Job. I am not sure about locking the log file.

 

One more question is can i delete older log files under this path? I usually remove log files from Gallery but not from this path. please help me.

mbarone
16 - Nebula
16 - Nebula

Yes, you can manually delete any log files you want in that folder.

 

It must not be producing a log file at all since it was cancelled.  That job is running on a server, correct?  If so, can you remote into it?  If you can, I would try opening the workflow in Designer on the server, going to the Runtime tab in the configuration, checking the box "enable performance profiling", and clicking Run.  And keep your eye on the messages as it runs.  That will tell you where it's having trouble, and it will also tell you how much processing power each step is using.