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

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

Schedule

Server

Scheduler

Accepted answers

All comments

mbarone

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

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

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

Hi @mbarone ,

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

workflow_log_error.PNG

mbarone

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

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

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

ashokkumar1

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

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.

ashokkumar1

Hi @mbarone ,

Sorry for the delayed response,

The workflow is with User and can we suggest same steps to User to follow? User is using local/shared connection in his workflow which i could not able to connect while running those designer in Server.

Please suggest if any way that we can follow Thank you

mbarone

My suggestion is for "someone" (you, the user, your IT group, your security department) to remote into the server, open the workflow in Designer, check the Enable Performance Profiling button, then click Run and watch the dialogue that is generated in the Messages pane. That will tell you where the workflow is getting stuck.

ashokkumar1

Hi @mbarone ,

Check that and top processing tool info as listed below.

please find the attachment.

issue_alteryx.PNG

mbarone

Not surprising to me. The Data Cleansing tool takes a lot of resources. I personally never use it, and prefer to use a multi-formula tool to make whatever cleansing I need. Calgary Input always takes a lot because they are usually very large files. Your network connection, your CPUs, and your RAM all make a difference on speed. I don't use Tableau so I can't speak to that but it seems it's using very little resources.

I'd suggest to start with using the Multi-Field tool (or multiple) and cleanse your data that way instead of the data cleansing tool. And again, nothing you can do about the Calgary input taking so long (it's all based on your server/network architecture which is probably not controlled by you).

ashokkumar1

Hi @mbarone ,

Can you please suggest? is it the solution? or anything you can suggest for now from Alteryx Gallery? I dont know much on Designer so if you can suggest anything it will helpful for me Thanks in advance.

mbarone

I don't know if it's a solution or not. It's just a suggestion. In a perfect world, you can have a server with 100 CPUs, and 1TB of RAM, and a very fast no-latency network connection. I don't know how to do that - you'd have to talk to your IT team.

From a designer standpoint, you could try converting whatever you're doing with the data cleanse tool into formulas to be used in a multi-field formula tool(s). I can't really give too much more than that without seeing what those data cleanse tools are doing.

ashokkumar1

Thank you for the immediate responses and help @mbarone

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703