Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
punitpopli
Contributor III

Scheduling using Reload Engine

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  :

  1. Parallel tasks : I know this can be no. of cores-1, does these includes virtual cores as well?
  2. Dependent tasks : How many task can be added as dependent tasks? Does it support more than one?
  3. 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

8 Replies
Highlighted
adamdavi3s
Honored Contributor

Re: Scheduling using Reload Engine

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

Highlighted
punitpopli
Contributor III

Re: Scheduling using Reload Engine

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

Highlighted

Re: Scheduling using Reload Engine

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
adamdavi3s
Honored Contributor

Re: Scheduling using Reload Engine

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

Highlighted
punitpopli
Contributor III

Re: Scheduling using Reload Engine

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

Highlighted
punitpopli
Contributor III

Re: Scheduling using Reload Engine

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

Highlighted
punitpopli
Contributor III

Re: Scheduling using Reload Engine

stalwar1‌, pcammaert‌, gwassenaar‌, jaganmohanrao

Could you please share your thoughts on above?

Highlighted
adamdavi3s
Honored Contributor

Re: Scheduling using Reload Engine

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.