topic Re: direct discovery doesn't work on access point in QlikView

direct discovery doesn't work on access point

woshua5550 — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I'm trying to make a direct discovery and it works well on desktop , After i change a number in my database , data in qvw will be refreshed when i reopen it . but it keep unchanged on access point

what should i do?

thx

Re: direct discovery doesn't work on access point

oknotsen — Tue, 19 Apr 2016 06:42:24 GMT

Few things:

- Check what version of QlikView (including SR) your server is running

- Check the cache time for Direct Discovery. I think this is 30 minutes by default (IIRC), but can be changed with a setting. If this time out is not reached yet, a new query will not be launched against your database.

Re: direct discovery doesn't work on access point

woshua5550 — Tue, 19 Apr 2016 10:41:35 GMT

hey handsome~ thank you very much

maybe you are right , i wait for over half an hour, the number changed

counld you tell me how to set up the cache time ?

Re: direct discovery doesn't work on access point

oknotsen — Tue, 19 Apr 2016 12:13:56 GMT

This should be the way to set it in your script:

set DirectCacheSeconds = 300;

So the setting is in seconds.

Note that you might not want to set the number TOO low, as the result it is will constantly trigger queries to your database (which might have a negative performance effect on your production system).