Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 268 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Unkillable Sessions
brendan_boelke
Member Posts: 6
We have a customer who is getting sessions that cannot be killed. I modified the Session page to allow for Deletion (STOPSESSION) but these sessions refuse to die, and are tying up licenses. The only way to clear them is a service/server restart. Has anyone had any experience with this? NAV 2013 R2 with SQL Server 2008 R2.
0
Answers
Furthermore, sometimes session does not exist anymore but still exists in active session table. If you try to kill it via powershell remove-navsession, you receive message like: session does not exists. Not sure if it is ok in that situation to simply remove record from active session table.
If the sessions can not be killed, then you can find the session working forever in the activity monitor of the sql server. With the sql profiler you can trace the session.
If you do so, you can recognize which process causes this behaviour.
Robert's Dynamics NAV Blog - Vom NAV Entwickler für NAV (Navision) Interessierte