Hi,
We have customised dspace in our development machine and tried to run the
application on a different box, trying some kind of production environment
here.
Here the browse functionality particularly for the Authors and the Subject
link is not retrieving any items submitted to the community/collection we
have set up.
The browse links such as "By issue date" and "titles" does returns the
item in the collection/community.
The entire browse functionality is working fine in our development server.
Checked all configurations in the second machine, but its more or less
the same.
Tried re-indexing the production server, by following steps on wiki. But
the script index-all mentioned is absent on [dspace]/bin, Instead there are
2 scripts in the name of index-init and index-update
Tried running each of them but its throwing the following error
[EMAIL PROTECTED] bin]$ ./index-init
Exception in thread "main" org.dspace.browse.BrowseException:
java.sql.SQLException: ORA-00942: table or view does not exist
at
org.dspace.browse.BrowseCreateDAOOracle.updateCommunityMappings(BrowseCreateDAOOracle.java:613)
at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:403)
at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1106)
at org.dspace.browse.IndexBrowse.initBrowse(IndexBrowse.java:1056)
at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:707)
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:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:167)
at
org.dspace.browse.BrowseCreateDAOOracle.getAllCommunityIDs(BrowseCreateDAOOracle.java:926)
at
org.dspace.browse.BrowseCreateDAOOracle.updateCommunityMappings(BrowseCreateDAOOracle.java:561)
... 4 more
Creating search index
[EMAIL PROTECTED] bin]$
Checked code to find a table named Community2Item, which is absent in the
dspace database tables,(there is a table named communities2item) but
comfortably used in the code.
The interesting part is the same script when run on the development
machine runs fine without any hiccups.Are we running on any issue with our
machine setup for the production or??
Please help.
Thanks,
Flemion.
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech