Jobs stuck in Initializing status

hody

I have two copies of the same job stuck in the Initializing status in Alteryx Server.  All scheduled jobs are now getting queued and not executing.  Multiple service restarts and server reboots have not resolved the issue.

I found this in the log file repeating many times:

"S:\Alteryx\Service\AlteryxService_Client\Persistence_MongoDB.cpp: 1558. PersistenceContainer_MongoDBImpl_Get_Error: Record identifier is invalid <ID_REMOVED> collection <AS_Schedules>"
"PersistenceHandler_ReadBody_UnknownError: Resetting persistence containers and rethrowing."

While the server thinks these two jobs are initializing, there's no running AlteryxEngineCmd task.

I can see the two jobs in MongoDB in AS_Queue.

I tried to stop the job using Gallery Admin > Jobs > Status, but the jobs remain.  I also tried using Options > View Schedules in Alteryx Designer on the server, but the "Delete Queue Entry" button is disabled for the two jobs in the Initializing status.

Running version:

"AlteryxService version 2021.1.2.20534 (c) Alteryx, Inc. - All Rights Reserved."

Any suggestions on how to get the server up and running again during this holiday weekend?  I opened a case with Alteryx Support on Friday morning, but haven't heard anything back.

kgalbert

Hi Hody,

We upgraded to 2021.1 on Friday and have the exact same problem.  Two jobs are stuck in the queue as initializing and server reboots and service restarts (though we're forced to kill the process to get it to restart) have failed to fix the problem.

Let us know if you figure this out.

Thanks,
Ken