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

[Stephen Swinsburg]

Hi Chris,

what is your DB server reporting as the current time/date (select  
sysdate from dual). I remember having an issue a while back regarding  
dates and I had to do some forcing with LOCAL_TIMEZONE. I haven't got  
my Oracle instance here to check. What events are specifically the  
cause or is it all of them and is the date offset always the time for  
you (and was it always the same offset for the other people you  
mentioned?).


cheers,
Steve

---
Steve Swinsburg
Portal Systems Developer
Centre for e-Science
Lancaster University
Lancaster
LA1 4YT

email: s.swinsburg at lancaster.ac.uk
phone: +44 (0) 1524 594870

On 19/03/2009, at 6:33 AM, Chris Dunstall wrote:

> Hi All,
>
> The Statistics module I wrote for Sakai at CSU has been having a  
> little grief lately due to some of the dates in the Sakai Event and  
> Session table being in the future.  From what I can tell, it’s the  
> same thing reported in SAK-11916.
>
> 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?  I’d  
> really like to get this sorted as the stats I collect depend on the  
> dates and if they aren’t correct then the stats are useless...
>
> Thanks,
>
> Chris Dunstall | Solutions Developer
> Enterprise Information Management Solutions (EIMS)
> Division of Information Technology | Charles Sturt University |  
> Bathurst, NSW
>
> Ph: 02 63384818 | Fax: 02 63384181
>
>
> _______________________________________________
> 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"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090319/aa522ea0/attachment.html