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

[Sam Ottenhoff]

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> 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
> 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/20130311/f96e45b6/attachment.html