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

From the log file, all the records (10132) were retrieved. Somehow it did not move to next query.

olivierrobin
Specialist III
Specialist III

could you modify your query to retrieve only one column ?

i had such a problem with select * and i replaced with the list of columns

another way is to activate odbc logs and see what happens

baylor2016
Creator
Creator
Author

I will try to use column name instead of *.

I have many select * from before this query, but it always stuck here.

How to activate ODBC log?

olivierrobin
Specialist III
Specialist III

have a look at odbc driver configuration

i don't remember exactly

in odbc driver config, you can configure the trace

you will have to start it before to execute the query

DON'T FORGET to stop the trace after !!!!!!