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

[baylor2016]

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

[olivierrobin]

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]

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]

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 !!!!!!