Hi, The browse configuration in your dspace.cfg does not match the tables that have been created in the database.
You need to run index-init first - then subsequent index-updates will be successful. If you change the browse configuration again, you'll have to run index-init. G Thomas A McGee wrote: > This is what I get when I run the index update ---> > > Creating browse index > Exception in thread "main" org.dspace.browse.BrowseException: > java.sql.SQLException: ORA-00942: table or view does not exist > > at > org.dspace.browse.BrowseCreateDAOOracle.deleteByItemID(BrowseCreateDAOOracle.java:402) > at org.dspace.browse.IndexBrowse.removeIndex(IndexBrowse.java:302) > at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:456) > at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1106) > at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:661) > Caused by: java.sql.SQLException: ORA-00942: table or view does not exist > > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219) > at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370) > at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:354) > at > org.dspace.browse.BrowseCreateDAOOracle.deleteByItemID(BrowseCreateDAOOracle.java:397) > ... 4 more > Creating search index > > <---- the browse build is crashing, but the search build works. > > ________________________ > Tom McGee > Seton Hall University > ________________________ > ************ > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK& win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech This e-mail is confidential and should not be used by anyone who is not the original intended recipient. BioMed Central Limited does not accept liability for any statements made which are clearly the sender's own and not expressly made on behalf of BioMed Central Limited. No contracts may be concluded on behalf of BioMed Central Limited by means of e-mail communication. BioMed Central Limited Registered in England and Wales with registered number 3680030 Registered Office Middlesex House, 34-42 Cleveland Street, London W1T 4LB This email has been scanned by Postini. For more information please visit http://www.postini.com ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
