Error "ORA-00972: identifier is too long" at startup on JIRA

During startup, I see this error. What does it mean and how to fix it ?

2012-11-27 13:56:41,970 main ERROR [core.entity.jdbc.DatabaseUtil] Could not create missing indices for entity "ManagedConfigurationItem"
2012-11-27 13:56:41,971 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


4 answers

1 accepted

2 votes

Hi,

It seems that you ran into this bug:

For JIRA 5.1

https://jira.atlassian.com/browse/JRA-30237

For JIRA 5.2

https://jira.atlassian.com/browse/JRA-30604

Cheers,

Vicky.

Somebody has written a plugin that has not catered for Oracles table name length restrictions. You can't fix this unless its your plugin. What plugin failed to intialize?

The only User-installed Plugins is "JIRA Subversion plugin 0.10.11"

This happens very early during the system startup. Right after "Java System Properties" section and before the "Starting the JIRA Plugin System" setion

======================================================

___ Java System Properties _________________

...........................................................................................

user.country : US
user.dir : /local/apps/jira-dev/bin
user.home : /local/apps/cixscm
user.language : en
user.name : cixscm
user.timezone : US/Eastern

2012-11-27 22:36:39,255 main ERROR [core.entity.jdbc.DatabaseUtil] Could not create missing indices for entity "ManagedConfigurationItem"
2012-11-27 22:36:39,255 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


Database configuration OK

___ Database Configuration _________________

Loading entityengine.xml from : file:/local/apps/jira-dev/atlassian-jira/WEB-INF/classes/entityengine.xml
Entity model field type name : oracle10g
Entity model schema name :
Database Version : Oracle - Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning and Real Application Testing options
Database Driver : Oracle JDBC driver - 11.2.0.2.0
Database URL : jdbc:oracle:thin:@umwus024.corpnet2.com:1521:usprd401
Database JDBC config : oracle10g jdbc:oracle:thin:@umwus024.corpnet2.com:1521:usprd401


___ Starting the JIRA Plugin System _________________


___ Plugin System Started _________________

======================================================

Well, I think its appropriate to contact https://support.atlassian.com as this is a coding/compatibility issue. You could validate that this particular plugin is the culprit by removing it and restarting. That would give support something to work with.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,335 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot