topic Re: "Direct Query Failed" Error using Direct Discovery in QlikView

"Direct Query Failed" Error using Direct Discovery

Wed, 27 Aug 2014 10:13:59 GMT

I am using QV 11.2 SR7 version client. Using the Direct Discovery feature, I am trying to fetch data from SAP HANA database(Calculation View) using ODBC connection.

So my script reads like below:

ODBC CONNECT32 TO HDB;

DIRECT QUERY

DIMENSION

SALESMANNAME,

COUNTRYNAME,

REGIONNAME,

AREANAME,

OUTLETGRPNAME,

TEOUTLETTYPECODE,

OUTLETTYPENAME

MEASURE

CALLFREQ,

NO_STORES

FROM

"_SYS_BIC"."CPG.dra/Z_CA_DIST_OUTLET_COUNT";

This all works fine.

However when I create a bar chart or straight table with any of the above mentioned Dimensions and Expressions,

it just displays an error message saying "Database connection failed" or if I create a table box with any of the Dimension,

it gives error as "Direct Query Failed".

Has anyone come across similar errors?
Your help and inputs are highly appreciated.

Thanks in advance

Sabal

Re: "Direct Query Failed" Error using Direct Discovery

Wed, 27 Aug 2014 13:08:20 GMT

Hi All,

Any idea about this?

Thanks
Sabal

Re: "Direct Query Failed" Error using Direct Discovery

alvinford — Wed, 03 Sep 2014 02:13:28 GMT

Dear Sabal,

Did you able to find the solution for this. Facing the same issue.

Regards,

Alvin.

Re: "Direct Query Failed" Error using Direct Discovery

Anonymous — Wed, 03 Sep 2014 16:54:07 GMT

bump. Same issue here. Connecting to SQL.

Re: "Direct Query Failed" Error using Direct Discovery

Vegar — Wed, 08 Oct 2014 21:26:06 GMT

Did you ever solve this issue?

Do anyone else have a suggestion for a solution?

I ran into the same problem yesterday when trying to connect an Oracle database with ODBC. Reading data in the script works fine, but 'Database connection failed' shoes on all objects where I try calculate a measure.

I'll update this post if I find something that solves this issue.

Cheers

Vegar

Re: "Direct Query Failed" Error using Direct Discovery

hirenp0904 — Tue, 04 Nov 2014 23:25:21 GMT

Did you get reply on this? Could you share the response.

Re: "Direct Query Failed" Error using Direct Discovery

Vegar — Wed, 05 Nov 2014 05:14:25 GMT

In my case the issue disappeared when I changed my where statement. I had a date in it, nu when I changed it to a Char I had no problem with it anymore.

The strange part is that the original query worked if I ran it as a SQL select statement, but not direct query.

Re: "Direct Query Failed" Error using Direct Discovery

Fri, 14 Nov 2014 17:39:09 GMT

Sorry guys...
I still did not find the solution for this.

Re: "Direct Query Failed" Error using Direct Discovery

alec1982 — Thu, 09 Jul 2015 21:55:12 GMT

I have the same issue.. anyone got a fix?

Re: "Direct Query Failed" Error using Direct Discovery

Thu, 10 Dec 2015 15:09:44 GMT

The same problem here.

QV version - 11.20.12904.0 SR12 x64

Cloudera ODBC Driver for Hive - 2.05.16.1005

Re: "Direct Query Failed" Error using Direct Discovery

Sarye — Sun, 09 Jun 2019 10:17:13 GMT

Hi,

I ran into the same issue with SQL Server. 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