topic QVD not being read (help) in QlikView

QVD not being read (help)

Thu, 04 Nov 2010 04:40:50 GMT

Hi,

This is unusual because i store a lot of excels in QVD format so then i could only read QVD for faster reloads. everything is great but i have one QVD file that is not being read when i reload. it gives out an error that file cannot be open. how can this be?

I have like hundreds of QVDs being read and only one QVD gives me this kind of error.

Please help..

Thanks!

QVD not being read (help)

Thu, 04 Nov 2010 08:51:15 GMT

Perhaps other user / program / scheduled job accessing same QVD at the same time, possibly across shared folders?

-Alex

QVD not being read (help)

prieper — Sun, 07 Nov 2010 20:10:09 GMT

Following the idea of Alexander: Try to rename the qvd in Explorer - if you get an error-message, there is another process accessing this file - might also be a crashed QV-instance, which has created the file or the like ...

If yes, just restart - this should clear all blockages.
If not, would guess that the qvd is corrupt and should be created again.

HTH
Peter

QVD not being read (help)

Wed, 23 Mar 2011 11:16:59 GMT

Hi,

I've had a similar problem recently, but found as I was using a variable to define the QVD name this was the source of the problem, in my input box deleted the variable and created a new one then the reload worked fine.

Thanks

Gavin

QVD not being read (help)

prieper — Wed, 23 Mar 2011 20:23:45 GMT

hmmm
I am confronted with this behaviour now as well: I load and save a lot of files with (composite) variables and have quite often errormessages like "could not save" or "file not found". I am using vers. 10 SR1, under vers. 9 did not experience this. Which version are you using?

++
Peter

QVD not being read (help)

Tue, 05 Apr 2011 09:23:58 GMT

I've just started to experience the same problem....

My script is joining data to an additional QVD, this QVD is reference by several scheduled jobs and is accessible by them. But when I try to run against it manually whilst I'm tweaking, I get the same "Cannot open QVD" error message.

At a guess, I'd say that the QVD isn't corrupted as it works with other jobs. I have made a copy of this so that I am the only one accessing it at a time, I have changed the varialbe path that is picking it up (although the last path was used for all data files and worked fine) but still receive this error.

Has anyone managed to find a way around this yet?

Many thanks,

Ronnie

QVD not being read (help)

prieper — Tue, 05 Apr 2011 17:09:27 GMT

My problem is solved,
after completely switching off the backup-process (and then restarting after a while), these problem do not incur any longer. So we guess that there was something running out of control with the backup-program.

Can it be that your error-message is probably misleading and that the data in your application and in the qvd have different fields? Thus it is trying to save some quadrillions of records (out of a cartesian product)? In this case can you try to combine the data with CONCATENATE LOAD ...?

++
Peter