[Dspace-tech] maximum open cursors exceeded Exception in dsrun tool

4 views
Skip to first unread message

Hlias Stavrakis

unread,
Aug 24, 2015, 5:09:48 PM8/24/15
to dspac...@lists.sourceforge.net
Hi, i'm getting the following exception after 40 ingestions in dspace using dsrun.
Can anyone help?
 

java.sql.SQLException: ORA-01000: maximum open cursors exceeded

 

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)

        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:954)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1167)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284)

        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3367)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)

        at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:519)

        at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:539)

        at org.dspace.browse.Browse.itemRemoved(Browse.java:439)

        at org.dspace.browse.Browse.itemChanged(Browse.java:465)

        at org.dspace.content.Item.update(Item.java:1500)

        at org.dspace.content.Item.create(Item.java:247)

        at org.dspace.content.WorkspaceItem.create(WorkspaceItem.java:173)

        at org.dspace.app.itemimport.ItemImport.addItem(ItemImport.java:629)

        at org.dspace.app.itemimport.ItemImport.addItems(ItemImport.java:506)

        at org.dspace.app.itemimport.ItemImport.main(ItemImport.java:415)

java.sql.SQLException: ORA-01000: maximum open cursors exceeded

 

James Rutherford

unread,
Aug 24, 2015, 5:09:49 PM8/24/15
to Hlias Stavrakis, dspac...@lists.sourceforge.net
This has been addressed a few times before. Check the list archives on
SourceForge:

http://sourceforge.net/mailarchive/forum.php?forum_name=dspace-tech

Jim
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> DSpace-tech mailing list
> DSpac...@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech


--
James Rutherford | Hewlett-Packard Limited registered Office:
Research Engineer | Cain Road,
HP Labs | Bracknell,
Bristol, UK | Berks
+44 117 312 7066 | RG12 1HN.
james.ru...@hp.com | Registered No: 690597 England

The contents of this message and any attachments to it are confidential and
may be legally privileged. If you have received this message in error, you
should delete it from your system immediately and advise the sender. To any
recipient of this message within HP, unless otherwise stated you should
consider this message and attachments as "HP CONFIDENTIAL".

Reply all
Reply to author
Forward
0 new messages