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

[DAVID ROLDAN MARTINEZ]

             Hi all,

             We also suffer this issue running in our Oracle database. Any suggestion will be welcome. 

             Please see http://bugs.sakaiproject.org/jira/browse/SAK-11916
 
             David
________________________________________
De: sakai-dev-bounces at collab.sakaiproject.org [sakai-dev-bounces at collab.sakaiproject.org] En nombre de Adams, David [da1 at vt.edu]
Enviado el: jueves, 19 de marzo de 2009 12:33
Para: Sakai Dev
Asunto: 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"