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

This widget could not be displayed.

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.

This widget could not be displayed.

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?

This widget could not be displayed.

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 _________________

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

This widget could not be displayed.

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 Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

578 views 25 15
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