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

      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.

        This is the controller panel for Smart Panels app

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

                Created:
                Updated:
                Resolved: