Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
SET DirectUnicodeStrings = TRUE;
SET DirectDistinctSupport='false';
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?
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...