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.

Oracle Community | Balaji Radhakrishnan | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    BPEL Transaction Inactive : Instance terminated without handling the Error

    Oracle Community | 3 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.

    Root Cause Analysis

    1. 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.

      at oracle.tip.adapter.db.exceptions.DBResourceException.createNonRetriableException()
    2. oracle.tip.adapter
      DBInteraction.execute
      1. oracle.tip.adapter.db.exceptions.DBResourceException.createNonRetriableException(DBResourceException.java:698)
      2. oracle.tip.adapter.db.exceptions.DBResourceException.createEISException(DBResourceException.java:664)
      3. oracle.tip.adapter.db.exceptions.DBResourceException.outboundWriteException(DBResourceException.java:712)
      4. oracle.tip.adapter.db.DBInteraction.executeOutboundWrite(DBInteraction.java:1117)
      5. oracle.tip.adapter.db.DBInteraction.execute(DBInteraction.java:247)
      5 frames
    3. oracle.integration.platform
      JCAInteractionInvoker.executeJcaInteraction
      1. oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.executeJcaInteraction(JCAInteractionInvoker.java:357)
      1 frame