Stop Automation Block (Qlik Cloud Services)

[rx98u5pq]

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

[marksouzacosta]

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

[rx98u5pq]

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.

[rx98u5pq]

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?

[rx98u5pq]

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.  

[rx98u5pq]

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.

[marksouzacosta]

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

[rx98u5pq]

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.

[Shai_E]

Hi @rx98u5pq 

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

[rx98u5pq]

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