Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-30237

Upgrading JIRA get index error: ORA-00972: identifier is too long when running JIRA with Oracle

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Highest
    • Resolution: Fixed
    • 5.1.7
    • 5.1.8
    • None

    Description

      When upgrading JIRA and connect database with Oracle 11g, during the startup, it will show the following error in log file:

      2012-10-24 18:56:12,569 main ERROR      [core.entity.jdbc.DatabaseUtil] Could not create missing indices for entity "ManagedConfigurationItem"
      2012-10-24 18:56:12,569 main ERROR      [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
      CREATE INDEX managedconfigurationitem_id_type_index ON managedconfigurationitem (ITEM_ID, ITEM_TYPE)
      Error was: java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
      

      JIRA is able to start up, so far all JIRA features seems working fine. Re-index in JIRA UI can be done successfully.

      Attachments

        Issue Links

          Activity

            People

              edalgliesh Eric Dalgliesh (public name)
              amwei AmandaA
              Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: