[Building Sakai] Incorrect Sakai Event timestamps (SAK-11916)

[Dunstall, Christopher]

Ours are the same sort of mix, just a greater number - Our Event table is over 50 million rows.
 
Going off the Sakai source code for events, times are inserted in GMT (or UTC) via a Gregorian Calendar.
 
Unfortunately there's no real way of knowing exactly how many records are incorrect as you don't know how many were 'in the future' when they were created in the past. 
 
Oracle's forums are down at the moment, so I can't investigate there...
 
Chris

________________________________

From: sakai-dev-bounces at collab.sakaiproject.org on behalf of Adams, David
Sent: Thu 19/03/2009 10:33 PM
To: Sakai Dev
Subject: Re: [Building Sakai] Incorrect Sakai Event timestamps (SAK-11916)



Chris Dunstall wrote:
> A long story short, it looks like that with Oracle, the Event system is
> inserting an incorrect timestamp for the event.  We are seeing dates a
> long way into the future (as far as 12 months) and others have reported
> dates in the past (as they archive their event table - we don't).
>
> Ian Boston couldn't reproduce the error, but I was wondering if *anyone*
> has seen or worked out a solution or work around?

We're running Oracle (10.2.0.4.0) and taking a look at our sakai_event table, we have some similar artifacts, but a very small number--12 future events out of 7,440,965 (since February 2008). Dates between 2009-06-21 and 2009-12-31. Nine are user.upd.any; two are pres.begin; and one is content.read.

I don't have any suggestions, but I did want to confirm the problem. Per Steve's question, my Oracle reports sysdate in local time, but Sakai events (at least some of them) appear to be in UTC.

David Adams
Director of Learning Systems Integration and Support
Virginia Tech Learning Technologies

_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev

TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"