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

    • Bug Report
    • Status: Closed
    • L3 - Default
    • Resolution: Fixed
    • None
    • 7.7.0, 7.6.3, 7.7.0-alpha2
    • engine

    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.

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Salesforce