topic Re: Store qvd file issue in QlikView

Store qvd file issue

Fri, 24 Jul 2015 09:14:51 GMT

hi,

I have some issue in saving part of my data in qvd files. Basically I am trying to use something like this:

dan:
load * inline
[
numero, DA,rate
1,Goldorak,good
2,Candy,bad
3,DBZ,good
4,DBGT,bad
4,Booba,good
5,Nicky Larsson,good
6,Bugs Bunny,good
7,Captain Flam,good
8,Albator, good,
9,Avatar ANG,good
10,Avatar Kora,bad
] ;
dan2:
NoConcatenate
load *
resident dan
where rate='bad';

store dan2 into ;

DROP Table dan2;

this example runs perfectly, but the exact same based on real data doesn't work for reasons I don't get: everything is processed and I am ending with the message: "excecution of script failed. Reload old data?" I unsuccessfully tried the solution in General Script Error storing a QVD; so can you please help me with some explicit exemple. Thanks. Pierre

Re: Store qvd file issue

swuehl — Fri, 24 Jul 2015 09:17:42 GMT

Try

store dan2 into (qvd);

Re: Store qvd file issue

awhitfield — Fri, 24 Jul 2015 09:22:03 GMT

Hi Pierre,

you have missed the (qvd) off after .qvd]

HTH Andy

Re: Store qvd file issue

Fri, 24 Jul 2015 09:29:35 GMT

Swuehl, Andrew,

the code above runs perfectly even without the (qvd); I unfortunately can't publish what doesn't work because these are professional data. But how do we deal with such issue (not being able to store a qvd file) when it ever happened to you ?

Re: Store qvd file issue

avinashelite — Fri, 24 Jul 2015 09:37:28 GMT

can you please share the real time data script ?? that would help us in tracing the issue

Re: Store qvd file issue

swuehl — Fri, 24 Jul 2015 09:42:44 GMT

What's the difference between your two settings except the data source? Are you trying to store to a different location? If the location is not accessible (e.g. read-only) by the user that runs the script, you will get the same error.

Re: Store qvd file issue

antoniotiman — Fri, 24 Jul 2015 09:43:18 GMT

Hi Pierre,

are You sure exists Directory C:\Examples ?

(qvd) is default.

Regards,

Antonio

Re: Store qvd file issue

Kushal_Chawda — Fri, 24 Jul 2015 09:46:41 GMT

Is the directory really exists "C:\Examples\"? check if it is available or not

Re: Store qvd file issue

Fri, 24 Jul 2015 09:47:38 GMT

sounds like it could be file locking, does the QVD already exist and you are trying to replace it? Rename/Delete the QVD or check Windows computer management for open files.

hope that helps

Joe

Re: Store qvd file issue

Tue, 04 Aug 2015 08:07:31 GMT

Dear all,

Sorry for having disturbed with my issue: I reviewed more than 10 times but It was a damned typo error. there were no locked file inexisting directory or anything like that.

Now, if I mistype a column name of a qliktable, I'll get an error like "field not found", so I know exactly where I have to go to make the correction. Is it possible to get a specific message where he code is referring to a directory that doesn't exist ?

Regards,

Pierre