java.sql.BatchUpdateException: ORA-02049: timeout: distributed transaction waiting for lock

Oracle Community | Roseanne | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    ORA-02049: timeout: distributed transaction waiting for lock

    Oracle Community | 5 years ago | Roseanne
    java.sql.BatchUpdateException: ORA-02049: timeout: distributed transaction waiting for lock
  2. 0

    An error occurred while inserting data into the Reporting Table with Batch Update {0}

    Oracle Community | 2 years ago | 2710121
    java.lang.RuntimeException: [OSB-Reporting:473522]An error occurred while inserting data into the Reporting Table with Batch Update {0}],numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=60,XAServerResourceInfo[WLStore_OSB_21st_TRNG_Domain_FileStore_auto_1]=(ServerResourceInfo[WLStore_OSB_21st_TRNG_Domain_FileStore_auto_1]=(state=rolledback,assigned=OSB_21st_TRNG_rrapp01_Managed1),xar=WLStore_OSB_21st_TRNG_Domain_FileStore_auto_1381914510,re-Registered = false),XAServerResourceInfo[wlsbjmsrpDataSource_OSB_21st_TRNG_Domain]=(ServerResourceInfo[wlsbjmsrpDataSource_OSB_21st_TRNG_Domain]=(state=rolledback,assigned=OSB_21st_TRNG_rrapp01_Managed1),xar=wlsbjmsrpDataSource,re-Registered = false),SCInfo[OSB_21st_TRNG_Domain+OSB_21st_TRNG_rrapp01_Managed1]=(state=rolledback),properties=({weblogic.transaction.name=NewJMSMessagePoller.ReportingMDB}),local properties=({weblogic.jdbc.jta.wlsbjmsrpDataSource=[ No XAConnection is attached to this TxInfo ]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=OSB_21st_TRNG_rrapp01_Managed1+rrapp01.pld.aig.com:9173+OSB_21st_TRNG_Domain+t3+, XAResources={eis/tibjms/Topic, eis/sunmq/Queue, WSATGatewayRM_OSB_21st_TRNG_rrapp01_Managed1_OSB_21st_TRNG_Domain, WLStore_OSB_21st_TRNG_Domain_FileStore_auto_1, eis/wls/Queue, eis/tibjms/Queue, eis/tibjmsDirect/Topic, eis/activemq/Queue, WLStore_OSB_21st_TRNG_Domain__WLS_OSB_21st_TRNG_rrapp01_Managed1, eis/aqjms/Topic, wlsbjmsrpDataSource_OSB_21st_TRNG_Domain, WLStore_OSB_21st_TRNG_Domain_WseeFileStore_auto_1, eis/tibjmsDirect/Queue, eis/Apps/Apps, eis/jbossmq/Queue, eis/aqjms/Queue, eis/fioranomq/Topic, eis/pramati/Queue, eis/wls/Topic, eis/AQ/aqSample, eis/webspheremq/Queue},NonXAResources={})],CoordinatorURL=OSB_21st_TRNG_rrapp01_Managed1+rrapp01.pld.aig.com:9173+OSB_21st_TRNG_Domain+t3+): weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=com.bea.wli.reporting.jmsprovider.runtime.MDBMessageReporting@168425c6 [OSB-Reporting:473522]An error occurred while inserting data into the Reporting Table with Batch Update {0}
  3. 0

    errors in idp initiated sso in orcle access manager

    Stack Overflow | 2 years ago | Kr Rakesh
    java.sql.BatchUpdateException: ORA-00942: table or view does not exist</p> <pre><code>at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13349)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Oracle RAC with Admin tools

    Oracle Community | 6 years ago | 781995
    java.sql.BatchUpdateException: ORA-00001: unique constraint (WEBLOGIC_PORTAL.PK_CM_PROPERTY) violated
  6. 0

    ORA-01400: cannot insert NULL into ("DEV_SOAINFRA"."REFERENCE_INSTANCE"."CREATED_TIME")

    Oracle Community | 2 months ago | 2713499
    java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("DEV_SOAINFRA"."REFERENCE_INSTANCE"."CREATED_TIME") Error Code: 1400
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.BatchUpdateException

    ORA-02049: timeout: distributed transaction waiting for lock

    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch()
  2. Oracle jdbc
    OracleStatementWrapper.executeBatch
    1. oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13257)
    2. oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234)
    2 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeBatch
    1. weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:210)
    1 frame
  4. EclipseLink (non-OSGi)
    UnitOfWorkImpl.commit
    1. org.eclipse.persistence.platform.database.oracle.Oracle10Platform.executeBatch(Oracle10Platform.java:47)
    2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12BatchStatement(DatabaseAccessor.java:817)
    3. org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatchedStatements(ParameterizedSQLBatchWritingMechanism.java:139)
    4. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.writesCompleted(DatabaseAccessor.java:1632)
    5. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.commitTransaction(DatabaseAccessor.java:399)
    6. org.eclipse.persistence.internal.sessions.AbstractSession.basicCommitTransaction(AbstractSession.java:504)
    7. org.eclipse.persistence.sessions.server.ClientSession.basicCommitTransaction(ClientSession.java:155)
    8. org.eclipse.persistence.internal.sessions.AbstractSession.commitTransaction(AbstractSession.java:686)
    9. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitTransaction(UnitOfWorkImpl.java:1581)
    10. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1536)
    11. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitRootUnitOfWork(UnitOfWorkImpl.java:1330)
    12. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commit(UnitOfWorkImpl.java:1092)
    12 frames
  5. oracle.tip.adapter
    DBTransaction.commit
    1. oracle.tip.adapter.db.transaction.DBTransaction.commit(DBTransaction.java:193)
    1 frame
  6. oracle.integration.platform
    MeshImpl.post
    1. oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.executeJcaInteraction(JCAInteractionInvoker.java:323)
    2. oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeJcaReference(JCAInteractionInvoker.java:525)
    3. oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeAsyncJcaReference(JCAInteractionInvoker.java:508)
    4. oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAEndpointInteraction.performAsynchronousInteraction(JCAEndpointInteraction.java:491)
    5. oracle.integration.platform.blocks.adapter.AdapterReference.post(AdapterReference.java:247)
    6. oracle.integration.platform.blocks.mesh.AsynchronousMessageHandler.doPost(AsynchronousMessageHandler.java:142)
    7. oracle.integration.platform.blocks.mesh.MessageRouter.post(MessageRouter.java:194)
    8. oracle.integration.platform.blocks.mesh.MeshImpl.post(MeshImpl.java:215)
    8 frames
  7. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor1238.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  8. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    3 frames
  9. oracle.integration.platform
    PhaseEventAspect.invoke
    1. oracle.integration.platform.metrics.PhaseEventAspect.invoke(PhaseEventAspect.java:71)
    1 frame
  10. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  11. Unknown
    $Proxy302.post
    1. $Proxy302.post(Unknown Source)
    1 frame
  12. oracle.fabric
    CubeServiceEngine.postToMesh
    1. oracle.fabric.CubeServiceEngine.postToMesh(CubeServiceEngine.java:806)
    1 frame
  13. com.collaxa.cube
    CubeDeliveryBean.handleInvoke
    1. com.collaxa.cube.ws.WSInvocationManager.invoke(WSInvocationManager.java:258)
    2. com.collaxa.cube.engine.ext.common.InvokeHandler.__invoke(InvokeHandler.java:1056)
    3. com.collaxa.cube.engine.ext.common.InvokeHandler.handleNormalInvoke(InvokeHandler.java:583)
    4. com.collaxa.cube.engine.ext.common.InvokeHandler.handle(InvokeHandler.java:130)
    5. com.collaxa.cube.engine.ext.bpel.common.wmp.BPELInvokeWMP.__executeStatements(BPELInvokeWMP.java:74)
    6. com.collaxa.cube.engine.ext.bpel.common.wmp.BaseBPELActivityWMP.perform(BaseBPELActivityWMP.java:158)
    7. com.collaxa.cube.engine.CubeEngine._performActivity(CubeEngine.java:2463)
    8. com.collaxa.cube.engine.CubeEngine.performActivity(CubeEngine.java:2334)
    9. com.collaxa.cube.engine.CubeEngine.handleWorkItem(CubeEngine.java:1115)
    10. com.collaxa.cube.engine.dispatch.message.instance.PerformMessageHandler.handleLocal(PerformMessageHandler.java:73)
    11. com.collaxa.cube.engine.dispatch.DispatchHelper.handleLocalMessage(DispatchHelper.java:220)
    12. com.collaxa.cube.engine.dispatch.DispatchHelper.sendMemory(DispatchHelper.java:328)
    13. com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4350)
    14. com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4281)
    15. com.collaxa.cube.engine.CubeEngine.createAndInvoke(CubeEngine.java:679)
    16. com.collaxa.cube.engine.delivery.DeliveryService.handleInvoke(DeliveryService.java:654)
    17. com.collaxa.cube.engine.ejb.impl.CubeDeliveryBean.handleInvoke(CubeDeliveryBean.java:293)
    17 frames
  14. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor1242.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  15. com.bea.core
    MethodInvocationInvocationContext.proceed
    1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
    2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    4. com.bea.core.repackaged.springframework.jee.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:104)
    4 frames
  16. oracle.security.jps
    JpsAbsInterceptor$1.run
    1. oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:94)
    1 frame
  17. Java RT
    AccessController.doPrivileged
    1. java.security.AccessController.doPrivileged(Native Method)
    1 frame
  18. oracle.security.jps
    JpsInterceptor.intercept
    1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
    2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
    3. oracle.security.jps.ee.ejb.JpsAbsInterceptor.runJaasMode(JpsAbsInterceptor.java:81)
    4. oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:112)
    5. oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:105)
    5 frames
  19. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor1043.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  20. com.bea.core
    MethodInvocationVisitorImpl.visit
    1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
    2. com.bea.core.repackaged.springframework.jee.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:69)
    3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    4. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
    5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
    6. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    7. com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
    7 frames
  21. weblogic.ejb.container
    EnvironmentInterceptorCallbackImpl.callback
    1. weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
    1 frame
  22. com.bea.core
    JdkDynamicAopProxy.invoke
    1. com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
    2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    3. com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    4. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
    6. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
    7. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    8. com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    8 frames
  23. Unknown
    $Proxy285.handleInvoke
    1. $Proxy285.handleInvoke(Unknown Source)
    1 frame
  24. com.collaxa.cube
    BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.__WL_invoke
    1. com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.__WL_invoke(Unknown Source)
    1 frame
  25. weblogic.ejb.container
    SessionLocalMethodInvoker.invoke
    1. weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:39)
    1 frame
  26. com.collaxa.cube
    BaseDispatchTask.run
    1. com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.handleInvoke(Unknown Source)
    2. com.collaxa.cube.engine.dispatch.message.invoke.InvokeInstanceMessageHandler.handle(InvokeInstanceMessageHandler.java:35)
    3. com.collaxa.cube.engine.dispatch.DispatchHelper.handleMessage(DispatchHelper.java:140)
    4. com.collaxa.cube.engine.dispatch.BaseDispatchTask.process(BaseDispatchTask.java:88)
    5. com.collaxa.cube.engine.dispatch.BaseDispatchTask.run(BaseDispatchTask.java:64)
    5 frames
  27. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    3. java.lang.Thread.run(Thread.java:662)
    3 frames