topic Re: Sometimes I get General Script Error in QlikView

Sometimes I get General Script Error

Mon, 27 Aug 2012 14:30:14 GMT

Hi,

Sometimes I get General Script Error when my qwv is loading.

In short words it works like this.
The application begins to load from one or more qvd's to table A

Then it loads from table A with where condition..

Then it Concatenate Loads from table A with another where condition.

and again

Concatenate Loads from table A with another where condition.

It runs on a server and I tested the same file locally and no general script error.

Also, I let the server load the file again with success.

The Interval of the load on the server is 3 minutes.

The application never loads the same qvd file twice.

So, does anyone want to suggest what's going on here?

regards, Kári

Re: Sometimes I get General Script Error

danielrozental — Tue, 28 Aug 2012 12:28:55 GMT

You're probably running out of memory, check your scripts memory consumption, or you can also try restarting services before stating reloads.

Re: Sometimes I get General Script Error

erichshiino — Tue, 28 Aug 2012 12:38:05 GMT

Hi,

Do you have an extractor an another application to read the qvds?

If this is the case, do they run sequencially? It could be a problem is the QVD is being written and you try to read it at the same time, or if you are reading and other app tries to overwrite it.

Regards,

Erich

Re: Sometimes I get General Script Error

Tue, 28 Aug 2012 13:57:06 GMT

I have an SSIS package to read the csv output from this application - could that be the problem ?

Re: Sometimes I get General Script Error

Tue, 28 Aug 2012 14:02:38 GMT

The memory is fine - these qvd files are so tiny that I guess that is not the problem.

I have one Qlikview application that creates the qvd's that this application is reading but this application starts when the first one have finished.

Then I have an output from this application (csv) and SSIS package on SQL server is reading it and then is moves it to another folder.

First app - > starts every 3 minutes

this app (the problem) -> starts after the first app

SSIS -> every 1 minute.

Re: Sometimes I get General Script Error

erichshiino — Tue, 28 Aug 2012 14:03:34 GMT

If you check the log file, can you identify the point where the scritps fail? Can you compare the timestamp with the moment when SSIS reads you csv output?

Regards,

Erich

Re: Sometimes I get General Script Error

Tue, 28 Aug 2012 14:08:27 GMT

I'll have it in mind next time it happens.

I did some changes in the file structure and I will keep you informed if that alone did solve it.
If not I'm going to store the csv in a temp folder and then use a cmd execution to move it in the right folder. Then I know I'm not writing the file from qlikview when the SSIS is trying to read it.

Re: Sometimes I get General Script Error

Thu, 30 Aug 2012 15:55:32 GMT

It didn't work. Not the first change nor the second change.

So it seems that it's not file error or access to it.

Now I don't know what to do. I have to restart the server when it happens so it's rather big problem.

Re: Sometimes I get General Script Error

Wed, 05 Sep 2012 12:39:50 GMT

One thing I want to mension to help me rosolve the problem.

It seems that a VBscript function in the module could be the problem.

I added 2 functions to the 5 that were ther before.

these two functions are depending on one function that already exist.

In the log I see the general script error happening when I'm using these to function that I had added.

Could there be some memory issue if certain memory is allocated for these functions ?

regards, Kári