nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

vkharisma

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.

All comments

unknown

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?

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 _________________

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

unknown

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.

vkharisma

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

database

oracle