Hi, Marvin, here are my notes for when I cleared out our old development site based on 1.5.1, in preparation for testing an upgrade of our live site to 1.6.2. I'm no DBA, but this procedure worked for me.
I used Oracle's free SQL Developer tool, which is really handy for this kind of thing, and is cross-platform. First, this thread provided the inspiration: http://www.dbapool.com/forumthread/topic_14101.html But after some experimentation, I discovered that I don't have access to the "DBA" prefixed tables. But I do have access to "USER" prefixed tables. So, here are my revisions to the suggested code: -- DISABLE CONSTRAINTS -- results in a list of SQL statements, which you can copy/paste into a -- new SQL script and run (disabling constraints required in order to truncate -- certain tables select 'Alter Table'||' '||table_name||' '||'Disable Constraint'||' '||constraint_name||';' from user_constraints ORDER BY TABLE_NAME; Run that, copy the results, paste, run the results. Same drill for the next two: -- ENABLE CONSTRAINTS -- results in a list of SQL statements, which you can copy/paste into a -- new SQL script and run (enabling constraints) select 'Alter Table'||' '||table_name||' '||'Enable Constraint'||' '||index_name||';' from user_indexes ORDER BY TABLE_NAME; -- TRUNCATE TABLES -- results in a list of SQL statements, which you can copy/paste into a -- new SQL script and run (truncating all tables) select 'truncate'||' '||'table'||' '||table_name|| ';' from user_tables; You'll likely have to run this multiple times (disable constraints, truncate and drop tables, disable more constraints, truncate and drop tables, etc.) until all tables are gone. Finally, you'll need to drop all your sequences: select 'drop'||' '||'sequence'||' '||sequence_name|| ';' from user_sequences; It's not pretty, I bet it could be improved, but this will definitely zero out your database. Hope that helps. --Hardy > -----Original Message----- > From: Marvin Weaver [mailto:[email protected]] > Sent: Tuesday, August 31, 2010 12:24 PM > To: [email protected] > Subject: [Dspace-tech] Dspace 1.6.2 src Solaris 10, Oracle10, ant fails. > > I have cleared the oracle database of everything I know of. > No tables in tabs, No user_constraints, No views, No sequences, No > user_objects, purged recyclebin. I did this by modifying the > clean_database.sql that came with 1.5.2, adding elements that were not > in it. I changed all the DROP TABLE statements to be DROP TABLE > tablename CASCADE CONSTRAINTS PURGE; and added a PURGE RECYCLEBIN; at > the end. I checked them all with appropriate queries. > Oracle 10.2.0.3, Solaris 10, ojdbc14 10.2.0.2, and ant 1.8.1 > So now ant fresh_install fails with: > > -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-08-31 12:41:21,199 INFO > org.dspace.core.ConfigurationManager @ Loading system provided config > property (-Ddspace.configuration): config/dspace.cfg > [java] 2010-08-31 12:41:21,238 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-08-31 12:41:23,281 INFO > org.dspace.core.ConfigurationManager @ Loading system provided config > property (-Ddspace.configuration): config/dspace.cfg > [java] 2010-08-31 12:41:23,323 INFO > org.dspace.core.ConfigurationManager @ Using default log4j provided > log configuration,if uninitended, check your dspace.cfg for > (log.init.config) > [java] 2010-08-31 12:41:23,323 INFO > org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database > [java] 2010-08-31 12:41:24,933 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:11 > 2) > [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:10 > 67) > [java] at > org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java > :100) > [java] 2010-08-31 12:41:24,942 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:11 > 2) > [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:10 > 67) > [java] at > org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java > :100) > [java] 2010-08-31 12:41:30,946 INFO > org.dspace.core.ConfigurationManager @ Loading system provided config > property (-Ddspace.configuration): config/dspace.cfg > [java] 2010-08-31 12:41:30,998 INFO > org.dspace.core.ConfigurationManager @ Using default log4j provided > log configuration,if uninitended, check your dspace.cfg for > (log.init.config) > [java] 2010-08-31 12:41:33,249 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:11 > 2) > [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.jav > a:216) > [java] at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem > ent.java:955) > [java] at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. > java:1168) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare > dStatement.java:3316) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS > tatement.java:3400) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav > a:460) > [java] at > org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j > ava: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-08-31 12:41:33,263 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:11 > 2) > [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.jav > a:216) > [java] at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem > ent.java:955) > [java] at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. > java:1168) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare > dStatement.java:3316) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS > tatement.java:3400) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav > a:460) > [java] at > org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j > ava: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-08-31 12:41:35,512 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:11 > 2) > [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.jav > a:216) > [java] at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem > ent.java:955) > [java] at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. > java:1168) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare > dStatement.java:3316) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS > tatement.java:3400) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav > a:460) > [java] at > org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j > ava: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-08-31 12:41:35,520 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:11 > 2) > [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.jav > a:216) > [java] at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem > ent.java:955) > [java] at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. > java:1168) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare > dStatement.java:3316) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS > tatement.java:3400) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav > a:460) > [java] at > org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j > ava: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-08-31 12:41:36,160 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:11 > 2) > [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.jav > a:216) > [java] at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem > ent.java:955) > [java] at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. > java:1168) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare > dStatement.java:3316) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS > tatement.java:3400) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav > a:460) > [java] at > org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j > ava: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-08-31 12:41:36,168 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:11 > 2) > [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.jav > a:216) > [java] at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem > ent.java:955) > [java] at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. > java:1168) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare > dStatement.java:3316) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS > tatement.java:3400) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav > a:460) > [java] at > org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j > ava: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-08-31 12:41:36,522 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:11 > 2) > [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.jav > a:216) > [java] at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem > ent.java:955) > [java] at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. > java:1168) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare > dStatement.java:3316) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS > tatement.java:3400) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav > a:460) > [java] at > org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j > ava: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-08-31 12:41:36,531 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:11 > 2) > [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.jav > a:216) > [java] at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem > ent.java:955) > [java] at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. > java:1168) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare > dStatement.java:3316) > [java] at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS > tatement.java:3400) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega > tingPreparedStatement.java:102) > [java] at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.jav > a:460) > [java] at > org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.j > ava: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) > > load_registries: > [java] 2010-08-31 12:41:40,025 INFO > org.dspace.core.ConfigurationManager @ Loading system provided config > property (-Ddspace.configuration): config/dspace.cfg > [java] 2010-08-31 12:41:40,093 INFO > org.dspace.core.ConfigurationManager @ Using default log4j provided > log configuration,if uninitended, check your dspace.cfg for > (log.init.config) > [java] Error: > [java] - null > [java] 2010-08-31 12:41:41,972 FATAL > org.dspace.administer.RegistryLoader @ > anonymous::error_loading_registries: > [java] java.lang.NullPointerException > [java] at > org.dspace.storage.rdbms.TableRow.canonicalize(TableRow.java:674) > [java] at > org.dspace.storage.rdbms.TableRow.hasColumn(TableRow.java:110) > [java] at > org.dspace.storage.rdbms.TableRow.setColumn(TableRow.java:507) > [java] at > org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:713 > ) > [java] at > org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:490 > ) > [java] at > org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:419) > [java] at > org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:202) > [java] at > org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader > .java:168) > [java] at > org.dspace.administer.RegistryLoader.main(RegistryLoader.java:105) > > BUILD FAILED > /dspacehome/dspace-1.6.2-src-release/dspace/target/dspace-1.6.2- > build.dir/build.xml:663: > Java returned: 1 > > Total time: 24 seconds > > Any suggestions welcomed. > Marvin Weaver > > > Previous problem: > I finally found the problem! Solaris 10 comes with Sun's own screwed up > version of tar. It was truncating filenames at 21 characters. (I > thought they had abandoned it back with 5.8 and embraced gtar). > > I updated jdk to 1.60_21, installed gtar from sunfreeware, ran mvn > -Udb.name=oracle package, and it built. Only one very strange thing I > noticed, gtar ended with "tar: A lone zero block at 44151" rather than a > clean exit. > > Now, when trying ant fresh_install, I'm getting "index already > exists"...I'll wipe the database and try again. > > > > ------------------------------------------------------------------------ > ------ > This SF.net Dev2Dev email is sponsored by: > > Show off your parallel programming skills. > Enter the Intel(R) Threading Challenge 2010. > http://p.sf.net/sfu/intel-thread-sfd > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------------ This SF.net Dev2Dev email is sponsored by: Show off your parallel programming skills. Enter the Intel(R) Threading Challenge 2010. http://p.sf.net/sfu/intel-thread-sfd _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
