[Dspace-tech] DSpace 3.2 index-init errors

[damanzano]

Hello, i'm migrating our dspace 1.7.2 to the 3.2 version,
I have followed al the instructions on
https://wiki.duraspace.org/display/DSDOC3x/Upgrading+a+DSpace+Installation
from 1.7.x to 1.8.x and 1.8.x to 3.x but i'm having problems with dspace
index-init command, for some items it's appearing the exception 1. Besides
at the beggining of the process others exceptions like the ones ad the end
of this post ocurred. I have DEBUG mode in my log4j

Exception 1
2013-09-12 09:40:21,892 DEBUG org.dspace.search.DSIndexer @ Building Item:
10906/235
2013-09-12 09:40:21,893 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "SELECT * FROM MetadataValue WHERE item_id= ? ORDER BY
metadata_field_id, place" with parameters: 180
2013-09-12 09:40:21,896 DEBUG org.dspace.search.DSIndexer @ Added Metadata
2013-09-12 09:40:21,896 DEBUG org.dspace.search.DSIndexer @ Added Sorting
2013-09-12 09:40:21,896 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "SELECT bundle.* FROM bundle, item2bundle WHERE
item2bundle.bundle_id=bundle.bundle_id AND item2bundle.item_id= ? " wi
th parameters: 180
2013-09-12 09:40:21,897 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "SELECT bitstream.*,bundle2bitstream.bitstream_order FROM
bitstream, bundle2bitstream WHERE bundle2bitstream.bitstream_
id=bitstream.bitstream_id AND bundle2bitstream.bundle_id= ? ORDER BY
sequence_is ASC" with parameters: 178
2013-09-12 09:40:21,898 ERROR org.dspace.search.DSIndexer @ ORA-00904:
"SEQUENCE_IS": invalid identifier

java.sql.SQLSyntaxErrorException: ORA-00904: "SEQUENCE_IS": invalid
identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
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.query(DatabaseManager.java:280)
at org.dspace.content.Bundle.<init>(Bundle.java:96)
at org.dspace.content.Item.getBundles(Item.java:1190)
at
org.dspace.search.DSIndexer.buildDocumentForItem(DSIndexer.java:1243)
at
org.dspace.search.DSIndexer.prepareIndexingTask(DSIndexer.java:671)
at org.dspace.search.DSIndexer.indexContent(DSIndexer.java:278)
at org.dspace.search.DSIndexer.indexContent(DSIndexer.java:260)
at org.dspace.search.DSIndexer.updateIndex(DSIndexer.java:540)
at org.dspace.search.DSIndexer.createIndex(DSIndexer.java:372)
at org.dspace.search.DSIndexer.main(DSIndexer.java:486)
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)
2013-09-12 09:40:21,899 INFO org.dspace.search.DSIndexer @ Wrote Item:
10906/235 to Index

Others Exceptions
2013-09-12 09:19:47,432 DEBUG net.sf.ehcache.config.DiskStoreConfiguration @
Disk Store Path: /tmp
2013-09-12 09:19:47,440 DEBUG net.sf.ehcache.config.ConfigurationHelper @ No
CacheManagerEventListen
erFactory class specified. Skipping...
2013-09-12 09:19:47,449 DEBUG net.sf.ehcache.config.ConfigurationHelper @ No
BootstrapCacheLoaderFac
tory class specified. Skipping...
2013-09-12 09:19:47,449 DEBUG net.sf.ehcache.config.ConfigurationHelper @ No
CacheExceptionHandlerFa
ctory class specified. Skipping...
2013-09-12 09:19:47,468 DEBUG net.sf.ehcache.util.UpdateChecker @ Checking
for update...
2013-09-12 09:19:48,849 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "SELECT * FRO
M bi_1 WHERE ROWNUM=1" with parameters:
2013-09-12 09:19:48,948 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "SELECT * FRO
M bi_1_dis WHERE ROWNUM=1" with parameters:
2013-09-12 09:19:48,950 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "SELECT * FRO
M bi_2 WHERE ROWNUM=1" with parameters:
2013-09-12 09:19:48,953 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "SELECT * FRO
M bi_2_dis WHERE ROWNUM=1" with parameters:
2013-09-12 09:19:48,975 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "DROP TABLE b
i_2_dis CASCADE CONSTRAINTS" with parameters:
2013-09-12 09:19:49,135 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "DROP TABLE b
i_2_dmap CASCADE CONSTRAINTS" with parameters:
2013-09-12 09:19:49,180 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "DROP SEQUENC
E bi_2_dmap_seq" with parameters:
2013-09-12 09:19:49,193 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "DROP SEQUENC
E bi_2_dis_seq" with parameters:
2013-09-12 09:19:49,197 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "DROP VIEW bi
_2_col_dmap CASCADE CONSTRAINTS" with parameters:
2013-09-12 09:19:49,200 ERROR org.dspace.browse.BrowseCreateDAOOracle @
caught exception:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3
584)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:366
5)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWr
apper.java:1352)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedState
ment.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedState
ment.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedState
ment.java:105)
at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:417)
at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:469)
at org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:892)
......................................................................

