Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Direct Query Issues

I created an application to read direct from SQL Server, but it didn't work . when I added new record to the the Table on SQL , it doesn't appears on Qlik Application automatically.  

I attached Screenshot from the code. 

8 Replies
petter
Partner - Champion III
Partner - Champion III

The default cache limit for Direct Discovery is 1800 seconds which is 30 minutes. Have you tried changing it by setting the DirectCacheSeconds environment variable?

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/DirectDiscovery/direct-discovery-v...

SET DirectCacheSeconds=10;

Anonymous
Not applicable
Author

I am using version 3.0

Anonymous
Not applicable
Author

I tried SET DirectCacheSeconds=10; and didn't work

Anonymous
Not applicable
Author

petter-s‌ Did you check the attachment?

petter
Partner - Champion III
Partner - Champion III

Yes I saw your screenshot.

petter
Partner - Champion III
Partner - Champion III

Nothing as far as I can see is strange with your load script.

petter
Partner - Champion III
Partner - Champion III

The documentation for Qlik Sense 3.0 is identical as far as I can tell:

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/DirectDiscovery/direct-discovery-variab...

petter
Partner - Champion III
Partner - Champion III

Have you tried to contact Qlik support and report it as a bug?