Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-8536

Creation of fieldid_fieldconfig index fails in DB2

    XMLWordPrintable

Details

    Description

      The problem is that "fieldid_fieldconfig" index name is too long. To correct the problem edit WEB-INF/classes/entitydefs/entitymodel.xml file and rename "fieldid_fieldconfig" to "fieldid_fieldconf". Then drop and recreate the database and restart JIRA.

      If you do not wish to drop and recreate the database just edit the WEB-INF/classes/entitydefs/entitymodel.xm file and then run the following SQL in your database:

      CREATE INDEX fieldid_fieldconf ON DB2INST1.optionconfiguration (FIELDID, FIELDCONFIG)
      

      Please use the correct schema name in the SQL above. "DB2INST1" is the example schema.

      Attachments

        Activity

          People

            Unassigned Unassigned
            anton@atlassian.com AntonA
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: