Unkillable Sessions

brendan_boelke

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.

Phenno

Stopsession will not be able to kill session always. Check here for more info:https://msdn.microsoft.com/en-us/library/hh168240(v=nav.90).aspx

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.

robertwendler@yahoo.de

You should update to the latest cumulative update (technical). Also you can try to kill the sessions directly, if you restart the NST.

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.