Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have being trying to setup automation for 2 application to be refreshed every 5 mins (Extract and UI), using Loop and every automation will run for 4 hours as maximum execution time for an automation is 14400 seconds, so we are ending our automation run when Runtime goes beyond 14300 second, keeping 100 seconds, buffer for next run to be scheduled,
But sometimes the automation stop premautrely, Like around 2 hr and 30 mins in or 47 min run, it got finished,
without throwing any error, and the condtion was still false for (Runtime >= 14300), so It woulnt have ended.
In the DO Reload block I have tried both wait for reload to complete and Start reload and continue, as we need 48 reloads per 4 hours, Start reload and continue seems the best option. but when the reload gets queued, the Loops keep giving output Reload Ongoing, till its finished, but soemtimes, its just ends the automation on the Loop without throwing any error, or sometimes, it just end on Sleep block.
I'm attaching screenshots and Automation Template for your reference,
I would really appreciate if someone can help me on this issue.
I won't speak to the early finish, but in general long running automations to drive reloads isn't an efficient use of your concurrent automation cap.
If you can reload it every 6 minutes, then you can do this with the new task chaining capability by creating 10 tasks (running every hour, each offset by 6 minutes), with the UI app being run on success of the loader app (1 task). Or you can use triggered automations, as documented https://qlik.dev/manage/reloads/task-chaining-automations/, which doesn't have a limit.
In both cases consider limiting refreshes to run only during business hours, unless you desperately need it all night 😉