DSpace-Tech:
One of the users of our DSpace 1.6.0 site noticed that the indexes are
no longer searchable from the homepage, and worse there are no items listed
in the entire site.
When I try to run a reindex on the site, I get the following error:
[root@dspaceprod run]# /dspace/run/bin/dsrun org.dspace.browse.IndexBrowse
> -f -r -v
Creating browse indexes for DSpace
init complete (0 ms)
Preparing browse tables
Deleting old indices
Checking for bi_1
Checking for bi_1_dis
... doesn't exist; but will carry on as there may be something that
> conflicts
Checking for bi_2
Checking for bi_2_dis
...found
Deleting old index and associated resources: bi_2_dis
Checking for bi_3
Checking for bi_3_dis
... doesn't exist; but will carry on as there may be something that
> conflicts
Checking for bi_4
Checking for bi_4_dis
...found
Deleting old index and associated resources: bi_4_dis
Checking for bi_5
Checking for bi_5_dis
... doesn't exist; but will carry on as there may be something that
> conflicts
Checking for bi_6
Checking for bi_6_dis
... doesn't exist; but will carry on as there may be something that
> conflicts
Checking for bi_7
Checking for bi_7_dis
... doesn't exist; but will carry on as there may be something that
> conflicts
Checking for bi_8
Checking for bi_8_dis
... doesn't exist; but will carry on as there may be something that
> conflicts
Checking for bi_9
Checking for bi_9_dis
... doesn't exist; but will carry on as there may be something that
> conflicts
Checking for bi_10
Checking for bi_10_dis
... doesn't exist; no more tables to delete
Creating browse index dateissued: index by null sortable by: dc.title
> dc.date.accessioned dc.date.issued
Creating browse index author: index by dc.contributor.*,dc.creator sortable
> by: dc.title dc.date.accessioned dc.date.issued
Creating browse index title: index by null sortable by: dc.title
> dc.date.accessioned dc.date.issued
Creating browse index subject: index by dc.subject.* sortable by: dc.title
> dc.date.accessioned dc.date.issued
Browse tables prepared
tables prepped (1089 ms, 1089 ms)
Exception: java.sql.SQLException: ORA-00942: table or view does not exist
> org.dspace.browse.BrowseException: java.sql.SQLException: ORA-00942: table
> or view does not exist
> at
org.dspace.browse.BrowseCreateDAOOracle.updateCommunityMappings(BrowseCreateDAOOracle.java:649)
> at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:402)
> at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1148)
> at org.dspace.browse.IndexBrowse.initBrowse(IndexBrowse.java:1098)
> at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:749)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:212)
> 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.executeForDescribe(T4CPreparedStatement.java:813)
> at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
> at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
> at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
> at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
> at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
> at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
> at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
> at
org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:239)
> at
org.dspace.browse.BrowseCreateDAOOracle.getAllCommunityIDs(BrowseCreateDAOOracle.java:962)
> at
org.dspace.browse.BrowseCreateDAOOracle.updateCommunityMappings(BrowseCreateDAOOracle.java:590)
> ... 9 more
We can't seem to figure out what table was previously there that is
suddenly preventing the indexing & reindexing of the site from happening, or
how to correct the issue we're seeing. Right now the site is useless as
none of the data on it can be accessed.
Environment:
DSpace 1.6.0
Red Hat Enterprise Linux 5
Oracle 11g
--
Bert Lensch
System Support Specialist III
Information Technology Services - Computer Center
Georgia Southern University
[email protected]
(912) 478-2395
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
