weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_2d641b85a027a9ba:43f1e2cd:11e2800892f:-7fd2): com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0025: esb *SET "Value" = ?* *WHERE (("ID" = ?) AND ("Value" = ?))]: [NULL, 1, a different value|http://forums.oracle.com/forums/]: Optimistic locking failure. Update count returned by database is 0, expected 1*

Oracle Community | 672962 | 8 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

    Problems creating physical data service to relational table

    Oracle Community | 8 years ago | 672962
    weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_2d641b85a027a9ba:43f1e2cd:11e2800892f:-7fd2): com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0025: esb *SET "Value" = ?* *WHERE (("ID" = ?) AND ("Value" = ?))]: [NULL, 1, a different value|http://forums.oracle.com/forums/]: Optimistic locking failure. Update count returned by database is 0, expected 1*
  2. 0

    com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0004:

    Oracle Community | 7 years ago | user738507
    weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_04322b570a3ba688:-f852189:12babfe9a85:-7ff3): com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0004: Error executing SQL query: [BEA][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'TEST_P' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

    Root Cause Analysis

    1. weblogic.xml.query.exceptions.XQuerySagaException

      {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_2d641b85a027a9ba:43f1e2cd:11e2800892f:-7fd2): com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0025: esb *SET "Value" = ?* *WHERE (("ID" = ?) AND ("Value" = ?))]: [NULL, 1, a different value|http://forums.oracle.com/forums/]: Optimistic locking failure. Update count returned by database is 0, expected 1*

      at com.bea.ld.server.update.recovery.SagaRecovery.process()
    2. com.bea.ld
      DSPSagaManager.processSagaFailure
      1. com.bea.ld.server.update.recovery.SagaRecovery.process(SagaRecovery.java:102)
      2. com.bea.ld.server.update.recovery.DSPSagaManager.processSagaFailure(DSPSagaManager.java:219)
      2 frames
    3. weblogic.xml.query
      TransactionManager.afterCompletion
      1. weblogic.xml.query.update.recovery.SagaState$2.afterCompletion(SagaState.java:83)
      2. weblogic.xml.query.transaction.TransactionManager.afterCompletion(TransactionManager.java:133)
      2 frames
    4. weblogic.transaction.internal
      ServerTransactionImpl.rollback
      1. weblogic.transaction.internal.ServerSCInfo.doAfterCompletion(ServerSCInfo.java:1032)
      2. weblogic.transaction.internal.ServerSCInfo.callAfterCompletions(ServerSCInfo.java:1011)
      3. weblogic.transaction.internal.ServerTransactionImpl.callAfterCompletions(ServerTransactionImpl.java:2946)
      4. weblogic.transaction.internal.ServerTransactionImpl.afterRolledBackStateHousekeeping(ServerTransactionImpl.java:2827)
      5. weblogic.transaction.internal.ServerTransactionImpl.setRolledBack(ServerTransactionImpl.java:2803)
      6. weblogic.transaction.internal.ServerTransactionImpl.globalRetryRollback(ServerTransactionImpl.java:3043)
      7. weblogic.transaction.internal.ServerTransactionImpl.globalRollback(ServerTransactionImpl.java:2793)
      8. weblogic.transaction.internal.ServerTransactionImpl.internalRollback(ServerTransactionImpl.java:397)
      9. weblogic.transaction.internal.ServerTransactionImpl.rollback(ServerTransactionImpl.java:375)
      9 frames
    5. weblogic.xml.query
      TransactionManager.teardownOnFailure
      1. weblogic.xml.query.transaction.TransactionHelper.rollback(TransactionHelper.java:102)
      2. weblogic.xml.query.transaction.TransactionManager.teardownOnFailure(TransactionManager.java:262)
      2 frames
    6. com.bea.ld
      Server_ydm4ie_EOImpl_WLSkel.invoke
      1. com.bea.ld.EJBRequestHandler.handleThrowable(EJBRequestHandler.java:810)
      2. com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:311)
      3. com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:84)
      4. com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:354)
      5. com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)
      5 frames
    7. weblogic.rmi.internal
      BasicServerRef.invoke
      1. weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)
      1 frame
    8. weblogic.rmi.cluster
      ClusterableServerRef.invoke
      1. weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224)
      1 frame
    9. weblogic.rmi.internal
      BasicServerRef$1.run
      1. weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:479)
      1 frame
    10. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
      1 frame
    11. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(Unknown Source)
      1 frame
    12. weblogic.rmi.internal
      BasicServerRef$BasicExecuteRequest.run
      1. weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:475)
      2. weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:59)
      3. weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:1016)
      3 frames
    13. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:172)
      2 frames