topic How to make qvd load dependent on database load in QlikView https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164308#M37051 <HTML><HEAD></HEAD><BODY><P>When you talk about a "database load", are you talking about some batch job running in your business system, outside of QlikView? If so, the way we handle this in our shop is to have the business system send a message (EDX?) to QlikView to initiate the QVD reload once the database load is complete. I'm not entirely clear on the details, though. I know that in Publisher, the trigger is "Start the task On an external event".</P></BODY></HTML> Mon, 01 Mar 2010 23:21:32 GMT johnw 2010-03-01T23:21:32Z How to make qvd load dependent on database load https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164305#M37048 <HTML><HEAD></HEAD><BODY><P>Hi Guys... I have a qvd load which should be triggered only after database load completes. Currently I have set it up based on time but still there are some instances where database load is delayed and we have to run qvd load again to refresh the data. is there any way this dependency can be set in qview script?</P></BODY></HTML> Mon, 01 Mar 2010 20:36:19 GMT https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164305#M37048 2010-03-01T20:36:19Z How to make qvd load dependent on database load https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164306#M37049 <HTML><HEAD></HEAD><BODY><P>What about checking the creation-time of the qvd with FILETIME(YourFile)-function?</P><P>Peter</P><P></P></BODY></HTML> Mon, 01 Mar 2010 21:01:19 GMT https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164306#M37049 prieper 2010-03-01T21:01:19Z How to make qvd load dependent on database load https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164307#M37050 <HTML><HEAD></HEAD><BODY><P>This can definetely help. But is there anyway to look for checking the data. For eg: if DB load is not complete, check in the interval of 5 min.</P></BODY></HTML> Mon, 01 Mar 2010 22:25:17 GMT https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164307#M37050 2010-03-01T22:25:17Z How to make qvd load dependent on database load https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164308#M37051 <HTML><HEAD></HEAD><BODY><P>When you talk about a "database load", are you talking about some batch job running in your business system, outside of QlikView? If so, the way we handle this in our shop is to have the business system send a message (EDX?) to QlikView to initiate the QVD reload once the database load is complete. I'm not entirely clear on the details, though. I know that in Publisher, the trigger is "Start the task On an external event".</P></BODY></HTML> Mon, 01 Mar 2010 23:21:32 GMT https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164308#M37051 johnw 2010-03-01T23:21:32Z How to make qvd load dependent on database load https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164309#M37052 <HTML><HEAD></HEAD><BODY><P>Hi.. Here is the full requirement:</P><P>1. If it's a weekday</P><P></P><P class="MsoListParagraph">a. <STRONG>DB load is not complete:</STRONG> The QVD should wait until DB load is complete</P><P class="MsoListParagraph"><STRONG>b.</STRONG> <STRONG>DB needs to be reloaded on the same day:</STRONG> The qvd load should wait until DB load is complete</P><P class="MsoListParagraph"><STRONG>c.</STRONG> <STRONG>QVD needs to be reloaded and not DB:</STRONG> the qvd load should start upon manual trigger</P><P class="MsoListParagraph"><STRONG>2</STRONG>. <STRONG>If it's a weekend,</STRONG> skip the control script and start the qvd load<STRONG></STRONG></P><P></P></BODY></HTML> Mon, 01 Mar 2010 23:27:52 GMT https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164309#M37052 2010-03-01T23:27:52Z How to make qvd load dependent on database load https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164310#M37053 <HTML><HEAD></HEAD><BODY><P>Biggest problem would we to find out, when the database has finished reload - had overlooked this in my first reply. Wonder whether it is possible in the maindatabase to add one field "Last Refreshed" or the like, which might be questioned before loading the main-table into Qlik.</P><P>Peter</P></BODY></HTML> Tue, 02 Mar 2010 23:20:35 GMT https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164310#M37053 prieper 2010-03-02T23:20:35Z Re: How to make qvd load dependent on database load https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164311#M37054 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>this is very old post, but did anyone has an aproach for the Question?</P><P>I have the same issue now.</P><P>How did you solve it? Thanks!</P></BODY></HTML> Thu, 06 Jul 2017 13:59:47 GMT https://community.qlik.com/t5/QlikView/How-to-make-qvd-load-dependent-on-database-load/m-p/164311#M37054 arsa6978 2017-07-06T13:59:47Z