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 JULY 08, 2015

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

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