This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
From the log file, all the records (10132) were retrieved. Somehow it did not move to next query.
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
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?
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 !!!!!!