topic Restart failed jobs in QlikView

Restart failed jobs

kris_vliegen — Thu, 05 Jan 2017 15:46:20 GMT

Hi All,

I have some reloadjobs that load data of a server from a customer.

The connection between the qlikview-server and the data-server is not always online.

I have to reload 6 qvd's and a dashboard once a day.

It starts at 6 AM and sometimes the connection is offline and the reload fails.

But sometimes the 1st one reload succesfull and the second one fails.

Is there any mechanism to reschedule till the dashboard is loaded that day?

I can schedule the reload every hour and put this in the beginning of reloadscripts to create the qvd's.

let vReload = date(filetime('..\04_Documents\Dashboard.qvw'));

let vToday = Date(Now());

if($(vReload) =$(vToday) ) THEN

exit script;

ENDIF;

But then the dashboard reload every hour and this is not the thing I wan't.

And If I put the same script in the reloadscript of the dashboard, an empty dashboards is what I get.

Who can help me with this?

Regards,

Kris

rwunderlich — Thu, 05 Jan 2017 22:27:47 GMT

Do you have Publisher? If so, set the "number of retries" in the task definition.

-Rob

kris_vliegen — Fri, 06 Jan 2017 13:27:26 GMT

Hi,

Can I set this to 100? Because sometimes the connection is lost for an hour?

Regards,

Kris

rwunderlich — Fri, 06 Jan 2017 18:35:15 GMT

The Help for the "Number of tries" field does not indicate any limit. You should be able to enter 100 or more tries.

-Rob

kris_vliegen — Mon, 09 Jan 2017 12:22:02 GMT

Ok, I will try this.

Is there a pause between de tries?

rwunderlich — Mon, 09 Jan 2017 17:52:08 GMT

I don't believe there is any pause. You could build a pause into the the beginning of your script with the SLEEP statement.

-Rob