topic Re: QVD files occasionally partially-loading! in QlikView

QVD files occasionally partially-loading!

alexis — Thu, 20 Nov 2014 16:58:46 GMT

Just like with many of my implementations, I have 2 applications at a client's site. I have one application that I call the "QVD Generator" responsible for connecting with the various data sources and producing a set of QVD files, and another the "UI" application which loads these QVDs.

These 2 applications are run overnight through the scheduler and we have ensured that the UI load happens well after the QVD generator completes it's task. Occasionally (about once a week) the users report that the QVDs were only partially loaded during the overnight process and that a manual reload always resolves this issue. The last time this happened, the UI application started loading half an hour after the QVD generator finished creating the QVDs so it's not a question of the UI application starting its load whilst the generator was half-way through its workings.

I am at a complete loss and the client is understandably not happy - can anyone suggest anything or where to look in the logs perhaps for a clue as to what is happening?

Thanks in advance

Alexis

Re: QVD files occasionally partially-loading!

alexpanjhc — Thu, 20 Nov 2014 17:11:18 GMT

Any other jobs were running at the time? if so make it dependent on one and then the other.

Logs are in different locations depending on what server you have.
mine is under C:\ProgramData\QlikTech\DistributionService\1\Log.

You can find out the logs of the day and see what happened

Re: QVD files occasionally partially-loading!

alexis — Thu, 20 Nov 2014 17:26:26 GMT

Thanx Alex - I'll have a look at the logs as you suggest.

Alexis

Re: QVD files occasionally partially-loading!

simondachstr — Thu, 20 Nov 2014 17:28:23 GMT

When you refer to partial loading, do you mean the native QlikView Partial Reload functionality which is happening occasionally as opposed to a normal reload?

Re: QVD files occasionally partially-loading!

alexis — Thu, 20 Nov 2014 17:35:31 GMT

Hi Martin,

I mean that data is missing, sometimes a little sometimes a lot - it's variable.

BR
Alexis

Re: QVD files occasionally partially-loading!

simondachstr — Thu, 20 Nov 2014 17:45:57 GMT

This seem to be a data connector/data base issue rather than QlikView's fault. Maybe while you're reloading the QVD file the underlying database is getting updated at the same time e.g.. Don't you think?

Re: QVD files occasionally partially-loading!

yassinemhadhbi — Thu, 08 Oct 2020 11:37:56 GMT

I'm facing the same problem

I have this QVW this reads the data from QVDs and gerates anthoer QVDS , sometimes the QVDs that this QVW generates a lot of data in it is missing but it exists in the initial QVDs