Web Service

Yagesh2504

Three Tier infrastructure is implemented which are SQL server 2016, Nav server 2016 and web server 2016. The web service some times does not find any data in table found in Nav. we have to restart the webservice to so that latest data can be found.

Previously under version SQL 2012, Nav/Web Server 2016 was working fine.

Any help??

RockWithNAV

Data enchashment happens on Service Tier so there wont be any issue from this side otherwise you may end up with this issues sometimes, Track Even viewer too!!

Yagesh2504

Is there any method to clear the cache?

vaprog

Yagesh2504 wrote: »

Is there any method to clear the cache?

Try SELECTLATESTVERSION. It gives you what's currently in the database table.
I don't know exactly how it relates to the middle tier cache. Docs talks about client cache, but read yourself:
https://docs.microsoft.com/en-us/dynamics-nav/selectlatestversion-function--database-

RockWithNAV

Try using SELECTLATESTVERSION and see if it helps you.
I remember I used this in NAV 2013 couple of times.