topic Re: General script error in QlikView

General script error

Fri, 26 Dec 2014 20:57:15 GMT

Hello everyone,

I am facing a curious problem. I hope someone will be able to help me.

I have server D which is my developement server. When I want to put an application in production, I paste it in server S which is my "storage" server. Then, the Qlikview server runs the application that are stored in server S.

I have an application which is store on server S. When I run it from server D, it works. But when I run it from Qlikview management console, it fails.

I have already have that case and each time, it was because I let some absolute paths instead of relative...

But this time it is not the case.

this is the piece of code where the app fails :

STORE blabla into ..\QVD\QVD_PE\azer\blabla.qvd;

Drop table blabla;

This is what I've got in the journal after the application failed with QMC:

26/12/2014 21:34:26: 3375 STORE blabla into ..\QVD\QVD_PE\azer\blabla.qvd

26/12/2014 21:34:26: General Script Error

26/12/2014 21:34:26: Execution Failed

26/12/2014 21:34:27: Execution finished.

So the application fails just before the drop table statement. But the QVD is stored (I've checked it).

Now I've tried to run it with one line in comment :

//STORE blabla into ..\QVD\QVD_PE\azer\blabla.qvd;

Drop table blabla;

STORE blabla into ..\QVD\QVD_PE\azer\blabla.qvd;

//Drop table blabla;

And in both cases, the reload works. It's only when there are these 2 statements that there is a failure. I really don't get why...

Do you have any ideas ?

Please, do not hesitate to tell me if my problem is not clear..

Thank you for your help

Re: General script error

its_anandrjs — Fri, 26 Dec 2014 21:09:29 GMT

Hi,

Better way is if you store the Path into the variables and then use variable instead of relatives

Ex:-

Let vPath = Your QVD source location path here

And then in Store

STORE blabla into $(vPath)blabla.qvd;

Regards

Anand

Re: General script error

Anonymous — Fri, 26 Dec 2014 21:15:48 GMT

Hi,

Do you have any complex calculations or any incremental load in script?

Regards

Neetha

Re: General script error

Fri, 26 Dec 2014 21:26:20 GMT

jaja I like the blabla, sometimes I use Mickey or Pluto :-).

I feel that there is a problem with multi-threading internally in QlikView engine, but is it just a feeling. So, the next statement is trying to remove a table (blabla) while it is still being used by another working thread inside QlikView's kernel. just 2 cents. of opinion 🙂

TRY as a test: load * inline something after the store qvd statement and then drop blabla, so you will insert the load * inline code between both statements.

Re: General script error

Anonymous — Fri, 26 Dec 2014 21:32:21 GMT

Have you tried limit load and was it successful?

Re: General script error

nagaiank — Fri, 26 Dec 2014 23:47:45 GMT

Did you try the following script?

STORE blabla into [..\QVD\QVD_PE\azer\blabla.qvd] (qvd);

Re: General script error

prieper — Sat, 27 Dec 2014 09:51:18 GMT

Please check, whether the qvd, into which you wish to store, is not blocked (by previous QV-process) - helpwise you may change (temporarily) the name of this qvd.

Else you may check, whether you have an antivirus-program scanning/blocking your directory.

As Nagaian has written, specify the format (qvd)

Does you script really stop after the STORE-command? you may add an EXIT SCRIPT right behind.

HTH Peter

Re: General script error

simospa — Sun, 28 Dec 2014 06:37:14 GMT

I'm quite agreed with Mario, try to delete blabla.qvd. If the system said that it is not possibile, then try to kll QV process and then retry to reload script.

Simon