topic Re: Error on Store Into qvd in QlikView

Error on Store Into qvd

Mon, 07 Jul 2014 16:49:01 GMT

Hi, i have an error while i'm trying to store data from a resident table into a qvd file.

this is my code:

Store * From mantenimiento Into $(pathQVD)mantenimiento.qvd (qvd);

I debuged my code looking for a sintax error or a wrong path and everything is right.

When i execute the script, it stopped and says "Script Finished". Then it asked me if i want to reload data because an error has ocurred.

I would be grateful for your response.

Re: Error on Store Into qvd

Marcio_Campestrini — Mon, 07 Jul 2014 16:54:16 GMT

Hi Alexander

Try to remove to word 'from' from your command, like this:

Store mantenimiento Into $(pathQVD)mantenimiento.qvd (qvd);

I hope it'll work.

Re: Error on Store Into qvd

Mon, 07 Jul 2014 16:55:11 GMT

Try:

Store mantenimiento Into $(pathQVD)mantenimiento.qvd;

Re: Error on Store Into qvd

Mon, 07 Jul 2014 16:59:06 GMT

Thanks i tried it, but i obtain the same result "Execution of Script failed. Raleoad old data?".

Re: Error on Store Into qvd

jaimeaguilar — Mon, 07 Jul 2014 17:02:03 GMT

Hi,

the error could be because the folder that is inside your variable pathQVD doesn't exist. Make sure that folder is created before you execute the script,

regards

Re: Error on Store Into qvd

vardhancse — Mon, 07 Jul 2014 17:05:18 GMT

Hi try

Store mantenimiento Into $(pathQVD)\mantenimiento.qvd;

Slash was missing

Re: Error on Store Into qvd

Mon, 07 Jul 2014 17:08:49 GMT

Hi, i'm sure that exist...i copied the variable content while debugging and pasted it on my explorer and this is correct.

I don't understand why not stored it...i have three tables stored before execute this line and it not throw errors

Re: Error on Store Into qvd

Mon, 07 Jul 2014 17:09:51 GMT

Hi, my variable has "\" included into the value.

regards.

Re: Error on Store Into qvd

aveeeeeee7en — Mon, 07 Jul 2014 17:13:43 GMT

Hi alexander

Go to your pathQVD Location> Delete mantenimiento.qvd

Now, again Reload. It will work now and no error will occur.

Correct format is:

From Location;

Store TAblename into path\abc.qvd(qvd);

Hope that works.

Regards

Aviral Nag

Re: Error on Store Into qvd

eduardo_sommer — Mon, 07 Jul 2014 17:14:22 GMT

Hi Alexander,

Are you trying to store the qvd on a network drive?

Eduardo

Re: Error on Store Into qvd

vardhancse — Mon, 07 Jul 2014 17:16:11 GMT

once can you give your sample path

Re: Error on Store Into qvd

vardhancse — Mon, 07 Jul 2014 17:16:32 GMT

if qvd exists also it will overwrite

Re: Error on Store Into qvd

Mon, 07 Jul 2014 17:51:39 GMT

Well, when i tried to delete the qvd file, it doesn't allow me bacause "was opened by another application"...

then i restart my pc and i reload data and it works without problems...

Thank to all for your responses.