Herbert,
You need to work back through the stack trace. First thing you'll notice is
that the BrowseException that is thrown in updateCommunityMappings is a
wrapping of a caught SQLException.
Following the stack trace of the SQLException ('caused by' in your output),
you'll go through the Oracle libraries, through the DatabaseManager and out
into
org.dspace.browse.BrowseCreateDAOOracle.getAllCommunityIDs(BrowseCreateDAOOracle.java:962)
The only SQL directly issued within the getAllCommunityIDs method is against
Community2Item - a view that is comprised of a join between
Community2Collection and Collection2Item.
If you look at the update script for the database in version 1.6, you'll see
that both of these tables (Com2Col and Col2Item) have been ALTERed. This
will have invalidated the Community2Item view.
Go to the database and recompile any invalidated objects - eg. ALTER VIEW
Community2Item COMPILE; - and it will fix the problem.
Regards,
G
On 1 February 2011 17:04, Herbert Lensch <[email protected]>wrote:
> 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
>
>
------------------------------------------------------------------------------
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
