WLI - java.sql.SQLException: ORA-01591: Lock Held by In-Doubt Distributed Transaction (Doc ID 775051.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Oracle WebLogic Integration - Version 9.2.1MP and later
Information in this document applies to any platform.
Information in this document applies to any platform


Symptoms

 The following error appear in the logs intermittently :

####<Mar 18, 2004 9:59:45 AM CST> <Info> <EJB> <wli> <wliserver> <ExecuteThread: '88'
for queue: 'weblogic.kernel.Default'> <24401030008> <> <BEA-010049> <EJB Exception in method:
ejbPostCreate: javax.ejb.FinderException: Problem in
findByStateBean_xgwy74__WebLogic_CMP_RDBMS_stateBean_previousState__WL_ while preparing or executing statement:
'weblogic.jdbc.wrapper.PreparedStatement_oracle_jdbc_driver_OraclePreparedStatement@7bae17':
java.sql.SQLException: ORA-01591: lock held by in-doubt distributed transaction 33.39.1787

java.sql.SQLException: ORA-01591: lock held by in-doubt distributed transaction 33.39.1787
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1250)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2529)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2857)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:80)
at com.bea.wli.worklist.beans.entity.StateBean_xgwy74__WebLogic_CMP_RDBMS.ejbFindByStateBean_xgwy74__WebLogic_CMP_RDBMS_stateBean_previousState__WL_(StateBean_xgwy74__WebLogic_CMP_RDBMS.java:3265)
at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.scalarFinder(RDBMSPersistenceManager.java:294)
at weblogic.ejb20.manager.BaseEntityManager.scalarFinder(BaseEntityManager.java:1575)
at weblogic.ejb20.manager.BaseEntityManager.localScalarFinder(BaseEntityManager.java:1559)
at com.bea.wli.worklist.beans.entity.StateBean_xgwy74__WebLogic_CMP_RDBMS.getStateBean_previousState(StateBean_xgwy74__WebLogic_CMP_RDBMS.java:1802)
at com.bea.wli.worklist.beans.entity.StateBean_xgwy74__WebLogic_CMP_RDBMS.__WL_setRestStateBean_previousState(StateBean_xgwy74__WebLogic_CMP_RDBMS.java:1899)
at com.bea.wli.worklist.beans.entity.StateBean_xgwy74__WebLogic_CMP_RDBMS.__WL_postSetPreviousState(StateBean_xgwy74__WebLogic_CMP_RDBMS.java:1729)
at com.bea.wli.worklist.beans.entity.StateBean_xgwy74__WebLogic_CMP_RDBMS.setPreviousState(StateBean_xgwy74__WebLogic_CMP_RDBMS.java:1651)
at com.bea.wli.worklist.beans.entity.StateBean.ejbPostCreate(StateBean.java:133)
at com.bea.wli.worklist.beans.entity.StateBean_xgwy74__WebLogic_CMP_RDBMS.ejbPostCreate(StateBean_xgwy74__WebLogic_CMP_RDBMS.java:5948)
at sun.reflect.GeneratedMethodAccessor149.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at weblogic.ejb20.manager.DBManager.create(DBManager.java:1261)
at weblogic.ejb20.manager.DBManager.localCreate(DBManager.java:1100)
at weblogic.ejb20.internal.EntityEJBLocalHome.create(EntityEJBLocalHome.java:171)
at com.bea.wli.worklist.beans.entity.StateBean_xgwy74_LocalHomeImpl.create(StateBean_xgwy74_LocalHomeImpl.java:109)
at com.bea.wli.worklist.beans.session.RemoteWorklistManagerBean.claimTask(RemoteWorklistManagerBean.java:1106)
at com.bea.wli.worklist.beans.session.RemoteWorklistManagerBean$2.run(RemoteWorklistManagerBean.java:975)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at com.bea.wli.worklist.security.WorklistSecurityManager.runAsUser(WorklistSecurityManager.java:252)
at com.bea.wli.worklist.beans.session.RemoteWorklistManagerBean.assignToUser(RemoteWorklistManagerBean.java:981)
at com.bea.wli.worklist.beans.session.RemoteWorklistManagerBean.assignToUser(RemoteWorklistManagerBean.java:955)
at com.bea.wli.worklist.beans.session.RemoteWorklistManagerBean_us8t1c_EOImpl.assignToUser(RemoteWorklistManagerBean_us8t1c_EOImpl.java:3578)
at com.bea.wli.worklist.beans.session.RemoteWorklistManagerBean_us8t1c_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:166)
at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:284)
at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:244)
at com.bea.wli.worklist.beans.session.RemoteWorklistManagerBean_us8t1c_EOImpl_812_WLStub.assignToUser(Unknown Source)
at com.bea.wli.worklist.control.ControlHelper.assignToUser(ControlHelper.java:590)
at com.bea.wli.worklist.control.TaskControlHelper.invoke(TaskControlHelper.java:617)
at com.bea.control.TaskControlImpl.invoke(TaskControlImpl.jcs:90)
at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:373)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:423)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:396)
at com.bea.wlw.runtime.jcs.container.JcsProxy.invoke(JcsProxy.java:389)
at $Proxy9.assignTaskToUser(Unknown Source)
at processes.baseflow.taskInstanceAssignTaskToUser(baseflow.jpd:326)
at processes.baseflow_wf$ImplControlSend25.invoke(baseflow_wf.java:270)
at com.bea.wli.bpm.runtime.Perform.execute(Perform.java:32)
at com.bea.wli.bpm.runtime.Receive.messageDelivery(Receive.java:91)
at com.bea.wli.bpm.runtime.Receive.messageDeliveryAction(Receive.java:71)
at com.bea.wli.bpm.runtime.ProcessState.processMessage(ProcessState.java:165)
at processes.baseflow_wf$_ProcessState.processMessage(baseflow_wf.java:1122)
at processes.baseflow_wf.taskFactoryCtl_onTaskCompleted(baseflow_wf.java:1061)
at sun.reflect.GeneratedMethodAccessor195.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:367)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:423)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:396)
at com.bea.wlw.runtime.core.container.Invocable.fireEvent(Invocable.java:612)
at com.bea.wlw.runtime.core.context.WlwThreadContext.sendEvent(WlwThreadContext.java:980)
at com.bea.wlw.runtime.jcs.container.JcsContainer.sendEvent(JcsContainer.java:466)
at com.bea.wli.worklist.control.TaskControlHelper.onTaskEvent(TaskControlHelper.java:787)
at com.bea.control.TaskControlImpl.listener_onTaskEvent(TaskControlImpl.jcs:73)
at sun.reflect.GeneratedMethodAccessor193.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:367)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:423)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:396)
at com.bea.wlw.runtime.core.container.Invocable.fireEvent(Invocable.java:612)
at com.bea.wlw.runtime.jcs.container.JcsProxy.invoke(JcsProxy.java:413)
at $Proxy14.onTaskEvent(Unknown Source)
at sun.reflect.GeneratedMethodAccessor192.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:367)
at com.bea.wlw.runtime.jcs.container.JcsContainer.invoke(JcsContainer.java:98)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:319)
at com.bea.wlw.runtime.jcs.container.JcsContainer.invoke(JcsContainer.java:84)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:319)
at com.bea.wlw.runtime.core.bean.BaseContainerBean.invokeBase(BaseContainerBean.java:198)
at com.bea.wlw.runtime.core.bean.BMPContainerBean.invoke(BMPContainerBean.java:1969)
at com.bea.wlwgen.baseflowBMPContImpl.taskFactoryCtl$listener$callback(baseflowBMPContImpl.java:155)
at com.bea.wlwgen.PersistentContainer_jscib6_ELOImpl.taskFactoryCtl$listener$callback(PersistentContainer_jscib6_ELOImpl.java:1341)
at com.bea.wlwgen.baseflowBMPContAdpt.invokeOnBean(baseflowBMPContAdpt.java:161)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.runAsInvoke(BaseDispatcherBean.java:153)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.run(BaseDispatcherBean.java:85)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:353)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:144)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.invoke(BaseDispatcherBean.java:50)
at com.bea.wlw.runtime.core.bean.AsyncDispatcherBean.onMessage(AsyncDispatcherBean.java:248)
at weblogic.ejb20.internal.MDListener.execute(MDListener.java:382)
at weblogic.ejb20.internal.MDListener.transactionalOnMessage(MDListener.java:316)
at weblogic.ejb20.internal.MDListener.onMessage(MDListener.java:281)
at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:2596)
at weblogic.jms.client.JMSSession.execute(JMSSession.java:2516)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)

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