QS Load From Oracle DB with FIRST()

konHi — Tue, 07 Dec 2021 15:40:58 GMT

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

topic QS Load From Oracle DB with FIRST() in App Development

QS Load From Oracle DB with FIRST()