Qlik Sense Direct Discovery is losing connection to Database

essalj666 — Tue, 16 Oct 2018 11:18:37 GMT

Hi ALl.

I am getting the error message "Error: Connection to Database lost" whenever I am making selections in data.

Only when I select everything...the error message disappears.

The weird thing is that it worked a few days ago....another query (that I cannot find)

My script:

LIB CONNECT TO 'impala 32 lrj';

DIRECT QUERY

DIMENSION cus_org_country_cd, upper(country) as country

MEASURE counttr

DETAIL cus_id_cdw

from rba1.transactions;

After loading data

And after selecting a field

And after clicking "V" in the filter

I have tried

rewriting the query in numerous ways
using other data
setting different DirectConnect parameters
- SET DirectConnectionMax=8tThreshold= 100000;
- SET DirectIdentifierQuoteChar='[]';
- SET DirectUnicodeStrings = TRUE;
  SET DirectDistinctSupport='false';
I have also tried with Desktop Version of Qlik.

Nothing makes a difference

Just now I tried installing Power BI, and the worst thing....that worked fine...

I want my Qlik Sense to work, but how?

Re: Qlik Sense Direct Discovery is losing connection to Database

Sarye — Sun, 09 Jun 2019 10:19:56 GMT

Hi essalj666,

I ran into the same issue with SQL Server. And I found multiple people with various data source struggling with direct discovery. In the script part, setting the following parameter solved the issue for me:

SET DirectEnableSubquery=true;

Here is the doc explaining what this parameter does : https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/DirectDiscovery/using-subqueries-direct-discovery.htm

topic Qlik Sense Direct Discovery is losing connection to Database in App Development

Qlik Sense Direct Discovery is losing connection to Database

My script:

Re: Qlik Sense Direct Discovery is losing connection to Database