The new SAKAI_EVENT_DELAY table has a field named "RESOURCE", which is causing problems with Oracle, where RESOURCE is a reserved word (see http://tinyurl.com/c8lg2v).
There are two issues. First the table is not initially getting created by auto.ddl because of a syntax error in the creation script which needs to wrap the field name in double quotes. This was reported in
SAK-15805, and the fix is available in SAK-14939, and has been applied to trunk, but not yet 2-6-x. I'm attaching that patch here as well, as I have verified that it solves this part of the problem.
The second problem is that the hardcoded SQL in BaseEventDelayHanlder.java (http://tinyurl.com/can4ct) also doesn't treat the RESOURCE field name with double-quotes, and errors (ORA-00936: missing expression) occur when that SQL is run (eg, when a file is uploaded to Resources) because of the syntax confusion it causes.
|Conversion script needed for creation of SAKAI_EVENT_DELAY||CLOSED||Unassigned|