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

XMLWordPrintable

    • Type: Bug Report
    • Resolution: Fixed
    • Priority: L3 - Default
    • 7.0.2, 7.1.0, 7.1.0-alpha1
    • Affects Version/s: 7.0.0, 7.0.1
    • Component/s: 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'

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

              Created:
              Updated:
              Resolved: