topic Re: Scheduling using Reload Engine in QlikView

Scheduling using Reload Engine

punitpopli — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have to setup data reload process using Reload engine in QMC (as we don't have publisher).

Would like to know the limitations of Reload engine in terms of below areas :

Parallel tasks : I know this can be no. of cores-1, does these includes virtual cores as well?
Dependent tasks : How many task can be added as dependent tasks? Does it support more than one?
External tasks : Any limitations on external tasks

Please share your inputs on above sections and share the documents as well which gonna help me.

Thanks in advance

-Punit

Re: Scheduling using Reload Engine

adamdavi3s — Tue, 25 Oct 2016 11:12:00 GMT

Parallel tasks : I know this can be no. of cores-1, does these includes virtual cores as well? YES I believe so

Dependent tasks : How many task can be added as dependent tasks? Does it support more than one? NO but you can write logic into one qvw and use that simply to trigger a reload

External tasks : Any limitations on external tasks NOT that I am aware of

Re: Scheduling using Reload Engine

punitpopli — Wed, 26 Oct 2016 02:26:26 GMT

Hi Adam,

Thanks for your reply.

Can you please elaborate more on #2 i.e. " NO but you can write logic into one qvw and use that simply to trigger a reload" in above?

Just to elaborate on my requirement :

A Parent file should be triggered once 3 child reload gets completed (just FYI : Don't have publisher)

-Punit

Re: Scheduling using Reload Engine

Anil_Babu_Samineni — Wed, 26 Oct 2016 03:05:46 GMT

Adam, for second one how it will because he don't have publisher. Without QVP I don't think dependency will work or not.

Re: Scheduling using Reload Engine

adamdavi3s — Wed, 26 Oct 2016 06:28:19 GMT

Ok For two you can do a couple of things.

The first is what we do and is simply link the next step to the slowest running Qvw, but we are lucky that one of our 5 always takes a couple of seconds more.

Otherwise to expand on my comment, I mean the world is your oyster really, as with all things Qlik.

Where my mind was going is to get each of your three dashboards to spit out a 'last reloaded' qvd and then pull that into another Qvw with some logic to check.

E.g. check if all three files have reloaded in the last 5 mins- successful reload and you can chain the next one from this

If they haven't then cause the logic to fail the reload and the subsequent reload won't fire

Re: Scheduling using Reload Engine

punitpopli — Wed, 26 Oct 2016 06:54:58 GMT

To validate all the three files was reloaded in last 5 minutes : This logic needs to be implemented in qlikview script or on scheduling side.

Could you please help me on how to implement such scenario?

Thanks in advance.

-Punit

Re: Scheduling using Reload Engine

punitpopli — Fri, 28 Oct 2016 04:36:20 GMT

Hi,

I was trying to reload a QVW file from another QVW file using a EXECUTE statement command on server i.e. scheduling the main QVW file through scheduler and executing other QVW's from the main QVW in script, but this is not working on server as the task is getting failed on server.

I had also verified the setting "AllowExecuteCommand" in Setting file and is set to 1. which means i can use EXECUTE statement and it will run on server.

Can you help me on this?

Thanks

Re: Scheduling using Reload Engine

punitpopli — Fri, 28 Oct 2016 07:51:23 GMT

stalwar1‌, pcammaert‌, gwassenaar‌, jaganmohanrao‌

Could you please share your thoughts on above?

Re: Scheduling using Reload Engine

adamdavi3s — Fri, 28 Oct 2016 07:58:59 GMT

Have you tried the idea of getting each dashboard to fire a QVD with its reload time?

Then pull these three QVD files into another QVW and use an IF statement to check if all three were in the last five minutes.

If they are then the reload will finish and you can chain your main file from this one.

If it is false then fail the reload and the chained qvw will not load.