BPM Engine won't start due to 'Result set already closed' error (Doc ID 1074837.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Business Process Management Suite - Version 5.7 to 10.3
Information in this document applies to any platform.
***Checked for relevance on 18-Feb-2013***

Symptoms

Engine cannot start due to the exception:

An exception occurred while executing a transaction. Details:
Exception [Result set already closed].
Caused by: Result set already closed

fuego.directory.DirectoryRuntimeException: Exception [Result set already closed].
at fuego.directory.DirectoryRuntimeException.wrapException(DirectoryRuntimeException.java:84)
at fuego.directory.provider.jdbc.oracle.OraclePersistenceManager.mapSQLException(OraclePersistenceManager.java:115)
at fuego.directory.provider.jdbc.JDBCPersistenceManager.fetchAll(JDBCPersistenceManager.java:434)
at fuego.directory.provider.jdbc.JDBCPersistenceManager.fetchAll(JDBCPersistenceManager.java:398)
at fuego.directory.provider.jdbc.JDBCParticipantsAccessor.fetchAllHumanParticipants(JDBCParticipantsAccessor.java:285)
at fuego.directory.provider.jdbc.JDBCParticipantsAccessor.fetchAllHumanParticipants(JDBCParticipantsAccessor.java:262)
at fuego.directory.DirHumanParticipant.fetchAll(DirHumanParticipant.java:506)
at fuego.metadata.ParticipantManager.initialize(ParticipantManager.java:320)
at fuego.server.service.ParticipantService.loadMetadata(ParticipantService.java:137)
at fuego.server.service.ParticipantService.start(ParticipantService.java:148)
at fuego.server.service.AbstractService.changeRunLevel(AbstractService.java:99)
at fuego.server.service.AbstractService.setRunLevel(AbstractService.java:52)
at fuego.ejbengine.service.EJBParticipantService$InitializeItem.execute(EJBParticipantService.java:60)
at fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecution.java:291)
at fuego.transaction.TransactionAction.startBaseTransaction(TransactionAction.java:462)
at fuego.transaction.TransactionAction.startTransaction(TransactionAction.java:540)
at fuego.transaction.TransactionAction.start(TransactionAction.java:213)
at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:118)
at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:75)
at fuego.server.execution.DefaultEngineExecution.executeWithoutComponentImmediate(DefaultEngineExecution.java:179)
at fuego.server.execution.EngineExecution.executeWithoutComponentImmediate(EngineExecution.java:86)
at fuego.ejbengine.service.EJBParticipantService.initializeImpl(EJBParticipantService.java:44)
at fuego.ejbengine.service.EJBParticipantService.initialize(EJBParticipantService.java:31)
at fuego.ejbengine.DistributableObjectFactory.initializeParticipantService(DistributableObjectFactory.java:68)
at fuego.ejbengine.Engine.startServices(Engine.java:445)
Caused by: java.sql.SQLException: Result set already closed
at weblogic.jdbc.wrapper.ResultSet.checkResultSet(ResultSet.java:102)
at weblogic.jdbc.wrapper.ResultSet.preInvocationHandler(ResultSet.java:58)
at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getObject(I)Ljava.lang.Object;(Unknown Source)
at fuego.jdbc.FaultTolerantResultSet.getObject(FaultTolerantResultSet.java:319)
at oracle.jdbc.rowset.OracleCachedRowSet.populate(OracleCachedRowSet.java:1985)
at fuego.directory.provider.jdbc.JDBCPersistenceManager.createResultSet(JDBCPersistenceManager.java:1416)
at fuego.directory.provider.jdbc.JDBCPersistenceManager.fetchAll(JDBCPersistenceManager.java:414)
at fuego.directory.provider.jdbc.JDBCPersistenceManager.fetchAll(JDBCPersistenceManager.java:398)
at fuego.directory.provider.jdbc.JDBCParticipantsAccessor.fetchAllHumanParticipants(JDBCParticipantsAccessor.java:285)
at fuego.directory.provider.jdbc.JDBCParticipantsAccessor.fetchAllHumanParticipants(JDBCParticipantsAccessor.java:262)
at fuego.directory.DirHumanParticipant.fetchAll(DirHumanParticipant.java:506)
at fuego.metadata.ParticipantManager.initialize(ParticipantManager.java:320)
at fuego.server.service.ParticipantService.loadMetadata(ParticipantService.java:137)
at fuego.server.service.ParticipantService.start(ParticipantService.java:148)
at fuego.server.service.AbstractService.changeRunLevel(AbstractService.java:99)
at fuego.server.service.AbstractService.setRunLevel(AbstractService.java:52)
at fuego.ejbengine.service.EJBParticipantService$InitializeItem.execute(EJBParticipantService.java:60)
at fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecution.java:291)
at fuego.transaction.TransactionAction.startBaseTransaction(TransactionAction.java:462)
at fuego.transaction.TransactionAction.startTransaction(TransactionAction.java:540)
at fuego.transaction.TransactionAction.start(TransactionAction.java:213)
at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:118)
at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:75)
at fuego.server.execution.DefaultEngineExecution.executeWithoutComponentImmediate(DefaultEngineExecution.java:179)
at fuego.server.execution.EngineExecution.executeWithoutComponentImmediate(EngineExecution.java:86)
at fuego.ejbengine.service.EJBParticipantService.initializeImpl(EJBParticipantService.java:44)
at fuego.ejbengine.service.EJBParticipantService.initialize(EJBParticipantService.java:31)
at fuego.ejbengine.DistributableObjectFactory.initializeParticipantService(DistributableObjectFactory.java:68)

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