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

Oracle Community | Roseanne | 5 years ago
  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

    Select for nowait update

    Stack Overflow | 2 years ago | user1274028
    java.sql.BatchUpdateException: invalid batch command: invalid SELECT batch command 0

  1. r1chjames 10 times, last 6 months ago
12 unregistered visitors
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