1

I would like to know if somebody knows how Dynamics NAV cache works.

I'm really a beginner of NAV, but I tested this:

  • If I update or delete (not insert) a row in a table by SQL, NAV doesn't update its internal cache and sometimes refreshing its page I can see new data, for some table I have to restart the service.
  • I can setup more the one application server, they will be connected each other only by SQL database, I gather that application server can syncronize their cache using SQL tables (timestamps or metadata...).

My question is: is it possibile to force the cache expiration of internal NAV cache only by SQL? If no, how can two application server sync their cache?

I know that data manipulation via SQL is highly discouraged, but please help me to understand how it works. Thanks

Tobia
  • 9,165
  • 28
  • 114
  • 219
  • Thank you Mak, yes, for application I mean NAV server. I'm quite sure there is a cache due to the first pt I wrote. If you try to change some value directly in the database you will not find istantly this edit in NAV and you have to refresh the page. – Tobia Jul 20 '17 at 12:33
  • I think the server syncronization is made using $ndo$cachesync table for some tables. But not really clear how. – Tobia Jun 04 '19 at 10:03

2 Answers2

1

You might want to take a look at the SELECTLATESTVERSION function.

Bugs
  • 4,491
  • 9
  • 32
  • 41
sgralla
  • 55
  • 5
1

Might not be the solution for everyone, but I solved my issue in test by just restarting the "Microsoft Dynamics NAV Server" service. Again, this solution is not without its issues (kicking users off, etc.) but it was the solution for me.

Jason D.
  • 390
  • 3
  • 11