[Building Sakai] Mneme upgrade oracle error

[Sloane, James]

Hi Glenn,

That fixed it, I also had to use
SET ID=MNEME_ASSESSMENT_DETAIL_SEQ.NEXTVAL
instead of
SET ID=MNEME_ASSESSMENT_DETAIL_SEQ.NEXT
on the next line.

Thanks,
James

From: Glenn R. Golden [mailto:ggolden at etudes.org]
Sent: Monday, 28 February 2011 3:47 PM
To: Sloane, James
Cc: Etudes
Subject: Re: [Building Sakai] Mneme upgrade oracle error

James -

Well, it may be that you should just remove the "PRIMARY KEY" part of line 28 of the file mneme_assessment_1_1-1_2.sql.  The alter table that follows on line 32 (once the records are filled in from the sequence) will restore that.  See if that works.

- Glenn

Glenn R. Golden
Chief Architect, Etudes, Inc.
ggolden at etudes.org<mailto:ggolden at etudes.org>




On Feb 27, 2011, at 11:29 PM, Sloane, James wrote:


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<mailto:jsloane at csu.edu.au>
www.csu.edu.au<http://www.csu.edu.au>

_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org<mailto: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<mailto: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/20110228/7cb794ed/attachment.html