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

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Highest
    • 5.1.8
    • 5.1.7
    • 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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. JPOSERVER-1922 Restoring JIRA Cloud to Server generating an java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long

          • High - High priority issues
          • Closed
          was cloned as

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-30604 Regressions: Upgrading JIRA get index error: ORA-00972: identifier is too long when running JIRA with Oracle

          • Highest - Our top priority issues
          • Closed
          mentioned in

          Page Loading...

          Activity

            People

              edalgliesh Eric Dalgliesh
              amwei AmandaA
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: