Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
konHi
Partner - Contributor III
Partner - Contributor III

QS Load From Oracle DB with FIRST()

Hi,

I have a similar problem to this one:

https://community.qlik.com/t5/New-to-Qlik-Sense/Script-Error/td-p/1124442

but not sure.

My Script:

Connect ....;

TABLE1:

FIRST (1000) LOAD * ;

SELECT ... ;

 

TABLE2:

LOAD *;

SELECT ... ;

If I keep the FIRST statement for Table 1, I receive the QVX error when script reaches Table2. If I comment out the FIRST statement, everything works fine.

As a workaround I figured out to use

disconnect; Connect... ;

between the tables. The script works fine.

Tried sleep 60000, did not help.

What do you think, is it a bug or do I miss something?

 

Env: Qlik Sense 2021 August Patch 4

 

 

Labels (1)
0 Replies