Graham,
I should have added to my previous message, this is a test server,
and if need be, I can lose all the data without a problem. My fear of
course, is that I will encounter the identical issue when I attempt to
upgrade the production instance because there, I cannot lose any of the
data. Thus what I need to understand is what isn't/wasn't
working/correct in the upgrade instruction and, can whatever it is/was
be avoided?
Brian A. Helstien, SISD, MLS,
Director, Special Technologies Initiatives,
IDM, University Libraries
x06913
University of Southern California, (213) 740-6913
Los Angeles, California, 90089 [EMAIL PROTECTED]
Information is independent of media or format
-----Original Message-----
From: Graham Triggs [mailto:[EMAIL PROTECTED]
Sent: Friday, June 15, 2007 2:13 AM
To: Brian Helstien
Cc: [email protected]
Subject: Re: [Dspace-tech] 1.4.2 Oracle Upgrade Problem
It look's like it can't find the registrationdata_seq.
Try running:
SELECT registrationdata_seq.nextval FROM dual;
it probably won't work, in which case you will need to create the
sequence. First, run:
SELECT MAX(registrationdata_id) FROM registrationdata;
to see if there are any IDs already in the table - if there are, you
need to create the sequence starting with a higher number (at least 1
larger than the number returned). Then run:
CREATE SEQUENCE registrationdata_seq START WITH 1;
although change that 1 to a higher number if the previous command showed
that it was necessary.
G
On Thu, 2007-06-14 at 12:35 -0700, Brian Helstien wrote:
> Wednesday, I noted that following the directions to modify the Oracle
> database schema didn't succeed. In trying to actually run the
> application, I am getting Oracle database errors, such as the
> following from the DEBUG dspace.log. The Oracle database is on a
> different server than Dspace (if that makes any difference) and my
> question is, and how exactly should I go about correctly modifying the
> schema to support 1.4.2? Help, please?
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
