time delay between automation

[Ch_Nwk]

Hi,

I have written an automation in which a second automation is to be started after a successful reload of an app. (see picture)

My problem is that it takes up to 20 minutes between a successful reload and the start of the second automation.

What is the reason for this and/or how can I prevent the delay?

Best regards

Christian

[Shai_E]

Hi @Ch_Nwk 

Not really sure i get your issue from the description.

So a reload, starts, it ends, if its successful you run a second automation.

Does the second automation take 20 minutes to fire?

How much time does the reload take? 

[Ch_Nwk]

Ich will versuchen, es genauer zu beschreiben.

Was Du im Bild siehst, ist ein Teil einer Automation. Ich habe 70 dieser Automation, aufgrund von Einschränkungen bei der Hardware kann ich aber nur maximal 16 Prozesse parallel starten.

Ich starte also die erste Automation darin ist ein erster Reload einer App. Ist dieser erfolgreich durchgeführt, startet die nächste Automation, die inhaltlich genau so aussieht wie auf dem Bild mit dem nächsten Reload.

Ich sehe anhand des Script, wann das erste Reload fertig ist und wann das zweite Reload startet und dazwischen liegen bis zu 20 Minuten.

Die Länge der 70 Reloads ist unterschiedlich. Einige dauern ca. 1 1/2 Stunden, andere weniger als eine Minute.

[vkramBI4Qlik]

Hi,

I think in the "Do Reload" of the first block, you may have Select the "Run Mode" as "Wait for the reload to complete" instead of "Start reload and Continue" ? 

Thanks

Vikram

[Ch_Nwk]

That is correct.

The reason for this is that I have 70 processes, but only 16 of them are allowed to run at any one time.

After the first do reload, there is also a second do reload, which may only be executed if the first one was successful. The second do reloads for each of the 70 processes are not subject to the restriction of max. 16 processes in parallel.

The sequence is as follows:

I start 16 processes simultaneously, each do reload with ‘Wait for the reload to complete’.

Once a do reload is complete, the first do reload is to be triggered via the next automation in another process

run automation with 'Start automation and Continue' and then the second reload for the first process.

I know from the output of the first script when the first script is finished. However, it takes 20 to 30 minutes until the script from the next process is started.

[vkramBI4Qlik · Accepted solution]

I think you must have started this parallel reload due to the 3 to 4 hours max limit for automation run ?

If so for this I think, you can solve this in 2 ways.

1. This is lengthy manual process ( Multi Tasks Chaining ) through apps
Do More with Qlik - Tasks and Event Based Schedules 

2. You need get the reload times of all the apps and split them to "#n" number of automations and Do a sequence reloads.

Like Automation1 : 5 Apps in Sequence automations

Automation2 : 8 Apps in Sequence automations

Automation3 : 3 Apps in Sequence automations

Automation4 : 9 Apps in Sequence automations

Automation5 : 3 Apps in Sequence automations

..

Automation#n  till you reach #70

I guess, This is what you implemented. But based on my experience Loops may not be better option. Instead of calling other automations from a single automation, Break them like I mentioned

Like 

Automation1 ( 5 apps in sequence),

Automation2 ( Here you need to check the "Run Ended" block of Automation#1 , then reload 8 Apps in sequence)

Automation3 ( Here you need to check the "Run Ended" block of Automation#2 , then reload 3 Apps in sequence)

...

Automation#n ( Here you need to check the "Run Ended" block of Automation#n-1 , then reload the rest of Apps in sequence)

You can get more details from the below post from comments by @marksouzacosta

Trigger-second-automation-when-the-first-automation-is-succesful 

Good Luck !

Thanks.

Vikram