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'

        This is the controller panel for Smart Panels app

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

                Created:
                Updated:
                Resolved: