topic Re: General Script error in QlikView

General Script error

Deepak13 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All

While reading data from QVDs I am getting the "general script error".

below is the log related to the same script.

LEFT JOIN (MAINTABLE)
LOAD ABC as ABC,
EFG as EFG
FROM $path\XYZ_DIM.FULL.qvd(qvd)
2 fields found: ABC, EFG,
1,325,426 lines fetched
Joining/Keeping
General Script Error
Execution Failed
Execution finished.

Re: General Script error

ramasaisaksoft — Tue, 05 Nov 2019 06:21:14 GMT

Hi Deepak,

I Have couple of guesses on this General Error:

load application under debug mode 10 records each
load tables one by one (probably also in debug) and see where the error incurs
Some times Join also cause
does it always happen on the same table? if you change the order of loading?
do you have the rights to read in the database?

So please check all these conditions else if possible share entire Script so that our folks will help you ASAP.

Re: General Script error

Deepak13 — Tue, 05 Nov 2019 06:35:20 GMT

Thanks for replying Ramana

No, this is the first time i am facing this issue.

There were few changes i made in the script:

1) added a table to pull few columns from it

2) added 2 additional columns from an existing QVD

Re: General Script error

Geeks — Tue, 05 Nov 2019 06:36:14 GMT

Please put ; after From statement and try loading

Re: General Script error

Deepak13 — Tue, 05 Nov 2019 06:40:41 GMT

I checked the script and already have ; after the from statement

Re: General Script error

Frank_Hartmann — Tue, 05 Nov 2019 08:28:29 GMT

is there any message during script reload if you put:

Set ErrorMode =1;

at the beginning of your Load?

Re: General Script error

Deepak13 — Tue, 05 Nov 2019 08:34:09 GMT

I can see Set ErrorMode =2 in the log of QVW that failed. What does it mean??

Re: General Script error

Frank_Hartmann — Tue, 05 Nov 2019 09:53:43 GMT

Somewhere in your script is the following line :

Set ErrorMode = 2

Change it to

Set ErrorMode = 1

and have a look at the errormessage appearing when reloading script!

From Qlikviw Help:

ErrorMode This variable determines what action is to be taken by QlikView when an error is encountered during script execution. By default (ErrorMode=1) the script execution will halt and the user will be prompted for action (non-batch mode). By setting ErrorMode =0 QlikView will suppress all error messages on failure to load. If script execution is halted due to failure, it will not continue. By setting ErrorMode =2 QlikView will trigger an "Execution of script failed..." error message immediately on failure, without prompting the user for action beforehand. Example: set ErrorMode=0;

Re: General Script error

andrei_delta — Tue, 05 Nov 2019 14:43:40 GMT

hello,

try give the fields other names then the one they already have

Re: General Script error

Deepak13 — Fri, 08 Nov 2019 14:12:19 GMT

Checked the data model, there were circular loops in it, removed them, issue is fixed.

Thanks for the suggestion