For days, I have been commenting out "create index" on fields that are keys and
therefor already indexed. But I am stumped on these errors:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
There are anumber of them and all seem to be caused by
org.dspace.browse.Browse...
Can anyone tell me what tables are missing? Where they should have been built?
What the columns, etc. the tables should have on them?
Thanks,
Marvin Weaver
-bash-3.00$ ant
-Dconfig=/dspacehome/dspace-1.5.2-release/dspace/config/dspace.cfg
fresh_install
Buildfile:
/dspacehome/dspace-1.5.2-release/dspace/target/dspace-1.5.2-build.dir/build.xml
init_installation:
init_configs:
setup_database:
[java] 2010-08-09 11:23:26,328 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration):
/dspacehome/dspace-1.5.2-release/dspace/config/dspace.cfg
[java] 2010-08-09 11:23:26,350 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java] 2010-08-09 11:23:26,350 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
[java] 2010-08-09 11:23:28,382 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:997)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100)
[java] 2010-08-09 11:23:28,390 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:997)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100)
[java] 2010-08-09 11:23:38,372 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration):
/dspacehome/dspace-1.5.2-release/dspace/config/dspace.cfg
[java] 2010-08-09 11:23:38,387 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java] 2010-08-09 11:23:40,108 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:390)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:855)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:737)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:700)
[java] 2010-08-09 11:23:40,119 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:390)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:856)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:737)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:700)
[java] 2010-08-09 11:23:40,666 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:390)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:855)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:737)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:700)
[java] 2010-08-09 11:23:40,676 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:390)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:856)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:737)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:700)
[java] 2010-08-09 11:23:41,099 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:390)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:899)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:864)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:737)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:700)
[java] 2010-08-09 11:23:41,110 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:390)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:900)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:864)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:737)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:700)
[java] 2010-08-09 11:23:41,442 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:390)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:899)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:865)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:737)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:700)
[java] 2010-08-09 11:23:41,452 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:390)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:900)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:865)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:737)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:700)
load_registries:
[java] 2010-08-09 11:23:44,533 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration):
/dspacehome/dspace-1.5.2-release/dspace/config/dspace.cfg
[java] 2010-08-09 11:23:44,550 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java] 2010-08-09 11:23:46,661 FATAL
org.dspace.administer.RegistryLoader @
anonymous::error_loading_registries:
[java] java.lang.NullPointerException
[java] at
org.dspace.storage.rdbms.TableRow.canonicalize(TableRow.java:607)
[java] at
org.dspace.storage.rdbms.TableRow.hasColumn(TableRow.java:110)
[java] at
org.dspace.storage.rdbms.TableRow.setColumn(TableRow.java:466)
[java] at
org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:643)
[java] at
org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:420)
[java] at
org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:421)
[java] at
org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:203)
[java] at
org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:169)
[java] at
org.dspace.administer.RegistryLoader.main(RegistryLoader.java:107)
BUILD FAILED
/dspacehome/dspace-1.5.2-release/dspace/target/dspace-1.5.2-build.dir/build.xml:629:
Java returned: 1
------------------------------------------------------------------------------
This SF.net email is sponsored by
Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
