Siebel Remote : LAST_LOGIN_TS field not updated when used with Siebel Quickstart
(Doc ID 512924.1)
Last updated on APRIL 26, 2021
Applies to:Siebel Remote - Version 184.108.40.206  and later
Siebel Anywhere - Version 220.127.116.11  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 18.104.22.168 
Database: Microsoft SQL Server 2000 SP3
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: Microsoft Windows 2000 Server SP 4
This document was previously published as Siebel SR 38-2298787991.
SBL-UIF-00401, SBL-DAT-00144, SBL‑DAT‑00170, SBL-EXL-00137, SBL-EXL-00145, SBL-DAT-00306, SBL-DAT-00315, SBL-DAT-00322, SBL-UIF-00161, SBL-UIF-00162
We track user usage by users' last login time in S_USER.LAST_LOGIN_TS. Most of them are correct except for some of them. The last login timestamp field will never be updated when they connect to Server by using remote client. I attched a log file here by set the SIEBEL_LOG_EVENTS env variable to 5. The log file does not have the UPDATE statement to update S_USER table for this user. But other users have this SQL statement. Would you please help to check the log file also, and is there any other reason that the LAST_LOGIN_TS will not be updated?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document