[Building Sakai] Mneme upgrade oracle error

[Sloane, James]

Hi All,

I'm looking at upgrading our mneme version (1.2m1) to 2.1.2 for our Sakai 2.4 instance.

When I run the 'mneme_assessment_1_1-1_2.sql' SQL update script for oracle I get an error when adding the new primary ID column to a table that is not empty. Has anyone come across this error?
I suppose I can add the column without specifying it as primary key, wait until the new fields are populated, then change it to primary?


The output of running the script is:

CREATE SEQUENCE succeeded.

Error starting at line 6 in command:
ALTER TABLE MNEME_ASSESSMENT_PART_DETAIL ADD (ID NUMBER PRIMARY KEY, SEQ NUMBER, POINTS FLOAT)
Error report:
SQL Error: ORA-01758: table must be empty to add mandatory (NOT NULL) column
01758. 00000 -  "table must be empty to add mandatory (NOT NULL) column"
*Cause:
*Action:

Error starting at line 9 in command:
UPDATE MNEME_ASSESSMENT_PART_DETAIL SET ID=MNEME_ASSESSMENT_DETAIL_SEQ.NEXT
Error at Command Line:9 Column:43
Error report:
SQL Error: ORA-00904: "MNEME_ASSESSMENT_DETAIL_SEQ"."NEXT": invalid identifier
00904. 00000 -  "%s: invalid identifier"
*Cause:
*Action:

Error starting at line 10 in command:
ALTER TABLE MNEME_ASSESSMENT_PART_DETAIL MODIFY (ID NUMBER NOT NULL PRIMARY KEY)
Error report:
SQL Error: ORA-00904: "ID": invalid identifier
00904. 00000 -  "%s: invalid identifier"
*Cause:
*Action:
 ALTER TABLE MNEME_ASSESSMENT succeeded.

Error starting at line 14 in command:
UPDATE MNEME_ASSESSMENT_PART_DETAIL SET SEQ=NUM_QUESTIONS_SEQ
Error at Command Line:14 Column:40
Error report:
SQL Error: ORA-00904: "SEQ": invalid identifier
00904. 00000 -  "%s: invalid identifier"
*Cause:
*Action:
CREATE INDEX succeeded.
CREATE INDEX succeeded.


------------------------------------------------------------------------
James Sloane
Solutions Programmer
Division of Information Technology
Charles Sturt University
Ph: 02 6051 9649
Email: jsloane at csu.edu.au
www.csu.edu.au

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110228/0be8a2ed/attachment.html