[Building Sakai] Issue with Oracle Timestamp with TimeZone and DST

[Omer A Piperdi]

Yes. We have old 2.9.x code.. Thanks for the pointer, we will need to 
roll back..

Omer
On 3/11/2013 3:40 PM, Sam Ottenhoff wrote:
> Omer, can you be more specific about the 2.9.x you are using?  Are you 
> using pre-2.9.0 code?
>
> Changes to the conversion scripts were made in October 2012:
>
> https://jira.sakaiproject.org/browse/KNL-985
>
> That commit rolled back code commited here:
>
> https://jira.sakaiproject.org/browse/KNL-725
>
>
> On Mon, Mar 11, 2013 at 4:28 PM, Omer A Piperdi <omer at rice.edu 
> <mailto:omer at rice.edu>> wrote:
>
>     All our Sakai instances stopped working for an hour last Saturday
>     night.
>     During 2.9 upgrade last August, we converted data type "TimeStamp" in
>     session, event and cluster tables to "Timestamp with TimeZone" data
>     type. I think this was also apart of 2.9 db upgrade script as well..
>
>     We were getting "java.sql.SQLDataException: ORA-01878: specified field
>     not found in datetime or interval" error. It started working by itself
>     after an hour.
>
>     I am not sure what will be the fix for this.. Did anyone see this
>     behavior?? We are 2.9.x with Oracle 11g.
>
>     Thanks
>     Omer
>     _______________________________________________
>     sakai-dev mailing list
>     sakai-dev at collab.sakaiproject.org
>     <mailto: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
>     <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>     subject of "unsubscribe"
>
>
> !DSPAM:2294,513e4297270154578216259! 

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