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

[Xinfu Xia]

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

[vkharisma · Accepted solution]

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.

[Andy Brook [Plugin People]]

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.

[Xinfu Xia]

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 _________________

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

[Andy Brook [Plugin People]]

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?