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
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 _________________
======================================================
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.