[
https://jira.duraspace.org/browse/DS-1095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Donohue closed DS-1095.
---------------------------
Documentation Status: Not Required (was: Needed)
Resolution: Answered
Hello,
This Issue Tracker is for software bug reports and feature requests only. Any
local issues you are having should first be asked about on the DSpace Tech
Listserv:
https://lists.sourceforge.net/lists/listinfo/dspace-tech/
That being said, it sounds like your database is not setup properly, as this
error is complaining that the "Community2Item" table doesn't exist -- this
table should have been created automatically during the install of DSpace (when
running 'ant fresh_install'). If you need help determining the root cause,
please ask on the dspace-tech mailing list, and we'd be glad to try and help
you.
I'm going to close this issue, as this sounds like a misconfiguration of your
database. Feel free to email dspace-tech for more help in resolving this issue.
> Problems with index-init and with index creation (DSPACE version 1.7.1)
> -----------------------------------------------------------------------
>
> Key: DS-1095
> URL: https://jira.duraspace.org/browse/DS-1095
> Project: DSpace
> Issue Type: New Feature
> Reporter: Anna Andrlová
> Priority: Critical
> Labels: configs
>
> Hi,
> we have recently installed DSpace (version 1.7.1 on Oracle) and put there
> some training data. Further we tried to search and browse and it didn't work.
> We realized that no index was created. Then we tried to run index-init and it
> didn't work, we got back this failure notice
> tarted: 1323741602223
> Ended: 1323741646993
> Elapsed time: 44 secs (44770 msecs)
> Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does
> not exist
> org.dspace.browse.BrowseException: java.sql.SQLSyntaxErrorException:
> ORA-00942: table or view does not exist
> at
> org.dspace.browse.BrowseCreateDAOOracle.updateCommunityMappings(BrowseCreateDAOOracle.java:641)
> at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:380)
> at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1124)
> at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:669)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183)
> Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does
> not exist
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
> at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
> at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
> at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
> at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
> at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
> at
> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
> at
> oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:225)
> at
> org.dspace.browse.BrowseCreateDAOOracle.getAllCommunityIDs(BrowseCreateDAOOracle.java:1060)
> at
> org.dspace.browse.BrowseCreateDAOOracle.updateCommunityMappings(BrowseCreateDAOOracle.java:578)
> ... 8 more
> Do anaone know how to solve it, or how to successfully create index from
> metadata in Dspace
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://jira.duraspace.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Systems Optimization Self Assessment
Improve efficiency and utilization of IT resources. Drive out cost and
improve service delivery. Take 5 minutes to use this Systems Optimization
Self Assessment. http://www.accelacomm.com/jaw/sdnl/114/51450054/
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
