Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Sometimes I get General Script Error

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

8 Replies
danielrozental
Honored Contributor II

Re: Sometimes I get General Script Error

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

erich_shiino
Honored Contributor

Re: Sometimes I get General Script Error

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

Not applicable

Re: Sometimes I get General Script Error

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

Not applicable

Re: Sometimes I get General Script Error

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.

erich_shiino
Honored Contributor

Re: Sometimes I get General Script Error

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

Not applicable

Re: Sometimes I get General Script Error

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.

Not applicable

Re: Sometimes I get General Script Error

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.

Not applicable

Re: Sometimes I get General Script Error

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

Community Browser