System slowness due to ORA-01000 errors in BPM 10g (Doc ID 2088304.1)

Last updated on DECEMBER 14, 2015

Applies to:

Oracle Business Process Management Suite - Version 10.3.2 and later
Information in this document applies to any platform.

Symptoms

Unable to use the system due to slowness and there are a number of ORA-01000 errors in the log files:

java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded

at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.oracle.OracleImplBlob.getLength(Unknown Source)
at weblogic.jdbc.base.BaseImplBlobService.getLength(Unknown Source)
at weblogic.jdbc.base.BaseBlobInputStream.(Unknown Source)
at weblogic.jdbc.base.BaseBlob.getBinaryStream(Unknown Source)
at weblogic.jdbc.base.BaseData.getBinaryStream(Unknown Source)
at weblogic.jdbc.base.BaseResultSet.getBinaryStream(Unknown Source)
at weblogic.jdbc.base.BaseResultSet.getBinaryStream(Unknown Source)
at weblogic.jdbcx.base.BaseResultSetWrapper.getBinaryStream(Unknown Source)
at weblogic.jdbc.wrapper.ResultSet_weblogic_jdbcx_base_BaseResultSetWrapper.getBinaryStream(Unknown Source)
at fuego.jdbc.FaultTolerantResultSet.getBinaryStream(FaultTolerantResultSet.java:115)
at fuego.server.persistence.jdbc.JdbcProcessInstancePersMgr.loadObject(JdbcProcessInstancePersMgr.java:3308)
at fuego.server.persistence.jdbc.JdbcProcessInstancePersMgr.load(JdbcProcessInstancePersMgr.java:1686)
at fuego.server.persistence.Persistence.loadInstance(Persistence.java:851)
at fuego.server.AbstractInstanceService.readInstance(AbstractInstanceService.java:803)
at fuego.ejbengine.EJBInstanceService.getLockedROImpl(EJBInstanceService.java:130)
at fuego.server.AbstractInstanceService.getLockedROImpl(AbstractInstanceService.java:918)
at fuego.server.AbstractInstanceService.getLockedImpl(AbstractInstanceService.java:769)
at fuego.server.AbstractInstanceService.getLockedWaiting(AbstractInstanceService.java:217)
at fuego.server.AbstractInstanceService.getLockedWaiting(AbstractInstanceService.java:197)
at fuego.server.execution.AbstractReceiveNotificationExecutionHandler.getLockedTargetInstance(AbstractReceiveNotificationExecutionHandler.java:228)
at fuego.server.execution.AbstractReceiveNotificationExecutionHandler.receiveNotification(AbstractReceiveNotificationExecutionHandler.java:96)
at fuego.server.AbstractProcessBean$39.execute(AbstractProcessBean.java:2771)
at fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecution.java:304)
at fuego.transaction.TransactionAction.startNestedTransaction(TransactionAction.java:527)
at fuego.transaction.TransactionAction.startTransaction(TransactionAction.java:548)
at fuego.transaction.TransactionAction.start(TransactionAction.java:212)
at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:123)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms