The SAS 9.4 Web Administration Console displays very old user sessions. These sessions are not cleaned up in the PostgreSQL database. For example, if you log on to the Web Administration Console and select Users in the navigation pane, old user sessions (even a few months old) are displayed, as shown in the following example:

To clear the old sessions:

1. Stop all of your SAS^® 9.4 Web Application Server instances (for example, SASServer1_1, SASServer2_1, and so on). Ensure that all of the SASServer instances are stopped from within the server.log file.
2. Perform the following PostgresSQL steps:
1. Submit the following command from a Microsoft Windows prompt or a UNIX terminal prompt (that is, in the operating environment on which SAS 9.4 Web Infrastructure Platform Data Server is configured):
SAS_HOME\SASWebinfrastructurePlatformDataServer\9.4\bin\psql -U dbms-owner-ID -p 9432 SharedServices

Note: You need to supply the password for the DBMS owner ID when you are prompted.

2. At a SAS Shared Services command prompt, submit the following commands, in sequence:
create table sas_user_x_ticket_backup as select * from sas_user_x_ticket; delete from sas_user_x_ticket; select * from sas_user_x_ticket; \q
3. Start all SAS 9.4 Web Application Server instances (SASServer1_1, SASServer2_1, and so on).
4. Log on to the Web Administration Console and check the authenticated users again. You should see only current sessions from the last start–up.

Operating System and Release Information

A fix for this issue for SAS Middle Tier 9.4_M2 is available at:

A fix for this issue for SAS Management Console 9.4_M1 is available at:

A fix for this issue for SAS Middle Tier 9.4_M1 is available at: