Graham,
You were correct that the SELECT registrationdata did not work.
The SELECT MAX returned
MAX(REGISTRATIONDATA_ID)
------------------------
So I performed the CREATE starting with 1 and received a "Sequence
Created" response.
I was following the upgrade instructions from
http://dspace.cvs.sourceforge.net/*checkout*/dspace/dspace/docs/update.h
tml?revision=1.10&pathrev=MAIN, and the real problem here is that I
cannot successfully execute @database_schema_13-14.sql. Are those
instructions correct, or do I need to execute other sql schema
modifications first? I'm sure we can fix this one procedure at a time,
but ...
After following your directions, the "forgot password" now works.
Trying to create a new user gets the following;
- URL Was: http://cassandra.usc.edu:8180/dspace/register
-- Method: POST
-- Parameters were:
-- password: "XXXxxxXXX"
-- submit: "Register"
-- netid: "bhelstien"
-- email: "[EMAIL PROTECTED]"
-- step: "1"
Exception:
java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:396)
at
org.dspace.app.webui.servlet.RegisterServlet.processEnterEmail(RegisterS
ervlet.java:332)
at
org.dspace.app.webui.servlet.RegisterServlet.doDSPost(RegisterServlet.ja
va:209)
at
org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.
java:147)
at
org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105
)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
at java.lang.Thread.run(Thread.java:595)
AND attempting to run the database_schema_13-14.sql produces
SQL> @database_schema_13-14.sql
CREATE SEQUENCE group2group_seq
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE SEQUENCE group2groupcache_seq
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE SEQUENCE tasklistitem_seq
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE Group2Group
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE Group2GroupCache
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE SEQUENCE metadataschemaregistry_seq
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE SEQUENCE metadatafieldregistry_seq
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE SEQUENCE metadatavalue_seq
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE MetadataSchemaRegistry
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE MetadataFieldRegistry
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE MetadataValue
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
INSERT INTO MetadataSchemaRegistry VALUES
(1,'http://dublincore.org/documents/dcmi-terms/','dc')
*
ERROR at line 1:
ORA-00001: unique constraint (DSPACET.SYS_C002784) violated
qualifier, scope_note FROM dctyperegistry
*
ERROR at line 4:
ORA-00942: table or view does not exist
SELECT item_id, dc_type_id, text_value, text_lang, place FROM dcvalue
*
ERROR at line 2:
ORA-00904: "DC_TYPE_ID": invalid identifier
DROP TABLE dcvalue
*
ERROR at line 1:
ORA-00942: table or view does not exist
CREATE VIEW dcvalue AS
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
SELECT setval('metadatafieldregistry_seq', max(metadata_field_id)) FROM
metadatafieldregistry
*
ERROR at line 1:
ORA-00904: "SETVAL": invalid identifier
SELECT setval('metadatavalue_seq', max(metadata_value_id)) FROM
metadatavalue
*
ERROR at line 1:
ORA-00904: "SETVAL": invalid identifier
SELECT setval('metadataschemaregistry_seq', max(metadata_schema_id))
FROM metadataschemaregistry
*
ERROR at line 1:
ORA-00904: "SETVAL": invalid identifier
DROP TABLE dctyperegistry
*
ERROR at line 1:
ORA-00942: table or view does not exist
CREATE INDEX metadatavalue_item_idx ON MetadataValue(item_id)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX metadatavalue_item_idx2 ON
MetadataValue(item_id,metadata_field_id)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX metadatafield_schema_idx ON
MetadataFieldRegistry(metadata_schema_id)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
result_code VARCHAR PRIMARY KEY,
*
ERROR at line 3:
ORA-00906: missing left parenthesis
result VARCHAR(64) REFERENCES checksum_results(result_code)
*
ERROR at line 11:
ORA-00942: table or view does not exist
CREATE SEQUENCE checksum_history_seq
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
result VARCHAR(64) REFERENCES checksum_results(result_code)
*
ERROR at line 9:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
date_trunc('milliseconds', now()),
*
ERROR at line 18:
ORA-00904: "DATE_TRUNC": invalid identifier
update most_recent_checksum
*
ERROR at line 1:
ORA-00942: table or view does not exist
most_recent_checksum.expected_checksum
*
ERROR at line 13:
ORA-00923: FROM keyword not found where expected
update checksum_history
*
ERROR at line 1:
ORA-00942: table or view does not exist
ALTER TABLE community DROP CONSTRAINT community_name_key
*
ERROR at line 1:
ORA-02443: Cannot drop constraint - nonexistent constraint
CREATE SEQUENCE itemsbysubject_seq
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE ItemsBySubject
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX sort_subject_idx on ItemsBySubject(sort_subject)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE VIEW CollectionItemsBySubject as
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE VIEW CommunityItemsBySubject as
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE TasklistItem
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
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
