Session Purge

Additional Information
How to Purge Sessions

The Session Purge (md_session.purge) resource allows you to manually delete sessions based on a specified set of criteria.

Prior to the deletion process, the data is exported using the file out process. The views used to perform the file out are:

  • Session Purge Archive (md_session.purge.archive)
  • Session Application Purge Archive (md_session_app.purge.archive)
  • Session Application Cache Purge Archive (md_session_app.purge.archive)
  • Session Application Action Purge Archive (md_session_app_action.purge.archive)

After the file out process is complete, the user running the export can access the generated XML file using the My Attachments view.

The following table outlines the parameters associated with the purge resource:

Parameter Description
Instance Name The application server instance names associated with the sessions you wish to purge.
Terminated On The date and time at which the sessions you wish to purge were terminated.
Set by default to the current date and time less one year.
Termination Action The termination action. The following options are available:
0 - Not Terminated
1 - Requested by User - sessions terminated by the user using the Logout action.
2 - Requested by Administrator - indicates sessions terminated using the Terminate Session action.
3 - Oldest Session Terminated - indicates sessions terminated by the system, as the users exceeded the maximum number of sessions allowed.
4 - Expired Session Terminated - indicates sessions terminated by the system session cleanup as the session inactivity time exceeded the session timeout.
5 - Terminated by System - indicates sessions terminated by the system. These are sessions which were created by the system for background processes.

Set to a value of ">0" by default.
User Name The user names associated with the sessions you wish to purge.

How to Purge Sessions

Only users set up as system administrators can purge sessions.

  1. Launch Session Purge.

  2. Specify the selection criteria.

  3. Choose Delete to process your request.

  4. You can now validate that the procedure was successful by verifying the expected results, i.e. this resource may delete records in the following tables:

    • Sessions
    • Session Applications
    • Session Application Attributes
    • Session Application Cleanups
    • Session Attributes
    • Locks

  5. You can verify the processing exceptions using the Task Logs for the Task ID provided when the request was submitted.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.