topic Re: Processing Time showing 0.0 seconds in Scheduler in Alteryx Server Discussions

Processing Time showing 0.0 seconds in Scheduler

rahuls — Thu, 24 May 2018 01:15:21 GMT

Hi,

I am facing a strange issue in the scheduled workflows. Sometimes, the workflows runs but the execution/processing time comes out to be 0.0 seconds. I can clearly see that the workflow took more than 10 mins to run but the execution time comes out to be 0.0 seconds for some reason. See below:

Anybody else facing the similar issue? Would really appreciate any leads.

PS: I am using Alteryx 11.0

Thanks,

Rahul

Re: Processing Time showing 0.0 seconds in Scheduler

derekbelyea — Tue, 27 Feb 2018 20:59:15 GMT

Is the error message a hint? Does this only happen when there are errors in the execution?

Re: Processing Time showing 0.0 seconds in Scheduler

rahuls — Wed, 28 Feb 2018 05:51:51 GMT

Hi @derekbelyea,

So far, no errors in the workflows. It happens randomly. While on some days the workflows would run fine and show correct processing time, other days I see 0.0 seconds. There are no errors in the run.

Thanks,

Rahul

Re: Processing Time showing 0.0 seconds in Scheduler

derekbelyea — Thu, 01 Mar 2018 00:27:24 GMT

Hi @rahuls

If this problem was mine I would collect up the logs and arrange a consultation with one of the Alteryx system engineers. Intermittent errors that cannot be consistently replicated are the most insidious and hardest to diagnose.

Derek

Re: Processing Time showing 0.0 seconds in Scheduler

wrp — Tue, 24 Apr 2018 13:34:44 GMT

Did you get a solution to this issue? We are seeing the same behavior in our scheduler for all jobs executing for the last 2 days.

We are using Alteryx 2018.1

Re: Processing Time showing 0.0 seconds in Scheduler

rahuls — Wed, 25 Apr 2018 05:47:03 GMT

It got resolved when we did some cleanup of drives, seemed like a memory issue. Haven't been able to reproduce after that.

Best,

Rahul

Re: Processing Time showing 0.0 seconds in Scheduler

wrp — Wed, 25 Apr 2018 13:54:40 GMT

Per Alteryx Support, we rebooted our Alteryx Server to resolve this issue.

Re: Processing Time showing 0.0 seconds in Scheduler

wrp — Sun, 27 Jan 2019 14:59:21 GMT

Has anyone seen a resolution to this issue beyond the "reboot the server" solution?

We are now on Alteryx Server 2018.3 and were hoping after upgrade we would no longer see this problem, but it still happening around once per month.

Re: Processing Time showing 0.0 seconds in Scheduler

mcha54 — Wed, 11 Sep 2019 17:35:19 GMT

Hi! Were you able to find what the issue was? We've started experiencing this with our Scheduler where the Execution time is 0.0 seconds, which is not accurate.

Re: Processing Time showing 0.0 seconds in Scheduler

wrp — Wed, 11 Sep 2019 17:37:55 GMT

No, unfortunately, no resolution, but we are still on 2018.3 so upgraded servers may have this fixed.

We still just reboot the server during a low scheduler queue time to resolve the issue. Sorry I can't be more helpful.

- W

Re: Processing Time showing 0.0 seconds in Scheduler

mcha54 — Wed, 11 Sep 2019 17:39:50 GMT

Ok, thank you! We are also still on 2018.3. Rebooting seems like a solution we'll do now too.

Re: Processing Time showing 0.0 seconds in Scheduler

veruzi — Wed, 03 Jun 2020 12:40:56 GMT

Same issue in 2020.1 - our Monitoring reports show imprecise data due to this as all Execution times are defaulted to 0 seconds.