java.sql.BatchUpdateException: ORA-01013: user requested cancel of current operation . Please see the logs for the full DBAdapter logging output prior to this exception. This exception is considered retriable, likely due to a communication failure. Because the global transaction is rolling back the invoke must be retried in a new transaction, restarting from the place of the last transaction commit. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "1013" to your deployment descriptor (i.e. weblogic-ra.xml).

Oracle Community | Venkata Chakradhar P | 10 months ago
  1. 0

    DB Adapter Update Operation Failing in OSB

    Oracle Community | 10 months ago | Venkata Chakradhar P
    java.sql.BatchUpdateException: ORA-01013: user requested cancel of current operation . Please see the logs for the full DBAdapter logging output prior to this exception. This exception is considered retriable, likely due to a communication failure. Because the global transaction is rolling back the invoke must be retried in a new transaction, restarting from the place of the last transaction commit. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "1013" to your deployment descriptor (i.e. weblogic-ra.xml).
  2. 0

    Business service failed to insert the data in DB2

    Oracle Community | 5 years ago | 924244
    java.sql.BatchUpdateException: [IBM][CLI Driver][DB2/LINUXX8664] SQL0798N A value cannot be specified for co umn "SEARCH_ID" which is defined as GENERATED ALWAYS. SQLSTATE=428C9 . Please see the logs for the full DBAdapter logging output prior to this exception. ConnectionFactory property platform lassName was set to org.eclipse.persistence.platform.database.oracle.Oracle10Platform but the database you are connecti g to is DB2/LINUXX8664. Please validate your platformClassName setting. This mismatch can cause the adapter to trigge runtime exceptions or execute SQL that is invalid for the database you are connected to. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCo es with value "--798" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these omposite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties ar integers.
  3. 0

    How to create WebLogic JCA connection factory ?

    Oracle Community | 6 years ago | 852806
    java.sql.BatchUpdateException: ORA-00942: table or view does not exist . Please see the logs for the full DBAdapter logging output prior to this exception. This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "942" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    BPEL Transaction Inactive : Instance terminated without handling the Error

    Oracle Community | 2 years ago | Balaji Radhakrishnan
    java.sql.BatchUpdateException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.. Please see the logs for the full DBAdapter logging output prior to this exception. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-242" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.
  6. 0

    BPEL Transaction Inactive : Instance terminated without handling the Error

    Oracle Community | 2 years ago | Balaji Radhakrishnan
    java.sql.BatchUpdateException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.. Please see the logs for the full DBAdapter logging output prior to this exception. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-242" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.

    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-01013: user requested cancel of current operation . Please see the logs for the full DBAdapter logging output prior to this exception. This exception is considered retriable, likely due to a communication failure. Because the global transaction is rolling back the invoke must be retried in a new transaction, restarting from the place of the last transaction commit. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "1013" to your deployment descriptor (i.e. weblogic-ra.xml).

      at oracle.tip.adapter.db.exceptions.DBResourceException.createXARetriableException()
    2. oracle.tip.adapter
      JCABindingReferenceImpl.post
      1. oracle.tip.adapter.db.exceptions.DBResourceException.createXARetriableException(DBResourceException.java:686)
      2. oracle.tip.adapter.db.exceptions.DBResourceException.createEISException(DBResourceException.java:658)
      3. oracle.tip.adapter.db.exceptions.DBResourceException.outboundWriteException(DBResourceException.java:712)
      4. oracle.tip.adapter.db.transaction.DBTransaction.commit(DBTransaction.java:240)
      5. oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.performOperation(WSIFOperation_JCA.java:552)
      6. oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.executeOperation(WSIFOperation_JCA.java:369)
      7. oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.executeRequestResponseOperation(WSIFOperation_JCA.java:328)
      8. oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.executeInputOnlyOperation(WSIFOperation_JCA.java:307)
      9. oracle.tip.adapter.sa.impl.JCABindingReferenceImpl.invokeWsifProvider(JCABindingReferenceImpl.java:345)
      10. oracle.tip.adapter.sa.impl.JCABindingReferenceImpl.post(JCABindingReferenceImpl.java:199)
      10 frames
    3. com.bea.wli
      JCATransportEndpoint.sendOneWay
      1. com.bea.wli.sb.transports.jca.binding.JCATransportOutboundOperationBindingServiceImpl.invokeOneWay(JCATransportOutboundOperationBindingServiceImpl.java:109)
      2. com.bea.wli.sb.transports.jca.JCATransportEndpoint.sendOneWay(JCATransportEndpoint.java:191)
      2 frames