topic Re: Get "Execution of Script Failed" error when saving QVD in QlikView

Get "Execution of Script Failed" error when saving QVD

Mon, 28 Jan 2013 14:44:36 GMT

Hi,

Since I have included a piece of code to save my tables in QVD. Every time I reload my Qlikview document I get an error.

Can anyone please assist me with this.

Regards,

Karabo

Re: Get "Execution of Script Failed" error when saving QVD

alexandros17 — Mon, 28 Jan 2013 14:46:48 GMT

what about the qvd, is correctly written on the disk or not? Have you the permission to write in the directory?

Re: Get "Execution of Script Failed" error when saving QVD

Mon, 28 Jan 2013 14:49:29 GMT

The QVD is correct anf working fine. I do have permision to write in the directory I saved it in.

Re: Get "Execution of Script Failed" error when saving QVD

alexandros17 — Mon, 28 Jan 2013 14:53:02 GMT

Could you please send me a copy of the document to test it?

Re: Get "Execution of Script Failed" error when saving QVD

Mon, 28 Jan 2013 15:04:06 GMT

It is company property, so I can't send you the copy. I'll show you part of the scipt though.

Load ParentPortfolio,

AncestorName,

Order

From

[Data Source\PORTFOLIO_LIST.csv]

(txt; codepage is 1252, embedded labels, delimiter is ',', msg);

store [PORTFOLIO_LIST] into

[..\Data Sources\PORTFOLIO_LIST.qvd];

Re: Get "Execution of Script Failed" error when saving QVD

alexandros17 — Mon, 28 Jan 2013 15:14:34 GMT

You have to use Alias for the table you want to store:

AAA:

LOAD A, B
FROM .......
(ooxml, embedded labels, table is Foglio1);

store [AAA] into
;

Re: Get "Execution of Script Failed" error when saving QVD

rwunderlich — Mon, 28 Jan 2013 23:09:27 GMT

It's likely that the directory ..\Data Sources\ does not exist. QV will not create a missing directory but merely throws a "General script error".

-Rob

Re: Get "Execution of Script Failed" error when saving QVD

Tue, 29 Jan 2013 06:11:48 GMT

@Rob, the directory does exist and I do have access to it.

@alex, I'll try using alias table names as you suggested and get back to you.

Re: Get "Execution of Script Failed" error when saving QVD

Tue, 29 Jan 2013 11:35:51 GMT

It did not work, I still get the error. My code now looks like this:

Portfolios:

Load ParentPortfolio,

AncestorName,

Order

From

[Data Source\PORTFOLIO_LIST.csv]

(txt; codepage is 1252, embedded labels, delimiter is ',', msg);

store [Portfolios] into

[..\Data Sources\Portfolios.qvd];

Re: Get "Execution of Script Failed" error when saving QVD

perumal_41 — Tue, 29 Jan 2013 11:38:55 GMT

Hi,

take backup old QVD file , then Delete old QVD file from your folder and then Reload your application .

Regards

Perumal A

Re: Get "Execution of Script Failed" error when saving QVD

Tue, 29 Jan 2013 11:46:47 GMT

Thanks Perumal, but how do I delete the old QVD File from the script.

Re: Get "Execution of Script Failed" error when saving QVD

perumal_41 — Tue, 29 Jan 2013 11:53:33 GMT

Delete manually QVD File in your store folder .after reload your application

Regards

Perumal A

Re: Get "Execution of Script Failed" error when saving QVD

Tue, 29 Jan 2013 11:57:14 GMT

My problem with deleting manually is that, I have automated process that throughout the day automatically opens and reloads the qlikview model and extracts cetain graphs and tables for reports.

Re: Get "Execution of Script Failed" error when saving QVD

perumal_41 — Tue, 29 Jan 2013 12:04:31 GMT

Hi Karabo,

Delete manually QVD File in your store folder ,This only one time process ,this process don't repeat each time reload .after reload your application

Re: Get "Execution of Script Failed" error when saving QVD

Fri, 08 Feb 2013 10:22:04 GMT

I managed to automaticaly delete the QVD files before opening and reloading qlickview model. But I still get the error.

Re: Get "Execution of Script Failed" error when saving QVD

Fri, 08 Feb 2013 11:23:36 GMT

Can you change the name of the stored table name like(PORTFOLIO_LIST1) for testing give antoer name in please of PORTFOLIO_LIST.

Re: Get "Execution of Script Failed" error when saving QVD

Fri, 08 Feb 2013 11:44:32 GMT

Hi,

1. Please check for the storage size where QVD will get stored if the storage size is having less space this problem will occur, So mannually take backup of all the Old QVD's from storage place and keep it in some different location reload the application again tio generate QVD and check.

2. Due to some memory issue like temporary memory or cache memory of your Mavchine is high so you have to clear all the temporary memory and cache memory.

May it help you, please revert back if it doesnt work.

Thanks,

Pranav

Re: Get "Execution of Script Failed" error when saving QVD

Fri, 08 Feb 2013 11:49:07 GMT

After some testing, it seems the error is originally generated when the application is reloaded through the automated process.

For some reason the script can't excecute the QVD saving automatically.

Any help here will be greatly appreciated.

Karabo

Re: Get "Execution of Script Failed" error when saving QVD

Fri, 08 Feb 2013 12:26:44 GMT

Hi karabo,

I also had this error some days ago while we reload the app it will not let you to store the QVD this happens due to your old QVD is in used by your application through automated process. try to check if your QVD is not used by any app currently or check if itu r able to delete or rename the QVD file.

Regards,

Pranav