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

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Highest
    • 5.2.1
    • Affects Version/s: 5.2
    • Component/s: None
    • 5.02

      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.

            Assignee:
            Eric Dalgliesh
            Reporter:
            AmandaA
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: