topic Re: Direct Discovery in version 11.2 freezing in Archived Groups

Direct Discovery in version 11.2 freezing

rbecher — Wed, 23 Jul 2025 14:48:52 GMT

Got this strange behavior sometimes that the chart is not executing the direct select query (nothing in connector log file) on a document opening or if a selection has changed. QlikView Desktop is just freezing and the chart refresh cannot be canceled by clicking the red cross. I'm testing with version 11.20.11616.0 IR, has anyone same experience?

Unfortunately the Direct Discovery beta group was removed...

- Ralf

Re: Direct Discovery in version 11.2 freezing

tseebach — Wed, 05 Dec 2012 22:04:18 GMT

I can confirm this behavoir, and did report it in the Beta group.

I also encountered it the same hanging on MSSQL .

Re: Direct Discovery in version 11.2 freezing

rbecher — Wed, 05 Dec 2012 22:07:19 GMT

Thanks Torben! Any other experiences? Which is the lates version you have tried?

I the meantime I got the info that this issue should be fixed in the GA version which will probably released next week.

- Ralf

Re: Direct Discovery in version 11.2 freezing

tseebach — Wed, 05 Dec 2012 22:31:09 GMT

I only tested the 11.2 beta which was DL on the day it was released. Which is build 11.20.11616.0

The error happened for every 3-8 queries.

I did however never get Implicit/Explicit to work. So I loaded too many fields, rather than a few needed.

Re: Direct Discovery in version 11.2 freezing

rbecher — Tue, 11 Dec 2012 15:01:20 GMT

Not only that, QlikView Direct Discovery is starting Qvconnect.exe two times and do not close them. So, at next interaction you'll have four of them..

I wonder that the Beta was closed so fast and hope this is fixed in GA.

Re: Direct Discovery in version 11.2 freezing

rbecher — Wed, 12 Dec 2012 15:56:07 GMT

Still same issues in IR 11643 (released today). A bit more stable although...

Re: Direct Discovery in version 11.2 freezing

Greg_Hood — Thu, 13 Dec 2012 13:04:10 GMT

HI all, as the Beta is closed would it be possible to log a support case for outstanding issues please?

With as much information and steps to reproduce issues as possible. Many thanks.

Re: Direct Discovery in version 11.2 freezing

rbecher — Thu, 13 Dec 2012 13:44:06 GMT

Hi Greg,

I think therefor it would be useful that you build up a test environment with JDBC Connector and SAP HANA in your labs where we can collaborate to close those issues.

Best regards,

Ralf

Re: Direct Discovery in version 11.2 freezing

Greg_Hood — Thu, 13 Dec 2012 13:46:32 GMT

Hi Ralf,

I think you should have received a request to access the QlikBug group today from Johan Bini. Johan is the project lead for 11.2 and is very interested in your input.

Kind regards

Greg Hood

Senior Manager Global Support and Escalation

Email: Support@qlik.com<mailto:Support@qlik.com>

qlik.com<http://www.qlik.com/>

QlikTech Ranks in Top 3 in Forbes Fast Tech 25

http://qlik.com/ForbesFastTech

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

Re: Direct Discovery in version 11.2 freezing

tseebach — Thu, 13 Dec 2012 13:46:58 GMT

Greg, maybe you could provide us initially with a more recent build. As some of these bugs were reported during the beta, but we never had time to get them confirmed.

If you have done fixes, then I would presume that you have improved on the reliabilty.

Re: Direct Discovery in version 11.2 freezing

rbecher — Thu, 13 Dec 2012 13:51:10 GMT

Hi Greg,

btw., I've created this QlikBug group here.. 😉

So, please tell Johan Bini to contact me by email: ralf.becher@tiq-solutions.de

- Ralf

Re: Direct Discovery in version 11.2 freezing

Anonymous — Thu, 13 Dec 2012 15:42:56 GMT

Hi,

Could you provide more info about your setup, e.g. database, script info (cleaned), data amounts?

Thank you in advance,

Best Regards,

Johan Bini

Re: Direct Discovery in version 11.2 freezing

rbecher — Thu, 13 Dec 2012 18:47:55 GMT

Hi Johan,

we use a custom connector (our JDBCConnector.dll) which works fine with SAP HANA (and other DBs) except in Direct Discovery.

The issues are not related to the datasources (HANA DB, or MySQL, ...) or amounts of data in the source or complexity of application (very simple). The behavior is:

- freeze on document open of already loaded document (chart with hourglass) on 32bit (not on 64bit), connector dll is not instantiated

- cancel button in chart gauge (red cross) has no reaction

- if a non Direct Discovery document was opened and reloaded before with same data source, next opened document with Direct Discovery and already loaded data is working fine for some interactions, we can track the DD SQLs for dimensions and aggregations in the connectors log file

- freeze after some interactions (selecting values in listboxes etc.), several DD SQLs are working then freeze

- Ralf

Re: Direct Discovery in version 11.2 freezing

Anonymous — Fri, 14 Dec 2012 08:55:32 GMT

Hi Ralf,

Thank you for the information.

With the information from Ian Crosland sent, about the noted bug:

"In certain instances with multiple Direct Discovery charts QlikView may hang due to multiple named pipe connections being executed against the source database."

Does this seem as the case? (and to mitigate with fewer charts)

Best Regards

Johan

Re: Direct Discovery in version 11.2 freezing

rbecher — Fri, 14 Dec 2012 09:15:11 GMT

Hi Johan,

this is not the case. Same issues occur also with only one chart.

- Ralf

Re: Direct Discovery in version 11.2 freezing

Anonymous — Fri, 14 Dec 2012 18:19:19 GMT

I have done a simple direct sql to a very small table on a SQL 2008 R2 server.

QlikView hangs every time i delete records in the sql table, and when i change filter in listboxes on fields using direct discovery.

I also seams to have problems with sorting in the same listboxes when data is changed.

I'm using IR 11.20..11643.0

/Henrik

Re: Direct Discovery in version 11.2 freezing

tseebach — Mon, 17 Dec 2012 12:04:58 GMT

I've just been testing 11.2 IR, and the stability issues seems definitely gone.

But its seems that QlikView is takes a really long time before executing the Query.

What I'm experiencing is: I do a selection in a Dimension, now QlikView hangs for 15-30 seconds, and then my chart go into "loading state" and i see the SQL server is handling the queries and after another 2-3 seconds i see the results.

So QlikView seems to do something new, right after i do a selection in my list boxes. Anyone know why?

I'm using win8 64 bit, QlikView Desktop, on a MSSQL Server AdventureWorks cube via a View (OLE DB) og ODBC to a SAP HANA.

The one datasource is 100 rows large, the other is 14 mio. Both hang equally long before executing the query.

Re: Direct Discovery in version 11.2 freezing

tseebach — Tue, 18 Dec 2012 14:18:05 GMT

I've just finished testing the same file on my servers. It much much faster on the server, than locally via the dekstop. The difference is larger than what I would give networking credit for, but it works very nicely on a server.