topic Re: qvd Refresh indicator in QlikView

qvd Refresh indicator

ilanbaruch — Sun, 27 Dec 2015 14:05:31 GMT

hi all,

I have 7 qvd's that refresh daily by a batch script then when finished, a batch script that runs all the qvw's

the problem is when one of the qvd's fail to reload (due connection problems or other) and the data stays as before,

then the qvw script runs and load unrefreshed data from qvd's ...

looking for an indicator in qvd/qvw script or through server setting that will alert when qvd load failed.

any ideas ??

Re: qvd Refresh indicator

sunny_talwar — Sun, 27 Dec 2015 14:45:49 GMT

Just an idea, What if you add a reload time in your qvd's script that shows up in your final qvw. You can then create a flag where if reload date is today's date than 1 (or most recent) else 0 (or data did not refresh).

Re: qvd Refresh indicator

ilanbaruch — Mon, 28 Dec 2015 15:39:00 GMT

Thank you!

Re: qvd Refresh indicator

Peter_Cammaert — Mon, 28 Dec 2015 15:44:19 GMT

Funny. You're talking about a "server" which is quite capable of notifying you about failed reloads (and subsequently blocks the reload of any dependent QVWs, leaving you with consistent documents from the previous succesful reload), but you're still doing all your reloads using batch files (that don't have such a capability). Any particular reason for this?

Re: qvd Refresh indicator

ilanbaruch — Mon, 02 May 2016 09:27:35 GMT

Hi Peter thank you for your answer,

could you share some points or resources for your example to enhance QVS in daily operations ?

thank you