Main Menu

  • Home
  • Tips and Tricks
    • Auditing
    • CMC
    • Designer
    • InfoView
    • Miscellaneous Tips and Tricks
    • Query Builder
    • Server
    • Tips and Tricks
    • Tools
    • Web Intelligence
  • Guides
    • Query Builder
    • Web Intelligence
  • Utilities
    • BI Content Assistant
    • CMSPro
    • QBXcell
  • Links
  • Blog

Tips Sub-menu

  • Auditing
  • CMC
  • Designer
  • General
  • InfoView
  • Miscellaneous
  • Query Builder
  • Server
  • Tools
  • Utilities
  • Web Intelligence

SI_LASTLOGONTIME Updates Every Other Time

Posted on April 19, 2012 by Julian 6 Comments

Sometimes people bring issues to me that exceed my knowledge and experience (or time to investigate). Business Objects is a complex tool now and there are always new nooks and crannies full of “features” that frustrate BO administrators and users. Alan Miles brought this latest one to my attention; I hope that we can collectively study this issue, try to replicate it, and comment on what is happening here.

Steps to Reproduce the Issue:

Using SELECT SI_LASTLOGONTIME FROM CI_SystemObjects WHERE SI_ID = xxxxx in Query Builder and refreshing it between a user’s logins.

The Issue

The value for SI_LASTLOGONTIME only updates every other time a user logs in (to InfoView or CMC), so first login no date change, next login the date changes, next login no change and so on.

The Question/Request

Is this generally the case with BO or am I seeing something peculiar to our setup? Thanks for any light you can shed on this. Please provide any inputs in the comments section and both Alan and Julian will do their best to respond to them.

Enjoyed this post? Share it!

 

Categories: Server

Tags: Login, Query Builder, User

6 thoughts on “SI_LASTLOGONTIME Updates Every Other Time”

  1. Dopple on April 20, 2012 at 2:51 am said:

    This doesn’t appear to happen on my installation.
    BOXIr2sp6

    Here’s my findings for a test user we have

    1st check – 18/04/12 10:19:18
    Login
    2nd check – 20/04/12 08:48:42
    Log out
    Login
    3rd check – 20/04/12 08:49:26
    Log out
    Login
    4th check – 20/04/12 08:49:59

  2. Alan Miles on April 24, 2012 at 9:53 am said:

    Thanks Doople.

    Looks like it is going to be peculiar to our site.

  3. Julian on April 24, 2012 at 7:49 pm said:

    Hi Alan, have you tried doing a full restart?

  4. Alan Miles on April 26, 2012 at 7:23 am said:

    Restart is not really feasible for out setup.

  5. Julian on April 26, 2012 at 9:00 am said:

    Hi Alan, I am not proposing a reboot of the server(s) hosting BO, but just a restart of the BO services (SIA in XI 3.1). You could even do this on a rolling basis (in a multi-server clustered environment).

  6. Bow on June 12, 2012 at 11:14 am said:

    I’ve also seen this behaviour on our XIr3.1 environment.

    I reported it to SAP as a bug and got the response that it’s a known issue. SAP thought it was caused when Timeouts or Closing of the Browser Window occurred, but I’ve been able to show that this is not the case. A correct logout does not always update SI_LASTLOGONTIME.

    In the end I went for a workaround such as the Max date of the last audit action captured for a user.

Leave a comment Cancel reply

Your email address will not be published. Required fields are marked *

« New Version of the Query Builder Guide is Released!
Learning Business Objects: Where to start? »
"The Best Query Builder Guide Ever Written"
Collage of pages from the Business Objects Query Builder Guide blank space
Query Builder Guide
Most comprehensive, best-selling Business Objects Query Builder guide. Take control of your BO metadata.
businessobjectstips.com

Recent Posts

  • Comparison of Web Intelligence Java Report Panel and HTML Editor
  • Why Does the Java Report Panel / Web Intelligence Applet Take So Long Load
  • Tracking Concurrent Users with Query Builder and Auditing Data
  • Import Wizard, Life Cycle Manager, UMT, & Promotion Management, Oh My…
  • Hot Backup & Restore of BusinessObjects XI3/BI4 Content

Recent Comments

  • Julian on OpenDocument – An Introduction to a Powerful Tool
  • Lorenzo on OpenDocument – An Introduction to a Powerful Tool
  • VL on Business Objects XI – Changing BO Report / Universe Relationships
  • shannkar on Querying the Busines Objects XI CMS InfoStore Database Tables
  • Tanushree on Which Business Objects Auditing Activities or Events Capture BO Universe Name?
  • Home
  • Tips and Tricks
  • Guides
  • Utilities
  • Links
  • Blog

Powered by WordPress and HeatMap AdAptive Theme