Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

Direct Discovery with MS SQL Views - Direct query failed

Hello,

I have some problems with Direct Discovery. We use QlikVew 11.2 SR10 with MS SQL 2008 R2 and publish the Apps on AccessPoint.

Direct Discovery works only if it access to sql tables directly or views with one table. If I use joins in views I get an error "direct query failed".

In addition is Direct Discovery very selektiv with sql view formats. Not all formats will be accepted.

With Views, which contain another views, doesn't work direct discovery too. Always error "direct query failed".

Has anyone expirienced this?

P.S. In Desktop works all, the problem is with AccessPoint only.

1 Solution

Accepted Solutions
Highlighted
Contributor

Re: Direct Discovery with MS SQL Views - Direct query failed

I found the solution:

SET DirectUnicodeStrings=TRUE;

It works fine now.

View solution in original post

1 Reply
Highlighted
Contributor

Re: Direct Discovery with MS SQL Views - Direct query failed

I found the solution:

SET DirectUnicodeStrings=TRUE;

It works fine now.

View solution in original post