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

Align ACT_HI_JOB_LOG.ACT_ID_ column size to standard value

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: 7.3.0
    • Fix Version/s: 7.4.0, 7.3.1, 7.4.0-alpha1
    • Component/s: engine
    • Labels:

      Description

      Impact:

      • History Level = Full
      • Processes contain activity Ids longer than 64 characters
      • All databases are affected

      Reproduce steps:

      Create a process where jobs are executing activities with ACT_IDs longer than 64 chars. After executing the jobs, the engine fails to insert them into the historic job log.

      Problem:

      The column "ACT_ID_" in table "ACT_HI_JOB_LOG" is only created of size '64'. In all other places (ACT_RU_EXECUTION.ACT_ID etc.) it is of size '255'. When an ACT_ID_ longer than 64 chars is inserted into ACT_HI_JOB_LOG an SQL exception is thrown.

      Expected behavior:

      No SQL exception thrown. Complete ACT_ID_ is preserved.

        Activity

        Hide
        JeffStark Jeff Stark added a comment -
        Show
        JeffStark Jeff Stark added a comment - The source code I used for my last project - https://jar-download.com/artifacts/org.camunda.bpm/camunda-engine/7.6.0-alpha3/source-code/org/camunda/bpm/engine/db/create/activiti.mssql.create.history.sql I also posted a question on the forum about size of text datatype here https://forum.camunda.org/t/increasing-size-of-text-datatype-in-output-parmeter/2650/3 https://thetermpapers.net/term-paper-help/ project/http-connector/ in Camunda Modeller to hit a REST URL.

          People

          • Assignee:
            meyer Daniel Meyer
            Reporter:
            lipphardt Christian Lipphardt
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development