[Dspace-tech] search returns communities and collections and NOT author, title, etc...

4 views

Skip to first unread message

Jamil Haddad

unread,

Aug 25, 2015, 1:38:16 PM8/25/15

to Dspac...@lists.sourceforge.net

Hello,

I have a server running on postgresql which is not having the below described problem.

On the other server running Oracle 10g (10.2.0.3) we are facing a problem when searching. The search on the Dspace’s main page returns results only when the searched string is found in a community or collection name. No returns returned are from title, author, subject, etc…

From the installation I had many errors but the “ant fresh_install” ended successfully. The errors found below were mainly:

java.sql.SQLException: ORA-01408: such column list already indexed

java.sql.SQLException: ORA-01031: insufficient privileges

java.sql.SQLException: ORA-00942: table or view does not exist

I tried to run index-init and got the following:

# index-init

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.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)

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: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)

... 4 more

Creating search index

And below is a capture from the installation log (from the “ant fresh_install”):

[java] Attempting to connect to database:

[java] - URL: jdbc:oracle:thin:@//server:port/dspacedbname

[java] - Driver: oracle.jdbc.OracleDriver

[java] - Username: *********

[java] - Password: ***********

[java] - Schema: null

[java]

[java] Testing connection...

[java] Connected succesfully!

[java]

setup_database:

[java] 2010-03-15 15:30:09,050 INFO org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg

[java] 2010-03-15 15:30:09,069 INFO org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if uninitended, check your dspace.cfg for (log.init.config)

[java] 2010-03-15 15:30:09,070 INFO org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database

[java] 2010-03-15 15:30:10,412 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: java.sql.SQLException: ORA-01408: such column list already indexed

[java]

[java] java.sql.SQLException: ORA-01408: such column list already indexed

[java]

[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

[java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)

[java] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)

[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)

[java] at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1696)

[java] at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1662)

[java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)

[java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:1067)

[java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100)

[java] 2010-03-15 15:30:10,420 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: java.sql.SQLException: ORA-01408: such column list already indexed