JIRA Upgrade or Installation Fails due to ORA-00972 identifier is too long Error

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

When upgrading/installing JIRA and connecting to a database with Oracle 11g the following appears in the atlassian-jira.log:

2013-06-22 09:56:51,094 localhost-startStop-1 ERROR      [core.entity.jdbc.DatabaseUtil] Could not create missing indices for entity "ReplicatedIndexOperation"
2013-06-22 09:56:51,094 localhost-startStop-1 ERROR      [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE INDEX node_id_index_operation_time_idx ON replicatedindexoperation (NODE_ID, AFFECTED_INDEX, OPERATION, INDEX_TIME)
Error was: java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long

This does not have any functional impact on JIRA at all — the identifier that is causing the error message is currently not being used.

Cause

Oracle has a 30 character limitation on identifiers (table names and columns). Because node_id_index_operation_time_idx is over 30 characters, Oracle generates the error when trying to create JIRA's index.

Workaround

If you want to get rid of the error message, do the following. Please note, as mentioned previously, this error does not have any functional impact on JIRA.

  • Navigate to the following folder

    <JIRA-Install-Dir>\atlassian-jira\WEB-INF\classes\entitydefs
  • Open up entitymodel.xml in a text editor and replace node_id_index_operation_time_idx with node_operation_idx
  • Save the file, and restart JIRA

Resolution

  • This issue is currently being tracked at JRA-30237 - Getting issue details... STATUS
  • Please vote and watch this ticket to stay notified of any updates
Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.