Long running WF timing out on Gallery

[BonusCup]

Hi,

I have a WF that pulls down roughly 115,00 records using an API call.  Unfortunately, with the limitations, I have to set the throttle records on the Download tool to 150 per minute.  Before this job was scheduled, we had set our server config to cancel jobs running longer than 23400 seconds (6.5 hours).  In Designer, this WF runs right at around 7 hours.  

I've tried unchecking the cancel jobs setting, setting it to 36000 seconds (10 hours), setting it to 0 and then unchecking the setting but the job always seems to fail at 6.5 hours.  Is there a default timeout somewhere else?

Server version: 2024.1

[abacon]

@BonusCup Did you change the server settings that cancel jobs longer than 6.5 hours? I believe you should be able to work with your IT team (or whoever setup the server configs) to update the server configs to allow for a longer workflow time.

Bacon

[BonusCup]

@abacon,

I have admin access and did change both our controller and worker by unchecking the cancel jobs option.

Controller:


Worker:

[abacon]

@BonusCup Interesting, that would be what I was thinking. I don't know of a default timeout, what is the error message on the failure? Is there any chance the error is coming from the API endpoint you are calling and not the server? Just trying to think of all possible reasons.

Bacon

[BonusCup]

@abacon,

It's always this same error:
There was an unknown error executing the application. The engine reported status Error (ToolId: -1)

I don't think it is an issue with the API because I am able to run it every day from Designer. Also, even with the Events set up where we would get an email notification when a WF fails, we do not receive one for this error.

[abacon]

@BonusCup I love when the error messages are helpful and not generic lol.

This might be a question for alteryx reps, I don't think there is a default timeout on the server but I could be wrong. But I don't think I can provide any more information that you don't already know or haven't already tried, sorry I couldn't help more.

Bacon

[BonusCup]

@abacon thanks for the second set of eyes.