Problem Note 54238: The SAS® 9.4 Web Administration Console displays old user sessions
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:
- 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.
- Perform the following PostgresSQL steps:
- 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.
- 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
- Start all SAS 9.4 Web Application Server instances (SASServer1_1, SASServer2_1, and so on).
- 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
SAS System | SAS Enterprise BI Server | Microsoft® Windows® for x64 | 9.4 | 9.4 | 9.4 TS1M2 | 9.4 TS1M3 |
64-bit Enabled AIX | 9.4 | 9.4 | 9.4 TS1M2 | 9.4 TS1M3 |
64-bit Enabled Solaris | 9.4 | 9.4 | 9.4 TS1M2 | 9.4 TS1M3 |
Linux for x64 | 9.4 | 9.4 | 9.4 TS1M2 | 9.4 TS1M3 |
Solaris for x64 | 9.4 | 9.4 | 9.4 TS1M2 | 9.4 TS1M3 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2014-10-07 14:47:57 |
Date Created: | 2014-09-30 14:46:10 |