terminate sessions via sql

SUGGESTED

Looking to see if there would be a way to let users terminate "their" hung sessions by showing them their open sessions where they could delete them - this would most likely be a front facing web app that would talk to the sage sql db and set a flag or delete a sessions table of the user- something like that.

thanks.

Parents Reply Children
  • 0 in reply to Jon Scarpa
    SUGGESTED

    Function PSADX (System Monitor) does exactly this. Are you looking for something else?

    All -> Development -> Utilities -> Verifications -> System Monitor

    Click an open process from the list, then in the box on the bottom, select the action button and click Process Termination. (Columns hidden for privacy)

    Very handy for stuck records.

  • 0 in reply to Zoey Mattison

    Note that it is per endpoint so make sure you are in correct endpoint.

    Also, try to get Super Administrator or ERPDEV-equivalent badge power since what you are doing is effectively messing with OS processes directly. Make sure you personally confirm with the client side is ok with it before removing the process lock.

    Personally prefer Locked symbols which summarized the locked records to bring me over to the Zoey method which I then can personally kill the adonix process and kick the user out of function.

    If you want to try reading it, it's first three characters = Table abbreviation, followed by the record code being locked.

    Alternatively, call the user to exit the function using the exit button (NOT CLOSING THE TAB) so the record lock will be released.