2013-09-12 09:19:49,311 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "DROP VIEW bi
_4_col_dmap CASCADE CONSTRAINTS" with parameters:
2013-09-12 09:19:49,313 ERROR org.dspace.browse.BrowseCreateDAOOracle @
caught exception:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3
584)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:366
5)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWr
apper.java:1352)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedState
ment.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedState
ment.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedState
ment.java:105)
at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:417)
at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:469)
at org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:892)
at org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:774)
at org.dspace.browse.IndexBrowse.initBrowse(IndexBrowse.java:1083)
at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:735)
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)
2013-09-12 09:19:49,313 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "DROP VIEW bi
_4_com_dmap CASCADE CONSTRAINTS" with parameters:
2013-09-12 09:19:49,316 ERROR org.dspace.browse.BrowseCreateDAOOracle @
caught exception:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3
584)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:366
5)

.....................................................................................................

2013-09-12 09:19:49,404 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "DROP VIEW bi
_5_col_dmap CASCADE CONSTRAINTS" with parameters:
2013-09-12 09:19:49,407 ERROR org.dspace.browse.BrowseCreateDAOOracle @
caught exception:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

......................................................................................................

2013-09-12 09:19:49,591 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "DROP VIEW bi
_item_col CASCADE CONSTRAINTS" with parameters:
2013-09-12 09:19:49,593 ERROR org.dspace.browse.BrowseCreateDAOOracle @
caught exception:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

......................................................................................................

2013-09-12 09:19:49,649 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "DROP VIEW bi
_withdrawn_col CASCADE CONSTRAINTS" with parameters:
2013-09-12 09:19:49,652 ERROR org.dspace.browse.BrowseCreateDAOOracle @
caught exception:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWr
apper.java:1352)

......................................................................................................

2013-09-12 09:19:49,707 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "DROP VIEW bi
_private_col CASCADE CONSTRAINTS" with parameters:
2013-09-12 09:19:49,710 ERROR org.dspace.browse.BrowseCreateDAOOracle @
caught exception:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3
584)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:366
5)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWr
apper.java:1352)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedState
ment.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedState
ment.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedState
ment.java:105)
at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:417)
at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:469)
at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:936)
at org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:903)
at org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:774)
at org.dspace.browse.IndexBrowse.initBrowse(IndexBrowse.java:1083)
at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:735)
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)
2013-09-12 09:19:49,710 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "DROP VIEW bi
_private_com CASCADE CONSTRAINTS" with parameters:
2013-09-12 09:19:49,713 ERROR org.dspace.browse.BrowseCreateDAOOracle @
caught exception:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

.........................................................................................................



--
View this message in context: http://dspace.2283337.n4.nabble.com/DSpace-3-2-index-init-errors-tp4667266.html
Sent from the DSpace - Tech mailing list archive at Nabble.com.

[helix84]

On Thu, Sep 12, 2013 at 11:52 PM, damanzano <dama...@icesi.edu.co> wrote:
> 2013-09-12 09:40:21,897 DEBUG org.dspace.storage.rdbms.DatabaseManager @
> Running query "SELECT bitstream.*,bundle2bitstream.bitstream_order FROM
> bitstream, bundle2bitstream WHERE bundle2bitstream.bitstream_
> id=bitstream.bitstream_id AND bundle2bitstream.bundle_id= ? ORDER BY
> sequence_is ASC" with parameters: 178
> 2013-09-12 09:40:21,898 ERROR org.dspace.search.DSIndexer @ ORA-00904:
> "SEQUENCE_IS": invalid identifier
>
> java.sql.SQLSyntaxErrorException: ORA-00904: "SEQUENCE_IS": invalid
> identifier

Hi Damanzano,

you have a typo in your source code. On this line you somehow changed
sequence_id to sequence_is. You must change it back, rebuild, redeploy
and restart DSpace.

https://github.com/DSpace/DSpace/blob/dspace-3.2/dspace-api/src/main/java/org/dspace/content/Bundle.java#L78


Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette