Business Central SaaS – Kill Sessions

It could happen that the messages “another user has modified” or “a table is locked by another user” appear, in this case you have to wait for the situation to be unlocked, by letting the users out or waiting.

Currently the only way to break the deadlocks

  • wait and wait…

  • get all users out, check that the situation has been unlocked

  • try to enter data with another user in the same tables.. do something in tables to unlock….

  • .. finally ask Microsoft to reset the instance (at night) by opening a ticket.

Surely they will be working on a better management of the sessions through telemetry or other .. I don’t know. To date, the only solution that came to my mind is to do the old way, that is, to install a session killer in BC SaaS.

In practice it is possible to see the active sessions but it is not possible to delete them, to do this it is necessary to install the usual page that takes care of killing the active sessions.

*** DISCLAIMER ***

“Obviously it is not recommended to use it! it has been tested in a sandbox but also works in a production environment.”

The “Active Sessions” Table

You can open Sessions and Active Sessions tables

https://businesscentral.dynamics.com/?table=2000000110

…but you can only see the list of All open sessions, nothing more as the table is read-only (a SQL view) in read only state by Design).

The “KILL ACTIVE SESSION” Page

With this simple sample Page (Kill Active Session), you can filter and delete the selected Session.

Install the extension

Download Link on GitHub

https://github.com/rstefanetti/AL-Samples/tree/AL-Kill-Sessions

“HOW-TO”

#1 – Search for “Active Session” page

#2 – Filter the needs session

#3 – Select the line and run “Delete Line”

#4 – The system show the Confirmation Message “Go ahead and delete ?”

.. and immediately…. The Session if Killed!

… and after some second… the user is disconnected from the browser because the session has been killed!

YOUR SESSIONS IS EXPIRED! ….

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.