topic Re: Monitoring QVD Reloads in QlikView

Monitoring QVD Reloads

Tue, 05 Aug 2014 02:37:57 GMT

Hi all,

Let me start by saying we only have Qlikview Server and not Publisher.Maybe I have missed something simple that Google has failed me on.

I have a number of qvd script documents that are scheduled to incrementally update some large QVD files (400 million rows plus). These QVDs are shared between multiple report documents. How can I ensure that when the report documents load in the QVDs that the QVDs are not in the process of being incrementally updated by the script documents?

I have a number of QVD script documents that export multiple QVDs so one report document has multiple dependencies.

Many thanks.

Re: Monitoring QVD Reloads

avinashelite — Tue, 05 Aug 2014 05:03:03 GMT

Hi Chris,

Try to check for the last reload time of the QVD,s this will help you to find whether the process of being incrementally updated by the script documents or not.

Re: Monitoring QVD Reloads

ashfaq_haseeb — Tue, 05 Aug 2014 05:13:36 GMT

Hi,

In this case, I would suggest you to split script on priority basis and add dependent tasks.

Regards

ASHFAQ

Re: Monitoring QVD Reloads

Tue, 05 Aug 2014 18:43:46 GMT

Hi Chris, We can customize your Loader script and create the qvd file with reload info every time.

Re: Monitoring QVD Reloads

Tue, 12 Aug 2014 08:13:37 GMT

Hi all,

In the end we created a few sub functions that create read and write locks on a QVD. All QVWs that use those QVDs look for these lock files and during the reload will wait until any locks has been removed. If it is required to wait long than "x" minutes it will be forced to error.

Hopeful this will solve any issues.

-Chris

Re: Monitoring QVD Reloads

ashfaq_haseeb — Tue, 12 Aug 2014 08:17:53 GMT

You can post solution here for others to review later if required.

Regards

ASHFAQ