Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
essalj666
Contributor II
Contributor II

Qlik Sense Direct Discovery is losing connection to Database

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

q10.png


And after selecting a field

q11.png



And after clicking "V" in the filter


q12.png



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?


1 Reply
Sarye
Contributor II
Contributor II

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