direct discovery doesn't work on access point

[woshua5550]

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

[oknotsen · Accepted solution]

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.

[woshua5550]

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 ?

[oknotsen]

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).