Skip Navigation

Stale sessions

There are three ways that the desktop app session becomes stale:
  1. A CU has not been performed for an interval of 1.5 times the CU interval plus 30 seconds.
    The formula for determining whether or not a session is stale is:
    LKA + 1.5xCU + 30 < Now
    where LKA is the value in the LAST_KEEP_ALIVE column in the session table.
    Values are in seconds.
  2. When the desktop app logon time is less than the current time minus SSN_FORCE_CLEANUP_INTERVAL in the ngaddata.prv_provider_tab. The default is 86400 seconds.
  3.  When the desktop app is inactive for longer than the value in "Override Default Communication Session Expiration Time After" option in 
    Settings
     > 
    Desktop App
    , when the value is not zero.
The above formulas are used in the CLEANUP_USER_SESSIONS stored procedure.