My Oracle Support Banner

Timeout Exceptions In Log While Trying To Run The Disposer. Instances In END State Are Not Being Removed (Doc ID 863700.1)

Last updated on AUGUST 14, 2018

Applies to:

Oracle Business Process Management Suite - Version 5.7 to 10.3.1
Information in this document applies to any platform.
***Checked for relevance on 10-Jan-2012***
***Checked for relevance on 21-August-2013***

Symptoms

The BPM Engine is slow and you may see a lot of timeouts.  You should also find that there are many instances in the PPROCINSTANCE table that have a state of 32 or 64 (meaning they are completed or aborted, in the End activity) which match the dispose conditions.

Additionally, you may see a timeout exception that looks similar to the following exception in your engine log files:

Could not dispose instances from process '/ProcessName#Default-1.1'.
Details:
An error occurred while accesing the database.
Technical detail:SQL statement: 'unknown'

Caused by: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction
rolled back: Transaction timed out after 300 seconds
BEA1-3576ECDDDF04C88E82B9
at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1432)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1344)
at weblogic.jdbc.wrapper.JTAConnection.getXAConn(JTAConnection.java:193)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:93)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:87)
at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:495)
at fuego.jdbc.FaultTolerantConnection.prepareStatement(FaultTolerantConnection.java:519)
at fuego.server.persistence.jdbc.JdbcProcessInstancePersMgr.getInstancesToDispose(JdbcProcessInstancePe
rsMgr.java:807)
at fuego.server.persistence.Persistence.getInstancesToDispose(Persistence.java:308)
at fuego.server.execution.Caducator.disposeInstance(Caducator.java:257)
at fuego.server.execution.Caducator.disposeInstances(Caducator.java:330)
at fuego.server.execution.Caducator.execute(Caducator.java:205)
at fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecutio
n.java:290)
at fuego.transaction.TransactionAction.startNestedTransaction(TransactionAction.java:516)
at fuego.transaction.TransactionAction.startTransaction(TransactionAction.java:537)
at fuego.transaction.TransactionAction.start(TransactionAction.java:213)
at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:117)
at
fuego.server.execution.DefaultEngineExecution.executeAutomaticWork(DefaultEngineExecution.java:57)
at fuego.server.execution.EngineExecution.executeAutomaticWork(EngineExecution.java:42)
at fuego.server.execution.ToDoItem.executeAutomaticWork(ToDoItem.java:264)
at fuego.ejbengine.ItemExecutionBean$1.execute(ItemExecutionBean.java:232)
at
fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecutio
n.java:290)
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:117)
at fuego.server.execution.EngineExecution.executeImmediate(EngineExecution.java:66)
at fuego.ejbengine.ItemExecutionBean.processMessage(ItemExecutionBean.java:220)
at fuego.ejbengine.ItemExecutionBean.onMessage(ItemExecutionBean.java:129)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:429)


fuego.transaction.DatabaseException: An error occurred while accesing the database.
Technical detail:SQL statement: 'unknown'

