Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

How to make qvd load dependent on database load

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?

6 Replies
prieper
Honored Contributor II

How to make qvd load dependent on database load

What about checking the creation-time of the qvd with FILETIME(YourFile)-function?

Peter

Not applicable

How to make qvd load dependent on database load

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.

MVP
MVP

How to make qvd load dependent on database load

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".

Not applicable

How to make qvd load dependent on database load

Hi.. Here is the full requirement:

1. If it's a weekday

a. DB load is not complete: The QVD should wait until DB load is complete

b. DB needs to be reloaded on the same day: The qvd load should wait until DB load is complete

c. QVD needs to be reloaded and not DB: the qvd load should start upon manual trigger

2. If it's a weekend, skip the control script and start the qvd load

prieper
Honored Contributor II

How to make qvd load dependent on database load

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.

Peter

arsa6978
New Contributor III

Re: How to make qvd load dependent on database load

Hello,

this is very old post, but did anyone has an aproach for the Question?

I have the same issue now.

How did you solve it? Thanks!