Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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.