topic Re: General Script Error - Execution Failed in QlikView

General Script Error - Execution Failed

Anonymous — Tue, 07 Aug 2018 06:11:06 GMT

Hi Champs

A very unusual behaviour has got me mad over Qlikview.

I am trying to do a simple load * from a qvd file (10 GB) that was generated from an OLEDB connection and it gives me the 'General script error - Execution Failed'.

When I try to extract data from that QVD through qlik interface (Table files) it gives 'Unknown error' (attached screenshot).

I have tried deleting the QVD file and generate it, but still same error.

Folks any idea what I am doing wrong here. Any help is appreciated.

Thanks

Chakshu

Re: General Script Error - Execution Failed

vishsaggi — Tue, 07 Aug 2018 21:12:34 GMT

Are you using LOAD * FROM yourqvdfilename.qvd(qvd)? Did you see if there are any field names that are same in the LOAD script.

Like if you have any like

LOAD Field1, Field2, FIeld3, Field1

FROM QVDFilename.qvd(qvd);

Re: General Script Error - Execution Failed

howiekrauth — Tue, 07 Aug 2018 21:44:29 GMT

You're loading MAX (Something) as Max_ID from the qvd.

You need a "Group By" in your script.

Load (someotherfield),

max (Something) as Max_ID

from file.qvd (qvd)

group by (someotherfield);

Why that error can't be specific, I'm not sure, but I've seen it plenty.

Re: General Script Error - Execution Failed

Anonymous — Tue, 07 Aug 2018 23:48:20 GMT

Hi Krauth,

I am just extracting max of an ID and storing that in an variable to implement incremental load. Not using any other field along with aggregation function that should be included in group by.

It looks something like this.

//----------------------Code------------------//

Max_Line:

Load max(ID_NUM) as Max_LineID

FROM

[QVD.qvd]

(qvd);

Let vMaxLineID=peek('Max_LineID',0,'Max_Line');

xyz:

Load * from

[QVD.qvd](qvd);

Concatenate(xyz)

SQL

Select * from [Dummy Source]

where ID_NUM>$(vMaxLineID);

Store xyz into QVD.qvd(qvd);

//----------------Finish------------------//

Is there something in the script that needs to be changed?

Re: General Script Error - Execution Failed

Anonymous — Tue, 07 Aug 2018 23:56:02 GMT

Nope, there aren't any. I built the code on my personal machine and was just trying to push the code in test environment and there comes this issue. It worked perfect on my personal machine though.

Regards

Re: General Script Error - Execution Failed

vishsaggi — Wed, 08 Aug 2018 17:39:27 GMT

Are the paths correctly given when you move to test?

Re: General Script Error - Execution Failed

tamilarasu — Wed, 08 Aug 2018 18:12:57 GMT

Hi,

It looks like your qvd itself not generated properly. It should show records when you load through file wizard. Try to find out the reason by checking the qvd generator log file.

Re: General Script Error - Execution Failed

howiekrauth — Wed, 08 Aug 2018 18:50:48 GMT

Remove the square brackets when you pull FROM

FROM QVD.qvd (qvd);

not

FROM [QVD].qvd (qvd);

I would also load xyz first.

xyz:

Load * from

QVD.qvd

(qvd);

Max_Line:

Load max(ID_NUM) as Max_LineID

FROM QVD.qvd

(qvd);

Let vMaxLineID=peek('Max_LineID',0,'Max_Line');

Concatenate(xyz)

SQL

Select * from [Dummy Source]

where ID_NUM>$(vMaxLineID);

Store xyz into QVD.qvd(qvd);

Re: General Script Error - Execution Failed

Anonymous — Thu, 09 Aug 2018 00:15:06 GMT

I am 100% sure they are because I tried to run the code individually and it worked!

Re: General Script Error - Execution Failed

vishsaggi — Thu, 09 Aug 2018 00:55:44 GMT

Can you show the script you are trying to run? Is this only on qvd file you are loading? Can you mention all the field names as well rather than *?

Re: General Script Error - Execution Failed

vishsaggi — Thu, 09 Aug 2018 00:59:37 GMT

In this can you use quotes around the variable. like

//----------------------Code------------------//

Max_Line:

Load max(ID_NUM) as Max_LineID

FROM

[QVD.qvd]

(qvd);

Let vMaxLineID=peek('Max_LineID',0,'Max_Line');

xyz:

Load * from

[QVD.qvd](qvd);

Concatenate(xyz)

SQL

Select * from [Dummy Source]

where ID_NUM > '$(vMaxLineID)';

Store xyz into QVD.qvd(qvd);

//----------------Finish------------------//

Re: General Script Error - Execution Failed

howiekrauth — Thu, 09 Aug 2018 01:11:10 GMT

My code works. I've tested it.

Re: General Script Error - Execution Failed

vishsaggi — Thu, 09 Aug 2018 01:43:47 GMT

That response was for Chakshu Jain. Just wanted him to try.