topic Re: Data loading is stuck and no progress in QlikView

Data loading is stuck and no progress

baylor2016 — Fri, 29 Jun 2018 14:21:20 GMT

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

Re: Data loading is stuck and no progress

YoussefBelloum — Fri, 29 Jun 2018 14:25:33 GMT

Hi,

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

Re: Data loading is stuck and no progress

baylor2016 — Fri, 29 Jun 2018 14:30:38 GMT

Here is the log file. Thanks

Re: Data loading is stuck and no progress

YoussefBelloum — Fri, 29 Jun 2018 14:36:45 GMT

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

Re: Data loading is stuck and no progress

olivierrobin — Fri, 29 Jun 2018 14:43:23 GMT

hello

did you try the same request without qv

directly on the db ?

Re: Data loading is stuck and no progress

baylor2016 — Fri, 29 Jun 2018 14:48:46 GMT

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;

Re: Data loading is stuck and no progress

baylor2016 — Fri, 29 Jun 2018 14:50:54 GMT

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

Re: Data loading is stuck and no progress

baylor2016 — Fri, 29 Jun 2018 14:53:02 GMT

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

Re: Data loading is stuck and no progress

olivierrobin — Fri, 29 Jun 2018 14:56:19 GMT

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 ?

Re: Data loading is stuck and no progress

baylor2016 — Fri, 29 Jun 2018 14:58:52 GMT

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

Re: Data loading is stuck and no progress

baylor2016 — Fri, 29 Jun 2018 15:01:23 GMT

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

Re: Data loading is stuck and no progress

olivierrobin — Fri, 29 Jun 2018 15:11:28 GMT

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

Re: Data loading is stuck and no progress

baylor2016 — Fri, 29 Jun 2018 15:17:23 GMT

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?

Re: Data loading is stuck and no progress

olivierrobin — Fri, 29 Jun 2018 15:20:45 GMT

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