General Script Error - Execution Failed

[Anonymous]

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

[vishsaggi]

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);

[howiekrauth]

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.

[Anonymous]

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?

[Anonymous]

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

[vishsaggi]

Are the paths correctly given when you move to test?

[tamilarasu]

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.

[howiekrauth]

Remove the square brackets when you pull FROM

FROM QVD.qvd (qvd);

not

FROM [QVD].qvd (qvd);

I would also load xyz first.

so

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);

[Anonymous]

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

[vishsaggi]

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 *?