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

Index ACT_IDX_JOB_HANDLER too long for DB2

    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
    • 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

        Activity

        Hide
        dennis.riegelbauer@nordlb.de Dennis Riegelbauer added a comment -

        Hi,

        we have the same issue with DB2 10.5.

        Greetings
        Dennis

        Show
        dennis.riegelbauer@nordlb.de Dennis Riegelbauer added a comment - Hi, we have the same issue with DB2 10.5. Greetings Dennis
        Hide
        balser Michael Balser added a comment -

        Same here with DB2 10.1 and Camunda 7.8.5-ee.

        Show
        balser Michael Balser added a comment - Same here with DB2 10.1 and Camunda 7.8.5-ee.
        Hide
        thorben.lindhauer Thorben Lindhauer added a comment -

        Please raise a support issue if you would like to see this addressed.

        Show
        thorben.lindhauer Thorben Lindhauer added a comment - Please raise a support issue if you would like to see this addressed.
        Hide
        Gwaptiva Jaap Sperling added a comment -

        er... this issue has been open for over a year. What's this "support issue" that needs opening if not this?

        Show
        Gwaptiva Jaap Sperling added a comment - er... this issue has been open for over a year. What's this "support issue" that needs opening if not this?
        Hide
        thorben.lindhauer Thorben Lindhauer added a comment - - edited

        If you have an enterprise license, you (or a registered support contact) can open a JIRA issue in this project: https://app.camunda.com/jira/browse/SUPPORT. In the support context you can request us to add this ticket to our development roadmap to make sure that the problem gets addressed. As a non-enterprise user, you can always report issues (which we are very happy to receive) but we cannot guarantee when/if the problem gets addressed. Another option then is to submit a pull request to the Camunda codebase on github.

        Show
        thorben.lindhauer Thorben Lindhauer added a comment - - edited If you have an enterprise license, you (or a registered support contact) can open a JIRA issue in this project: https://app.camunda.com/jira/browse/SUPPORT . In the support context you can request us to add this ticket to our development roadmap to make sure that the problem gets addressed. As a non-enterprise user, you can always report issues (which we are very happy to receive) but we cannot guarantee when/if the problem gets addressed. Another option then is to submit a pull request to the Camunda codebase on github.
        Hide
        Gwaptiva Jaap Sperling added a comment -

        Ah ok. I just put this here to help you improve the product (and possibly to remind you to test the scripts you provide )

        Thanks for the clarification

        Show
        Gwaptiva Jaap Sperling added a comment - Ah ok. I just put this here to help you improve the product (and possibly to remind you to test the scripts you provide ) Thanks for the clarification

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development