Discussion:
[Building Sakai] Issue with Oracle Timestamp with TimeZone and DST
(too old to reply)
Omer A Piperdi
2013-03-11 20:28:03 UTC
Permalink
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-***@collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev

TO UNSUBSCRIBE: send email to sakai-dev-***@collab.sakaiproject.org with a subject of "unsubscribe"
Sam Ottenhoff
2013-03-11 20:40:39 UTC
Permalink
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
Post by Omer A Piperdi
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
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
TO UNSUBSCRIBE: send email to
"unsubscribe"
Omer A Piperdi
2013-03-11 20:56:12 UTC
Permalink
Yes. We have old 2.9.x code.. Thanks for the pointer, we will need to
roll back..

Omer
Post by Sam Ottenhoff
Omer, can you be more specific about the 2.9.x you are using? Are you
using pre-2.9.0 code?
https://jira.sakaiproject.org/browse/KNL-985
https://jira.sakaiproject.org/browse/KNL-725
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
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
TO UNSUBSCRIBE: send email to
subject of "unsubscribe"
!DSPAM:2294,513e4297270154578216259!
Loading...