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
  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 | 6 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