Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
baylor2016
Creator
Creator

Data loading is stuck and no progress

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

13 Replies
YoussefBelloum
Champion
Champion

Hi,

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

baylor2016
Creator
Creator
Author

Here is the log file. Thanks

YoussefBelloum
Champion
Champion

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

olivierrobin
Specialist III
Specialist III

hello

did you try the same request without qv

directly on the db ?

baylor2016
Creator
Creator
Author

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
Creator
Creator
Author

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

baylor2016
Creator
Creator
Author

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

olivierrobin
Specialist III
Specialist III

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
Creator
Creator
Author

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