Persistent User Sessions even after restarting the service
Tomigs
Member Posts: 88
Hi,
We have noticed that some of the sessions are left idle on the session list from many days ago and we cannot manually stop them (we have a mod to stop them from sessions page, using the STOPSESSION command). It normally works but for some particular sessions it just won't work. Even worse, they'll stay even after restarting the service. We have noticed this behavior since some weeks ago.
The only workaround I've found so far to keep the session list clean is removing them directly from the Active Session table through SQL.
The context is on a bigger problem scenario, as we are having heavy performance issues in one NAV database (upgraded some years ago from a NAV2013R2 database). And not sure if this "immune" sessions could be a symptom or a cause or nothing to do at all with the overall bad performance situation.
The issues itself are some transactions that used to work immediately now sometimes (randomly) take minutes and minutes to complete leaving the users hang for minutes. It is a complex scenario (database upgraded from NAV2013R2, 2 NAV servers with two services each, working through a NLB, etc).
Coming back to the persistent sessions, among many other avenues, we have tried cleaning the session event table as described here but same results
https://community.dynamics.com/business/b/stefanodemiliani/posts/nav-session-event-table-cleanup
Also, checked this thread where the users were not being disconnected using Idle parameters. We tried to set up Idle timeout to see if that could stop them but the result was quite bad, as the users were reporting that active sessions were being stopped.
In the thread they mention that the issue with them was something to do with the dbo and the nav$listener but I'm not sure what they are referring to.
"Someone... has changed the user mapping from dbo to the old nav$listner... in sql server. The navservice user has permissions problems."
https://community.dynamics.com/nav/f/microsoft-dynamics-nav-forum/182460/nav2013r2---clients-sessions-aren-t-disconnected
Regards,
Tomas
We have noticed that some of the sessions are left idle on the session list from many days ago and we cannot manually stop them (we have a mod to stop them from sessions page, using the STOPSESSION command). It normally works but for some particular sessions it just won't work. Even worse, they'll stay even after restarting the service. We have noticed this behavior since some weeks ago.
The only workaround I've found so far to keep the session list clean is removing them directly from the Active Session table through SQL.
The context is on a bigger problem scenario, as we are having heavy performance issues in one NAV database (upgraded some years ago from a NAV2013R2 database). And not sure if this "immune" sessions could be a symptom or a cause or nothing to do at all with the overall bad performance situation.
The issues itself are some transactions that used to work immediately now sometimes (randomly) take minutes and minutes to complete leaving the users hang for minutes. It is a complex scenario (database upgraded from NAV2013R2, 2 NAV servers with two services each, working through a NLB, etc).
Coming back to the persistent sessions, among many other avenues, we have tried cleaning the session event table as described here but same results
https://community.dynamics.com/business/b/stefanodemiliani/posts/nav-session-event-table-cleanup
Also, checked this thread where the users were not being disconnected using Idle parameters. We tried to set up Idle timeout to see if that could stop them but the result was quite bad, as the users were reporting that active sessions were being stopped.
In the thread they mention that the issue with them was something to do with the dbo and the nav$listener but I'm not sure what they are referring to.
"Someone... has changed the user mapping from dbo to the old nav$listner... in sql server. The navservice user has permissions problems."
https://community.dynamics.com/nav/f/microsoft-dynamics-nav-forum/182460/nav2013r2---clients-sessions-aren-t-disconnected
Regards,
Tomas
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions