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

    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.

    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