Qlik Sense Direct Discovery is losing connection to Database

[essalj666]

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?

[Sarye]

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-s...