at
fuego.server.persistence.jdbc.JdbcProcessInstancePersMgr.getInstancesToDispose(JdbcProcessInstancePe
rsMgr.java:830)
at fuego.server.persistence.Persistence.getInstancesToDispose(Persistence.java:308)
at fuego.server.execution.Caducator.disposeInstance(Caducator.java:257)
at fuego.server.execution.Caducator.disposeInstances(Caducator.java:330)
at fuego.server.execution.Caducator.execute(Caducator.java:205)
at
fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecutio
n.java:290)
at fuego.transaction.TransactionAction.startNestedTransaction(TransactionAction.java:516)
at fuego.transaction.TransactionAction.startTransaction(TransactionAction.java:537)
at fuego.transaction.TransactionAction.start(TransactionAction.java:213)
at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:117)
at
fuego.server.execution.DefaultEngineExecution.executeAutomaticWork(DefaultEngineExecution.java:57)
at fuego.server.execution.EngineExecution.executeAutomaticWork(EngineExecution.java:42)
at fuego.server.execution.ToDoItem.executeAutomaticWork(ToDoItem.java:264)
at fuego.ejbengine.ItemExecutionBean$1.execute(ItemExecutionBean.java:232)
at
fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecutio
n.java:290)
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:117)
at fuego.server.execution.EngineExecution.executeImmediate(EngineExecution.java:66)
at fuego.ejbengine.ItemExecutionBean.processMessage(ItemExecutionBean.java:220)
at fuego.ejbengine.ItemExecutionBean.onMessage(ItemExecutionBean.java:129)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:429)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:335)
at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:291)
Caused by: java.sql.SQLException: Unexpected exception while enlisting XAConnection
java.sql.SQLException: Transaction rolled back: Transaction timed out after 300 seconds
BEA1-3576ECDDDF04C88E82B9
at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1432)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1344)
at weblogic.jdbc.wrapper.JTAConnection.getXAConn(JTAConnection.java:193)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:93)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:87)
at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:495)
at fuego.jdbc.FaultTolerantConnection.prepareStatement(FaultTolerantConnection.java:519)
at
fuego.server.persistence.jdbc.JdbcProcessInstancePersMgr.getInstancesToDispose(JdbcProcessInstancePe
rsMgr.java:807)
at fuego.server.persistence.Persistence.getInstancesToDispose(Persistence.java:308)
at fuego.server.execution.Caducator.disposeInstance(Caducator.java:257)
at fuego.server.execution.Caducator.disposeInstances(Caducator.java:330)
at fuego.server.execution.Caducator.execute(Caducator.java:205)
at
fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecutio
n.java:290)
at fuego.transaction.TransactionAction.startNestedTransaction(TransactionAction.java:516)
at fuego.transaction.TransactionAction.startTransaction(TransactionAction.java:537)
at fuego.transaction.TransactionAction.start(TransactionAction.java:213)
at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:117)
at
fuego.server.execution.DefaultEngineExecution.executeAutomaticWork(DefaultEngineExecution.java:57)
at fuego.server.execution.EngineExecution.executeAutomaticWork(EngineExecution.java:42)
at fuego.server.execution.ToDoItem.executeAutomaticWork(ToDoItem.java:264)
at fuego.ejbengine.ItemExecutionBean$1.execute(ItemExecutionBean.java:232)
at
fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecutio
n.java:290)
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:117)
at fuego.server.execution.EngineExecution.executeImmediate(EngineExecution.java:66)
at fuego.ejbengine.ItemExecutionBean.processMessage(ItemExecutionBean.java:220)
at fuego.ejbengine.ItemExecutionBean.onMessage(ItemExecutionBean.java:129)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:429)

at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1357)
at weblogic.jdbc.wrapper.JTAConnection.getXAConn(JTAConnection.java:193)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:93)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:87)
at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:495)
at fuego.jdbc.FaultTolerantConnection.prepareStatement(FaultTolerantConnection.java:519)
at
fuego.server.persistence.jdbc.JdbcProcessInstancePersMgr.getInstancesToDispose(JdbcProcessInstancePe
rsMgr.java:807)
at fuego.server.persistence.Persistence.getInstancesToDispose(Persistence.java:308)
at fuego.server.execution.Caducator.disposeInstance(Caducator.java:257)
at fuego.server.execution.Caducator.disposeInstances(Caducator.java:330)
at fuego.server.execution.Caducator.execute(Caducator.java:205)
at
fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecutio
n.java:290)
at fuego.transaction.TransactionAction.startNestedTransaction(TransactionAction.java:516)
at fuego.transaction.TransactionAction.startTransaction(TransactionAction.java:537)
at fuego.transaction.TransactionAction.start(TransactionAction.java:213)
at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:117)
at
fuego.server.execution.DefaultEngineExecution.executeAutomaticWork(DefaultEngineExecution.java:57)
at fuego.server.execution.EngineExecution.executeAutomaticWork(EngineExecution.java:42)
at fuego.server.execution.ToDoItem.executeAutomaticWork(ToDoItem.java:264)
at fuego.ejbengine.ItemExecutionBean$1.execute(ItemExecutionBean.java:232)
at
fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecutio
n.java:290)
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:117)
at fuego.server.execution.EngineExecution.executeImmediate(EngineExecution.java:66)
at fuego.ejbengine.ItemExecutionBean.processMessage(ItemExecutionBean.java:220)
at fuego.ejbengine.ItemExecutionBean.onMessage(ItemExecutionBean.java:129)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:429)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:335)


Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.