Re: [Dspace-tech] DSpace 3.2 index-init errors

2013-09-15 Thread helix84
On Thu, Sep 12, 2013 at 11:52 PM, damanzano damanz...@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

--
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=64545871iu=/4140/ostg.clktrk
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette


[Dspace-tech] DSpace 3.2 index-init errors

2013-09-12 Thread 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