Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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?