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

When creating index ACT_IDX_JOB_HANDLER a warning is emitted on sqlserver

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.7.0, 7.6.3, 7.7.0-alpha2
    • Component/s: engine
    • Labels:

      Description

      Steps to reproduce:

      1. add a job to the ACT_RU_JOB database table
      2. create ACT_IDX_JOB_HANDLER index

      Problem:
      The following warning is emitted:

      Code: 1945 SQL State: 01000 — Warning! The maximum key length is 900 bytes. The index 'ACT_IDX_JOB_HANDLER' has maximum length of 8510 bytes. For some combination of large values, the insert/update operation will fail.
      

      Hint:
      The warning is not emitted when the table ACT_RU_JOB is empty and the index is created.

        Attachments

          Activity

            People

            Assignee:
            roman.smirnov Smirnov Roman
            Reporter:
            roman.smirnov Smirnov Roman
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: