Dear Marvin, When I tried do a fresh-install of Dspace 1.5.2 on Oracle, I discovered that their are differences between the SQL schema scripts for creating a new database and when you would upgrade a database. See my posts about this topic earlier this year. It looks like either the registry tables are not correctly made or that the index is not being made. Oracle is rather sensitive the format of the schema file (such as whitelines and comments within the table or script creation), which Postgres does not react upon. We had to manually adjust the database schema file. I have no experience yet with Dspace 1.6.
Did you check the Oracle database against the database schema file? Does Oracle report any errors. The Oracle error message point out that you are trying to insert data into tables or columns that have not been created. Another possibility is that your Oracle jdbc driver is not compatible with your Oracle version and the java version you are running. We had to use a lower version of the jdbc driver to get through the install without errors. Best wishes, Francis Brouns -----Original Message----- From: Marvin Weaver [mailto:[email protected]] Sent: Thursday, September 30, 2010 6:36 PM To: [email protected] Subject: Re: [Dspace-tech] Oracle users - 64bit or 32bit? freshly built database?, (Claudia J?rgen) I commented out load_registries from the build.xml and ant builds. The logs in /dspace/log/ were owned by root, and rw only for root. I chmod to 777 on all. Then ran build, followed by your suggestion to run the registry loader via dsrun. It looks like the same error. Changes to build.xml: <!-- ============================================================= --> <!-- Do a fresh system install --> <!-- ============================================================= --> <!-- <target name="fresh_install" depends="init_installation,init_configs,test_database,setup_database,load_registries" description="Do a fresh install of the system, overwriting any data"> --> <target name="fresh_install" depends="init_installation,init_configs,test_database,setup_database" description="Do a fresh install of the system, overwriting any data"> Results and logs: -bash-3.00$ ant fresh_install Buildfile: /dspacehome/dspace-1.6.2-src-release/dspace/target/dspace-1.6.2-build.dir/build.xml init_installation: init_configs: test_database: [java] 2010-09-30 12:10:45,454 INFO org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg [java] 2010-09-30 12:10:45,522 INFO org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if uninitended, check your dspace.cfg for (log.init.config) [java] [java] Attempting to connect to database: [java] - URL: jdbc:oracle:thin:@//dumbbell:1521/dspace [java] - Driver: oracle.jdbc.OracleDriver [java] - Username: dspace [java] - Password: dspace2009 [java] - Schema: dspace [java] [java] Testing connection... [java] Connected succesfully! [java] setup_database: [java] 2010-09-30 12:10:47,849 INFO org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg [java] 2010-09-30 12:10:47,890 INFO org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if uninitended, check your dspace.cfg for (log.init.config) [java] 2010-09-30 12:10:47,890 INFO org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database [java] 2010-09-30 12:10:49,603 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: java.sql.SQLException: ORA-01408: such column list already indexed [java] [java] java.sql.SQLException: ORA-01408: such column list already indexed [java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) [java] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) [java] at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687) [java] at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:1067) [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100) [java] 2010-09-30 12:10:49,611 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: java.sql.SQLException: ORA-01408: such column list already indexed [java] [java] java.sql.SQLException: ORA-01408: such column list already indexed [java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) [java] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) [java] at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687) [java] at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:1067) [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100) [java] 2010-09-30 12:10:56,112 INFO org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg [java] 2010-09-30 12:10:56,152 INFO org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if uninitended, check your dspace.cfg for (log.init.config) [java] 2010-09-30 12:10:57,932 ERROR org.dspace.browse.BrowseCreateDAOOracle @ caught exception: [java] java.sql.SQLException: ORA-00942: table or view does not exist [java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460) [java] at org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491) [java] at org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:897) [java] at org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779) [java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742) [java] 2010-09-30 12:10:57,945 ERROR org.dspace.browse.BrowseCreateDAOOracle @ caught exception: [java] java.sql.SQLException: ORA-00942: table or view does not exist [java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460) [java] at org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491) [java] at org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:898) [java] at org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779) [java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742) [java] 2010-09-30 12:10:58,580 ERROR org.dspace.browse.BrowseCreateDAOOracle @ caught exception: [java] java.sql.SQLException: ORA-00942: table or view does not exist [java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460) [java] at org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491) [java] at org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:897) [java] at org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779) [java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742) [java] 2010-09-30 12:10:58,588 ERROR org.dspace.browse.BrowseCreateDAOOracle @ caught exception: [java] java.sql.SQLException: ORA-00942: table or view does not exist [java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460) [java] at org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491) [java] at org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:898) [java] at org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779) [java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742) [java] 2010-09-30 12:10:59,040 ERROR org.dspace.browse.BrowseCreateDAOOracle @ caught exception: [java] java.sql.SQLException: ORA-00942: table or view does not exist [java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460) [java] at org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491) [java] at org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:941) [java] at org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:906) [java] at org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779) [java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742) [java] 2010-09-30 12:10:59,048 ERROR org.dspace.browse.BrowseCreateDAOOracle @ caught exception: [java] java.sql.SQLException: ORA-00942: table or view does not exist [java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460) [java] at org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491) [java] at org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:942) [java] at org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:906) [java] at org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779) [java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742) [java] 2010-09-30 12:10:59,399 ERROR org.dspace.browse.BrowseCreateDAOOracle @ caught exception: [java] java.sql.SQLException: ORA-00942: table or view does not exist [java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460) [java] at org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491) [java] at org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:941) [java] at org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:907) [java] at org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779) [java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742) [java] 2010-09-30 12:10:59,408 ERROR org.dspace.browse.BrowseCreateDAOOracle @ caught exception: [java] java.sql.SQLException: ORA-00942: table or view does not exist [java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) [java] at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460) [java] at org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491) [java] at org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:942) [java] at org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:907) [java] at org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779) [java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742) fresh_install: [copy] Copying 33 files to /dspace/bin [copy] Copying 67 files to /dspace/lib [copy] Copying 19 files to /dspace/etc copy_webapps: [copy] Copying 801 files to /dspace/webapps [copy] Copying 6 files to /dspace/webapps build_webapps_wars: check_geolite: init_geolite: [java] 2010-09-30 12:11:33,530 INFO org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg [java] 2010-09-30 12:11:33,576 INFO org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if uninitended, check your dspace.cfg for (log.init.config) [java] 2010-09-30 12:11:36,906 INFO org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg [java] 2010-09-30 12:11:36,945 INFO org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if uninitended, check your dspace.cfg for (log.init.config) [java] 2010-09-30 12:11:38,003 INFO org.dspace.search.DSIndexer @ Updating and Cleaning Index [java] 2010-09-30 12:11:39,160 INFO org.dspace.search.DSIndexer @ Done with indexing [echo] [echo] ==================================================================== [echo] The DSpace code has been installed, and the database initialized. [echo] [echo] To complete installation, you should do the following: [echo] [echo] * Setup your Web servlet container (e.g. Tomcat) to look for your [echo] DSpace web applications in: /dspace/webapps/ [echo] [echo] OR, copy any web applications from /dspace/webapps/ to [echo] the appropriate place for your servlet container. [echo] (e.g. '$CATALINA_HOME/webapps' for Tomcat) [echo] [echo] * Make an initial administrator account (an e-person) in DSpace: [echo] [echo] /dspace/bin/dspace create-administrator [echo] [echo] * Start up your servlet container (Tomcat etc.) [echo] [echo] You should then be able to access your DSpace's 'home page': [echo] [echo]http://dumbell.sju.edu:8080/xmlui [echo] [echo] You should also be able to access the administrator UI: [echo] [echo]http://dumbell.sju.edu:8080/xmlui/dspace-admin [echo] ==================================================================== [echo] BUILD SUCCESSFUL Total time: 58 seconds -bash-3.00$ -bash-3.00$ cd /dspace -bash-3.00$ /dspace/bin/dsrun org.dspace.administer.RegistryLoader -bitstream /dspace/config/registries/bitstream-formats.xml Error: - null -bash-3.00$ -bash-3.00$ cat cocoon.log.2010-09-30 2010-09-30 12:11:47,825 INFO org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization started 2010-09-30 12:11:47,840 INFO org.springframework.web.context.support.XmlWebApplicationContext - Refreshing org.springframework.web.context.support.xmlwebapplicationcont...@15fcb67: display name [Root WebApplicationContext]; startup date [Thu Sep 30 12:11:47 EDT 2010]; root of context hierarchy 2010-09-30 12:11:47,845 INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from ServletContext resource [/WEB-INF/spring/applicationContext.xml] 2010-09-30 12:11:48,028 INFO org.springframework.web.context.support.XmlWebApplicationContext - Bean factory for application context [org.springframework.web.context.support.xmlwebapplicationcont...@15fcb67]: org.springframework.beans.factory.support.defaultlistablebeanfact...@1bb1849 2010-09-30 12:11:48,065 INFO org.springframework.beans.factory.support.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.defaultlistablebeanfact...@1bb1849: defining beans [dspace,dspace.eventService,org.dspace.usage.LoggerUsageEventListener#0,org.dspace.statistics.SolrLoggerUsageEventListener#0]; root of factory hierarchy 2010-09-30 12:11:48,102 INFO org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 274 ms 2010-09-30 12:14:19,141 INFO org.springframework.context.support.ClassPathXmlApplicationContext - Refreshing org.springframework.context.support.classpathxmlapplicationcont...@6295eb: display name [org.springframework.context.support.classpathxmlapplicationcont...@6295eb]; startup date [Thu Sep 30 12:14:19 EDT 2010]; root of context hierarchy 2010-09-30 12:14:19,320 INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [spring/spring-dspace-applicationContext.xml] 2010-09-30 12:14:20,622 INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/dspace/lib/dspace-services-impl-2.0.1.jar!/spring/spring-dspace-core-services.xml] 2010-09-30 12:14:20,752 INFO org.springframework.context.support.ClassPathXmlApplicationContext - Bean factory for application context [org.springframework.context.support.classpathxmlapplicationcont...@6295eb]: org.springframework.beans.factory.support.defaultlistablebeanfact...@11a01dd 2010-09-30 12:14:21,082 INFO org.springframework.beans.factory.support.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.defaultlistablebeanfact...@11a01dd: defining beans [org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.dspace.servicemanager.spring.DSpaceBeanPostProcessor#0,org.dspace.services.CachingService,org.dspace.caching.ehcache.CacheManager,org.dspace.services.SessionService,org.dspace.services.EventService]; root of factory hierarchy 2010-09-30 12:14:21,196 INFO org.springframework.cache.ehcache.EhCacheManagerFactoryBean - Initializing EHCache CacheManager 2010-09-30 12:14:21,561 INFO org.springframework.beans.factory.support.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.defaultlistablebeanfact...@11a01dd: defining beans [org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.dspace.servicemanager.spring.DSpaceBeanPostProcessor#0,org.dspace.services.CachingService,org.dspace.caching.ehcache.CacheManager,org.dspace.services.SessionService,org.dspace.services.EventService]; root of factory hierarchy 2010-09-30 12:14:23,412 INFO org.springframework.context.support.ClassPathXmlApplicationContext - Closing org.springframework.context.support.classpathxmlapplicationcont...@6295eb: display name [org.springframework.context.support.classpathxmlapplicationcont...@6295eb]; startup date [Thu Sep 30 12:14:19 EDT 2010]; root of context hierarchy 2010-09-30 12:14:23,413 INFO org.springframework.beans.factory.support.DefaultListableBeanFactory - Destroying singletons in org.springframework.beans.factory.support.defaultlistablebeanfact...@11a01dd: defining beans [org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.dspace.servicemanager.spring.DSpaceBeanPostProcessor#0,org.dspace.services.CachingService,org.dspace.caching.ehcache.CacheManager,org.dspace.services.SessionService,org.dspace.services.EventService]; root of factory hierarchy 2010-09-30 12:14:23,417 INFO org.springframework.cache.ehcache.EhCacheManagerFactoryBean - Shutting down EHCache CacheManager -bash-3.00$ -bash-3.00$ cat dspace.log.2010-09-30 2010-09-30 12:11:47,811 INFO org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/jspui] @ Initializing Spring root WebApplicationContext 2010-09-30 12:14:18,493 INFO org.dspace.core.ConfigurationManager @ Loading from classloader: file:/dspace/config/dspace.cfg 2010-09-30 12:14:18,526 INFO org.dspace.core.ConfigurationManager @ Using dspace provided log configuration (log.init.config) 2010-09-30 12:14:18,527 INFO org.dspace.core.ConfigurationManager @ Loading: /dspace/config/log4j.properties 2010-09-30 12:14:23,406 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries: java.lang.NullPointerException at org.dspace.storage.rdbms.TableRow.canonicalize(TableRow.java:674) at org.dspace.storage.rdbms.TableRow.hasColumn(TableRow.java:110) at org.dspace.storage.rdbms.TableRow.setColumn(TableRow.java:507) at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:713) at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:490) at org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:419) at org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:202) at org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:168) at org.dspace.administer.RegistryLoader.main(RegistryLoader.java:105) atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:212) -bash-3.00$ The only tables with data on them are CHECKSUM_RESULTS, EPERSONGROUP, METADATASCHEMAREGISTRY ############################################################ Hello Marvin, did you try to load the registry after the fresh installation? You can do this by executing: [dspace]/bin/dsrun org.dspace.administer.RegistryLoader -bitstream [dspace]/config/registries/bitstream-formats.xml where [dspace] is your installation directory. Hope that helps Claudia J?rgen ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
