|Issue||Click on File>Database>Information>Sessions and scroll through the records. Navision locks up and user needs to stop the Navision service.
||Go to the path as in the attachment on SQL and go to "Alter To" and choose "New Query Editor Window" and then change the SELECT command to SELECT DISTINCT and then hit execute button on the top bar. This does the trick.
Note: This solution will have to be applied to all the Navision databases on the server individually i.e. LIVE, TEST, etc.
Modified on: Mon, Dec 12, 2016 at 3:21 PM
Did you find it helpful?Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.