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

Index ACT_IDX_JOB_HANDLER too long for DB2

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: 7.6.0
    • Fix Version/s: 7.10.0, 7.10.0-alpha1, 7.9.3, 7.8.9
    • Component/s: engine
    • Labels:
    • Environment:
      DB2 10.1 and 11.1
    • Title Keywords:
      index db2 ddl

      Description

      As in CAM-7442, when creating the index ACT_IDX_JOB_HANDLER in DB2 (10.1 as well as 11.1), I get the following error message:

      CREATE INDEX ACT_IDX_JOB_HANDLER ON ACT_RU_JOB (HANDLER_TYPE_, HANDLER_CFG_)
      DB21034E  The command was processed as an SQL statement because it was not a 
      valid Command Line Processor command.  During SQL processing it returned:
      SQL0614N  The index or index extension "ACT_IDX_JOB_HANDLER" cannot be created 
      or altered because the combined length of the specified columns is too long.  
      SQLSTATE=54008
      

      Seems it needs to be excluded too

        Attachments

          Activity

            People

            Assignee:
            nikola.koevski Nikola Koevski
            Reporter:
            Gwaptiva Jaap Sperling
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: