topic Re: QlikView 11.2 SR8 Direct Discovery error on AccessPoint in QlikView

QlikView 11.2 SR8 Direct Discovery error on AccessPoint

Anonymous — Tue, 04 Nov 2014 14:01:07 GMT

Hello,

I try to develope my first QV App with direct discovery. For access to MS SQL I use OLEDB connectionstring.

In QlikView Desktop works direct discovery fine. But on AccessPoint I get an error "direct query failed".

I cannot find why. AccessPoint and QV Desktop are on the same server.

SCRIPT:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;...;
STAFF:
LOAD
    Name,
    ID;
SQL SELECT *
FROM dbo."V_STAFF";

DIRECT_DISCOVERY:
DIRECT QUERY
     DIMENSION
     ID
     MEASURE
     AMOUNT
     DETAIL
      DATE
FROM dbo."V_TEST";

Any ideas?

Thanks.

Re: QlikView 11.2 SR8 Direct Discovery error on AccessPoint

Tue, 09 Dec 2014 02:33:47 GMT

I ran into a similar problem. My issue was related to not having the Qlik web service added to the security of the SQL database. Once I added this on, I was able to use Direct Discovery (but still had issues with the Section Access part of things).

Re: QlikView 11.2 SR8 Direct Discovery error on AccessPoint

rohit214 — Thu, 06 Apr 2017 08:09:52 GMT

Hi Dimitri,

Please just remove the table name from direct query.

Just write

DIRECT QUERY
     DIMENSION
     ID
     MEASURE
     AMOUNT
     DETAIL
      DATE
FROM dbo."V_TEST";

Regards,

Rohit Gupta