My Oracle Support Banner

Siebel Remote : LAST_LOGIN_TS field not updated when used with Siebel Quickstart (Doc ID 512924.1)

Last updated on APRIL 03, 2023

Applies to:

Siebel Remote - Version 7.5.3.11 [16199] to 15.18 [IP2015] [Release V7 to V15]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3.11 [16199]
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.


Symptoms

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?

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 

When using Siebel Dedicated Client or Siebel Remote Thick Client and selecting 'Connect to: Server' and checks 'Enable Siebel QuickStart' on the Login Page, the user is able to login to the application successfully. When the user logout, the LAST_LOGIN_TS field on S_USER table is not updated accordingly.

The Bug 10500350 has been logged for this Product Defect.

References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.