topic Re: Stop Automation Block (Qlik Cloud Services) in Qlik Automate

Stop Automation Block (Qlik Cloud Services)

rx98u5pq — Tue, 15 Apr 2025 15:11:00 GMT

Hi all,

For the stop automation block how do you get the block to parse the value of the current RunID? The automation ID is static as I would just use this automations' ID

Essentially I want the current automation to end when a condition is met but I'm having trouble getting this value.

Thanks

Re: Stop Automation Block (Qlik Cloud Services)

marksouzacosta — Tue, 15 Apr 2025 18:46:23 GMT

Hi @rx98u5pq,

If you need to stop the current Run you should use the Stop block under Basic blocks.

If you need the current RunID for some reason, you can use automationid and runid formulas. Following the formulas*:

{ automationid }
{ runid }

Regards,

Mark Costa

Re: Stop Automation Block (Qlik Cloud Services)

rx98u5pq — Wed, 16 Apr 2025 06:52:34 GMT

thank you Mark. I had looked at that too but wanted to add some information as to why the reload stopped (e.g. app id reloads 1,2,3 have failed) and thought the stop automation may have been a little bit better.

Re: Stop Automation Block (Qlik Cloud Services)

rx98u5pq — Tue, 22 Apr 2025 07:12:05 GMT

My current problem is that i want to stop the automation if a reload status = failed...and then list all the reload IDs that have failed. I found a previous post (i think it was yours!) and set it up so that my automation runs a bunch of reloads at the same time, waits for the reload to complete. then runs a loop on the reload ID and tries to record the issue in an output block.. as shown below:

I keep getting the rror:

code:

RELOADS-001

title:

Invalid request.

detail:

Parameter 'reloadId' must be a valid objectId format
I also feel that this is an incorrect solution as the output box would not build up a list of all the reload IDs but be overwritten with each run?

Re: Stop Automation Block (Qlik Cloud Services)

rx98u5pq — Tue, 22 Apr 2025 07:55:16 GMT

Commenting on my own post here......... but I think the solution is to add a variable which appends a list for all the reload ids and app ids from get reload record 2 inside the loop. then move the output box outside the loop.

Re: Stop Automation Block (Qlik Cloud Services)

rx98u5pq — Wed, 23 Apr 2025 13:58:48 GMT

Update: my changes have worked. I have an variable which currently as follows:

which gives an output as like this:

This is in a loop and it adds a row for each failed app.

how can i get this list into a html message as when i try to, it does not let me format it correctly as when there are 2 apps it just says "array"

Any pointers would be appreciated.

Re: Stop Automation Block (Qlik Cloud Services)

marksouzacosta — Wed, 23 Apr 2025 16:04:17 GMT

Hi @rx98u5pq,

Conceptually, you have to create another variable that will be your HTML Email Body Message.
You initiate the variable with some content and add a Loop Block to loop through the Failed Reloads to fill the middle section of your HTML Email Body Message variable.

The Key is to use the Append operation:

At the end, you can use the variable in your Send Email block:

Keep in mind that you have to play around smart with your variables and HTML content to facilitate the whole HTML manipulation.

Regards,

Mark Costa

Re: Stop Automation Block (Qlik Cloud Services)

rx98u5pq — Thu, 08 May 2025 14:15:40 GMT

Hi Mark,

I have finally got an automation that does what I want (thanks to your great help)...however, there is one issue and I am not sure what it is.

- the app runs about 50 scripts concurrently

- some can be extracting large volumes of data

- there is a variable which compilates all the reload IDs

- the way for reload block checks these ids and makes sure they are finished

- it should send an error if there is a failure

I thought this was working but now i noticed that the automation was marked as complete as the wait for reloads block did not actually wait until all scripts had run. Have you came across this before? I have attached some snippets of the automation.

So the automation may mark as complete but in reality it has not checked and waited for all reloads to complete.

Re: Stop Automation Block (Qlik Cloud Services)

Shai_E — Mon, 12 May 2025 10:15:16 GMT

Hi @rx98u5pq

A run log and a workspace files will help in understanding what is going on.

Re: Stop Automation Block (Qlik Cloud Services)

rx98u5pq — Mon, 12 May 2025 10:48:57 GMT

Thanks @Shai_E - what are you referring to when you mention a workspace file?

Re: Stop Automation Block (Qlik Cloud Services)

Shai_E — Mon, 12 May 2025 14:16:13 GMT

@rx98u5pq

The automation itself, so that someone can upload it to his own environment and see the flow.
Then compare it with the run log where you see this behavior to get a picture of what happened during the run.

To get a workspace you right click on the automation editor screen -> download/export workspace

Re: Stop Automation Block (Qlik Cloud Services)

marksouzacosta — Mon, 12 May 2025 14:42:46 GMT

This is hard to say.

My guess: since you are reloading too many apps, you are exploding the limits of the variable size, so this is causing some inconsistencies during the Automation Process.

You could try to list in an output block all the Reload IDs just to make sure if you are getting every single one.

Regards,

Mark Costa