Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

General Script Error - Execution Failed

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

12 Replies
vishsaggi
Champion III
Champion III

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------------------//

howiekrauth
Partner - Contributor III
Partner - Contributor III

My code works.  I've tested it.

vishsaggi
Champion III
Champion III

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