topic Re: Reload fails with General script error in QlikView

Reload fails with General script error

Thu, 29 Oct 2015 07:14:27 GMT

Hi,

We need to know what are the other Situations where we get general script error.

1. when there is missed column and wrong syntax ...

but in the above cases we get the detailed errors.

For us it always just says "General script error". (please refer below screenshot).

Any advice or thoughts.

Thanks in Advance.

[Edited] : We also found that our RAM/memory(8GB) reached to maximum. Currently we are trying to increase it.

Message was edited by: anjan kumar

Re: Reload fails with General script error

Anonymous — Thu, 29 Oct 2015 15:57:06 GMT

Are you running 2 process at the same time?

Can you please share the entire script?

Re: Reload fails with General script error

Thu, 29 Oct 2015 16:29:29 GMT

Thanks for the reply,

Are you running 2 process at the same time?

[Anjan]: No

Can you please share the entire script?

[Anjan]: The same script Runs on our test instance.I am not sure about sharing the entire script .

We also found that our RAM/memory(8GB) reached to maximum. Currently we are trying to increase it.

Re: Reload fails with General script error

Anonymous — Thu, 29 Oct 2015 16:47:55 GMT

Session time out or connection concern. Just check your script if it is misbehaving(some join issue)

Re: Reload fails with General script error

Clever_Anjos — Thu, 29 Oct 2015 16:52:25 GMT

>>We also found that our RAM/memory(8GB) reached to maximum. Currently we are trying to increase it.

You have found the issue, probably your JOIN is taking to much memory

I possible, post part of your script (the last LOAD that is generating the error), we could suggest some improvements

Re: Reload fails with General script error

Thu, 29 Oct 2015 17:58:40 GMT

Thanks for the suggestions.

cleveranjos‌: Sure i will.

Hope this helps.

left join (Feedbacks)

load [Feedback ID], If(fbClosedOrNow > fbCreated, Floor(fbClosedOrNow - fbCreated), 0) as [openedDays]

resident Feedbacks;

@Imran : I too believe it is because of Join.

I have started looking at joins now. I will update, if i find any.

Re: Reload fails with General script error

Anonymous — Thu, 29 Oct 2015 18:12:41 GMT

If you find provided answer correct/helpful.. kindly tag it accordingly so that it can help the other members

Re: Reload fails with General script error

Clever_Anjos — Tue, 03 Nov 2015 11:35:28 GMT

I can see you´re calculating [OpenedDays], is it possible to do this before in the script? Maybe when loading your qvd´s

Re: Reload fails with General script error

swuehl — Tue, 03 Nov 2015 11:39:08 GMT

I think you should be able to replace the JOIN with a preceding load:

[Feedbacks]:

LOAD *,

If(fbClosedOrNow > fbCreated, Floor(fbClosedOrNow - fbCreated), 0) as [openedDays];

LOAD [Feedback ID],

AllYourOtherFeedbacksTableCode,

....

FROM YourFeedBackSourceTable;

Re: Reload fails with General script error

petter — Wed, 04 Nov 2015 06:36:31 GMT

STORE has a nasty habit of throwing a "General Script Error".

Especially when you do a STORE command and what is specified after the INTO part is "wrong" - like a non-existing path or there is an out-of-space situation on the storage device you are using or the file is locked already by another process.

Re: Reload fails with General script error

Thu, 19 Nov 2015 11:59:25 GMT

Hi All,

We resolved this issue today, we checked that the data was Corrupted. Due to which it was making Cartesian Product and memory was exhausted. We corrected it and it Worked.

Thanks for all the replies.

Re: Reload fails with General script error

Mark_Little — Thu, 19 Nov 2015 12:22:33 GMT

Hi,

Lot of good ideas,

I would normally start by adding Trace commands in the script to find out exactly were it drops out.

i.e.

Trace 'Load table 1':

...

Trace 'Load table 2'

Then will see where it drops out and hopefully give you somewhere to troubleshoot further.

Mark