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

[Dunstall, Christopher]

Hi Steve,
 
>From what I could tell, there wasn't any real pattern to the events and the offset was random.  I don't have access to it from home, so I'll take another look tomorrow at work.
 
Most of the time, the dates are fine, but there is an alarming percentage that aren't.
 
Chris

________________________________

From: Stephen Swinsburg [mailto:s.swinsburg at lancaster.ac.uk]
Sent: Thu 19/03/2009 8:42 PM
To: Dunstall, Christopher
Cc: Sakai Dev
Subject: Re: [Building Sakai] Incorrect Sakai Event timestamps (SAK-11916)


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"