Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-1346

Fix Arithmetic overflow/exception on DB2 when calculating duration in history

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.0.2, 7.1.0, 7.1.0-alpha1
    • 7.0.0, 7.0.1
    • engine
    • None

      Reproduce steps:

      See SUPPORT-689

      Problem:

      Updating HistoricActivityInstance throws Arithmetic overflow/exception when calculating duration on DB2.
      Cause is DB2 threats the values before addition as Integer not BigInteger so an Overflow occurs.

      Expected behavior:

      Works.

      Hints (optional):

      All mappings in history where we calculate the duration must be checked and adjusted like
      UPDATE
      ACT_HI_ACTINST
      SET
      DURATION_ = --->>>> (CAST(123456775676890 AS BIGINT) + CAST(1235000000 AS BIGINT)) <<<<---
      WHERE
      TASK_ID_ = '96fcea2d-1150-11e3-98fa-028037ec0200'

        This is the controller panel for Smart Panels app

              Unassigned Unassigned
              lipphardt Christian
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: