[Contrib: Evaluation System] SQL conversion scripts fail

Jim Eng jimeng at umich.edu
Fri Sep 30 06:01:55 PDT 2011


We tried the Oracle conversion scripts to upgrade table from evalsys 1.2.x to 1.4.x (i.e. trunk).  This involves running two scripts -- from 1.2 to 1.3 and from 1.3 to 1.4.  After the conversion, the evaluation tool fails with a nasty stack trace in the UI.  The immediate problem is that the SQL to create the EVAL_ADMIN table is not in either conversion script.  It's also not in the DDL files.  I have created a JIRA ticket for that (http://bugs.sakaiproject.org/jira/browse/EVALSYS-1142) and I will track this down and add the SQL for the EVAL_ADMIN table to the various DDL and conversion files.  

But this raises a question: Are there any other critical DDL statements missing from the SQL scripts?  

I am going to try to track down changes to HBM files in evalsys to see if any of them were not accompanied by changes to the SQL files.  But I'd like help.  If you know of any hibernate changes that were not also included in the SQL, please let me know.  

Thanks.

Jim 



More information about the evaluation mailing list