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


-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Reply via email to