topic Re: Alteryx Issue: Schedule not running as per next schedule time in Alteryx Server Discussions

Alteryx Issue: Schedule not running as per next schedule time

Sachit — Tue, 03 Sep 2019 23:45:33 GMT

Alteryx Issue: Schedule not running as per next schedule time (its showing state = completed next run = Never)

We have Alteryx jobs scheduled every 10 min, after running few iterations, in last run Suddenly it Changed to Never and State is Completed

We tried with the putting the end date but still it is having same issue.

Please advice why this issue is occurring?

Re: Alteryx Issue: Schedule not running as per next schedule time

jrgo — Thu, 05 Sep 2019 17:46:37 GMT

Hi @Sachit

I don't know if Server is still designed to do this, but I remember that the scheduler, before it was moved into the Gallery, would "Complete" a schedule if the job returned certain errors.

Are you able to confirm that the last job for that workflow did complete without errors?

And this may not be the case for you, but it's hard to say without troubleshooting the behavior more. If the problem continues, I'd suggest contacting support.

Regards,

Jimmy
Teknion Data Solutions

Re: Alteryx Issue: Schedule not running as per next schedule time

Paul_Holden — Wed, 22 Apr 2020 15:31:48 GMT

I have been investigating the same issue on one of our Alteryx servers, where four schedules failed on the same day.

The last scheduled run did not get correctly recorded - at least it does not show if I run the Alteryx Server Usage Report, only the penultimate run shows.

Checking in the server Event Viewer I can see the following errors that coincide with the times of the failures (last run time on the Scheduler view).

I can't match the ids up with the schedules or workflows but his would appear to be the root cause of the issue.

I have advised our BI team to recreate the schedules.

Error - There was a corrupt record: 5c371e9bebf3d113bc06e879 - PersistenceContainer_MongoDBImpl_Get_Error: Record identifier is invalid <5e7cf832ebf3d110a402c70a> collection <AS_Queue>

Error - There was a corrupt record: 5c18ed4febf3d113bc0356bd - PersistenceContainer_MongoDBImpl_Get_Error: Record identifier is invalid <5e7cfc04ebf3d110a402c754> collection <AS_Queue>

Error - There was a corrupt record: 5bfed44debf3d113bc015e5f - PersistenceContainer_MongoDBImpl_Get_Error: Record identifier is invalid <5e7cfcf6ebf3d110a402c76f> collection <AS_Queue>

Error - There was a corrupt record: 5c18edb1ebf3d113bc0356cc - PersistenceContainer_MongoDBImpl_Get_Error: Record identifier is invalid <5e7d033aebf3d110a402c7c3> collection <AS_Queue>

Versions

Client: 2018.3.51585
Server: 2018.3.4.51585
Server Binaries: 2018.3.4.51585
Service Layer
- Master: 2018.3.4.51585

Re: Alteryx Issue: Schedule not running as per next schedule time

preeti121288 — Wed, 13 Jan 2021 13:15:31 GMT

I am also facing same issue with my workflow schedules. do we have any solution for this? is it known issue to alteryx ?

Re: Alteryx Issue: Schedule not running as per next schedule time

Paul_Holden — Wed, 13 Jan 2021 14:06:25 GMT

What version of Alteryx server are you using?

I know of some issues relating to 2018.x but I don't know if they apply to later versions.

Re: Alteryx Issue: Schedule not running as per next schedule time

preeti121288 — Wed, 13 Jan 2021 15:46:16 GMT

we are using 2019.x version. Please tell me issue related to 2018.x.

Thanks

Re: Alteryx Issue: Schedule not running as per next schedule time

Paul_Holden — Wed, 13 Jan 2021 15:28:11 GMT

We had the same issue with open ended schedules being marked as complete.

We did not work out exactly what was happening. There were a few errors in the server Event log but we could not correlate those to the failures the the last time the workflows ran, or were supposed to run.

We ended up creating replacement schedules and removing the old ones. At about the same time we also increased the RAM on the server. Although Windows was not reporting any particular memory exhaustion this did seem to provide some performance improvement and we saw less queuing of jobs which might be relevant to our case (but won't be the same in 2020.x), see below.

I was expecting to catch the cause the next time it happened but we have not had a recurrence since we set up the new schedules and increased the host server RAM.

The known issue on 2018.x is that the Scheduler seems to "lose track" once there are a certain number of jobs queued. This results in jobs being processed in LIFO order, as opposed to the FIFO order that should be happening, and thus jobs can get stuck at the front of the queue for a long time.

My understanding is that this specific issue was fixed in 2019 and subsequent versions.

The jobs that we had schedule problems with are frequently running, every 10 minutes, and so were experiencing the stuck queue issue more than others. It's not clear if that then caused the problem with the schedules but I am suspicious that they might be related since both issues went away at the same time.

Re: Alteryx Issue: Schedule not running as per next schedule time

sameerpremji — Thu, 25 Mar 2021 20:44:44 GMT

Apparently, this issue is back in Server version 2021.1 as we're encountering this a few days after the upgrade from version 2020.3.

@LisaL @Tonya_Smith

Re: Alteryx Issue: Schedule not running as per next schedule time

Tonya_Smith — Fri, 26 Mar 2021 21:41:43 GMT

@sameerpremji

This looks like Server. I'm the TPM on Engine.

I will send the link to the Server folks.

Re: Alteryx Issue: Schedule not running as per next schedule time

KevinP — Fri, 26 Mar 2021 22:35:58 GMT

@sameerpremji Please ensure you are running the latest release of Server 2021.1 (2021.1.4.26400) as there was an issue with the initial release that would cause jobs using gallery data connections to fail or get stuck which could be contributing to your issue. If you are still having issues with schedules moving to a completed state unexpectedly after updating to this version please open a support request to investigate what is happening in your environment to cause this.

Re: Alteryx Issue: Schedule not running as per next schedule time

sameerpremji — Sat, 27 Mar 2021 00:39:17 GMT

Thanks @KevinP , we just upgraded the server to the latest build 2021.1.4.26400, as per your instructions.