Hi,
We have been running Dspace with Postgresql for some years now. Our IT
department would like to move to Oracle. I've been trying to do a fresh-install
of Dspace 1.5.2 using an Oracle 10.2.2.0.2 database, on a SLES10 server. The
Oracle database is located on a separate database server. The fresh_install
reports several errors while initialising the database.
We get two ORA-01408 errors and 8 ORA-00942 errors. Loading of registries seems
to be fine, but when registering metadata we get messages about existing
metadata schema and several of the metadata types. Part of the output is shown
below. Despite the errors, ANT concludes with a BUILD SUCCESSFUL.
When I load the database_schema.sql directly in Oracle we get two ORA-01408
errors at both indexes of the Eperson table. And there are several problems
when creating the WorkflowItem and TasklistItem tables (five ORA-00942 errors
and 4 errors about unknown command). When checking the database, the EPERSON
table is created, but is missing the indexes, and the tables WorkflowItem and
TasklistItem are missing. These errors are also listed below.
Could somebody please assist me in finding what the problem is and how to solve
it? I have no experience with Oracle at all.
Thanking you in advance,
Francis Brouns
Open Universiteit Nederland
---------------------
Buildfile: build.xml
init_installation:
init_configs:
setup_database:
[java] 2009-09-17 17:18:06,695 INFO org.dspace.core.ConfigurationManager
@ Loading system provided config property (-Ddspace.configuration):
config/dspace.cfg
[java] 2009-09-17 17:18:06,735 INFO org.dspace.core.ConfigurationManager
@ Using default log4j provided log configuration,if uninitended, check your
dspace.cfg for (log.init.config)
[java] 2009-09-17 17:18:06,736 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
[java] 2009-09-17 17:18:07,461 WARN
org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception:
java.sql.SQLException: ORA-01408: such column list already indexed
.....
[java] 2009-09-17 17:18:12,312 INFO org.dspace.core.ConfigurationManager @
Loading system provided config property (-Ddspace.configuration):
config/dspace.cfg
[java] 2009-09-17 17:18:12,351 INFO org.dspace.core.ConfigurationManager
@ Using default log4j provided log configuration,if uninitended, check your
dspace.cfg for (log.init.config)
[java] 2009-09-17 17:18:13,098 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
...
[java] 2009-09-17 17:18:18,691 INFO org.dspace.core.ConfigurationManager
@ Using default log4j provided log configuration,if uninitended, check your
dspace.cfg for (log.init.config)
[java] Registering Schema: dc -
http://dublincore.org/documents/dcmi-terms/ ... 2009-09-17 17:18:19,301 INFO
org.dspace.content.MetadataSchema @ Loading schema cache for fast finds
[java] already exists, skipping to type import
...
[java] 2009-09-17 17:18:22,519 INFO org.dspace.core.ConfigurationManager
@ Loading system provided config property (-Ddspace.configuration):
config/dspace.cfg
[java] 2009-09-17 17:18:22,565 INFO org.dspace.core.ConfigurationManager
@ Using default log4j provided log configuration,if uninitended, check your
dspace.cfg for (log.init.config)
[java] Registering Metadata: dc.contributor.author ... 2009-09-17
17:18:23,178 INFO org.dspace.content.MetadataSchema @ Loading schema cache for
fast finds
[java] already exists, skipping
[java] Registering Metadata: dc.date.issued ... already exists, skipping
[java] Registering Metadata: dc.date.updated ... 2009-09-17 17:18:23,363
INFO org.dspace.content.MetadataField @
anonymous::create_metadata_field:metadata_field_id=67
[java] created
[java] Registering Metadata: dc.description.abstract ... already exists,
skipping
[java] Registering Metadata: dc.description.version ... 2009-09-17
17:18:23,401 INFO org.dspace.content.MetadataField @
anonymous::create_metadata_field:metadata_field_id=68
[java] created
[java] Registering Metadata: dc.identifier.uri ... already exists, skipping
[java] Registering Metadata: dc.identifier.slug ... 2009-09-17
17:18:23,421 INFO org.dspace.content.MetadataField @
anonymous::create_metadata_field:metadata_field_id=69
[java] created
[java] Registering Metadata: dc.language.rfc3066 ... 2009-09-17
17:18:23,446 INFO org.dspace.content.MetadataField @
anonymous::create_metadata_field:metadata_field_id=70
[java] created
[java] Registering Metadata: dc.rights.holder ... 2009-09-17 17:18:23,459
INFO org.dspace.content.MetadataField @
anonymous::create_metadata_field:metadata_field_id=71
[java] created
[java] Registering Metadata: dc.title.null ... already exists, skipping
[java] Registering Metadata: dc.type.null ... already exists, skipping
-----------------------------
Errors directly from Oracle:
Table created.
CREATE INDEX eperson_email_idx ON EPerson(email)
*
ERROR at line 1:
ORA-01408: such column list already indexed
CREATE INDEX eperson_netid_idx ON EPerson(netid)
*
ERROR at line 1:
ORA-01408: such column list already indexed
....
SP2-0734: unknown command beginning "multiple_t..." - rest of line ignored.
SP2-0734: unknown command beginning "published_..." - rest of line ignored.
SP2-0734: unknown command beginning "multiple_f..." - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
CREATE INDEX workflow_coll_fk_idx ON WorkflowItem(collection_id)
*
ERROR at line 1:
ORA-00942: table or view does not exist
CREATE INDEX workflow_owner_fk_idx ON WorkflowItem(owner)
*
ERROR at line 1:
ORA-00942: table or view does not exist
workflow_id INTEGER REFERENCES WorkflowItem(workflow_id)
*
ERROR at line 5:
ORA-00942: table or view does not exist
CREATE INDEX tasklist_eperson_fk_idx ON TasklistItem(eperson_id)
*
ERROR at line 1:
ORA-00942: table or view does not exist
CREATE INDEX tasklist_workflow_fk_idx ON TasklistItem(workflow_id)
*
ERROR at line 1:
ORA-00942: table or view does not exist
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
