topic Re: QMC Reload Process in QlikView

QMC Reload Process

fkeuroglian — Thu, 19 Jun 2014 17:17:25 GMT

Hi people i would like to know if there is a posibility to create a Defensive programing in the reload procedure.

for example, i have 3 etl, and they are in secuence: ETL1 then ETL2 then ETL3

now i have checked the option "on event from another task succesfull" and then execute the etl

but if etl1 fail, stop all the process and etl2 and etl3 do not complety and reload ok.

is there a way to create some flag or something to have the posibility to:

RUN ETL1;

IF ETL1 OK THEN

RUN ETL2

ELSE

RUN ETL2

IF ETL2 OK THEN

RUN ETL3

ELSE

RUN ETL3

Thank you a lot people all the help will be appreciated !

Fernando

Re: QMC Reload Process

Chris_Rice — Thu, 19 Jun 2014 23:28:26 GMT

You should be able to just create two tasks for ETL2 and 3. So:

IF ETL1 OK THEN

RUN ETL2 Task 1

ELSE

RUN ETL2 Task 2

IF ETL2 OK THEN

RUN ETL3 Task 1

ELSE

RUN ETL3 Task 2

Both Task 1 and Task 2 are the same thing, just triggered differently.

Re: QMC Reload Process

rwunderlich — Fri, 20 Jun 2014 03:13:04 GMT

If I understand, you want to run ETL2 when ETL1 completes, either successful or failure? Do you have Publisher? If so, you can define both triggers.

-Rob

Re: QMC Reload Process

fkeuroglian — Fri, 20 Jun 2014 12:59:43 GMT

Hi, Rob

I do not have publisher, there is another posibility without publisher?

thank you rob

Re: QMC Reload Process

Chris_Rice — Fri, 20 Jun 2014 18:52:45 GMT

I don't think that's possible with QlikView sans Publisher, but you should be able to set up external tasks and triggers.

http://community.qlik.com/docs/DOC-3024

Re: QMC Reload Process

Fri, 20 Jun 2014 19:09:35 GMT

Just create 2 triggers; one for success and another for failure

Re: QMC Reload Process

fkeuroglian — Fri, 20 Jun 2014 19:37:42 GMT

Kiru, explain more

what would you use and put an example , where and how do you create the two triggers?