Data loading is stuck and no progress

[baylor2016]

Hi,

My query with many CTEs used to work fine, but the data loading is now stuck at the same place. 

Here is the last several lines in the log file.

6/29/2018 8:16:47 AM: 1401  )

6/29/2018 8:16:47 AM: 1402  select *

6/29/2018 8:16:47 AM: 1403  from HM_ModifierDTT

6/29/2018 8:17:21 AM:           5 fields found: PAT_ID, HM_MODIFIERID3, USERID, HM_AUDITACTION, HM_MODIFIERDTT, 10,132 lines fetched

Any suggestions are welcome.

By the way, The Qlik desktop I am using is 11.20.13607.0 SR17 64-bit. The database is Oracle 11g.

Thanks

Longmatch

[YoussefBelloum]

Hi,

there is no issue with the log lines shared above.. maybe share the log file ?

[baylor2016]

Here is the log file. Thanks

[YoussefBelloum]

do you have +11k of sql code lines ??

[olivierrobin]

hello

did you try the same request without qv

directly on the db ?

[baylor2016]

The query is about 842 lines. I used Include like below. The same query might load multiple times.

HM_ModifierDTT:

sql

$(include=QIDashboardIncluded.txt)

select *

from HM_ModifierDTT;

[baylor2016]

The query in DB works fine. It only takes about 10 seconds to return first 50 rows.

[baylor2016]

Shared query might not be a good approach. Is QVD a better way?

[olivierrobin]

as you write : 10 secs but for 50 rows

don't forget qlik retrieves all rows

so if you try to retrieve all rows , how long does it take ?

[baylor2016]

About the same when exporting all the records from that query to Excel - less than 10 seconds.