Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

I found the solution:

SET DirectUnicodeStrings=TRUE;

It works fine now.

View solution in original post

1 Reply
Anonymous
Not applicable
Author

I found the solution:

SET DirectUnicodeStrings=TRUE;

It works fine now.