Could not create table due to missing Field Type definition


アトラシアン コミュニティをご利用ください。


この記事はアトラシアンのサーバー プラットフォームにのみ適用されます。クラウドとサーバー製品の違いについてはこちらをご確認ください。


When installing or upgrading JIRA, one or more tables may fail to be created and present messages such as below on atlassian-jira.log.

2015-08-18 08:32:23,275 localhost-startStop-1 WARN      [core.entity.jdbc.DatabaseUtil] Entity "ClusteredJob" has no table in the database
2015-08-18 08:32:23,275 localhost-startStop-1 ERROR      [core.entity.jdbc.DatabaseUtil] Could not create table "clusteredjob"
2015-08-18 08:32:23,275 localhost-startStop-1 ERROR      [core.entity.jdbc.DatabaseUtil] Field type [null] not found for field [parameters] of entity [ClusteredJob], not creating table.


This occurs when JIRA is unable to locate a field type definition for the type of data stored in a certain column of the database. This information is stored on the fieldtype-<db-type>.xml file (located under <JIRA_INSTALL>/atlassian-jira/WEB-INF/classes/entitydefs/).


Option 1

Replace the fieldtype-<db-type>.xml file with the one from a clean installation of JIRA.

Option 2

  1. Open the entitymodel.xml file (located on the same folder as the fieldtype-<db-type>.xml);
  2. Locate the field definition according to what was presented in the log message/s (see example below) and take note of the value for type;

    <field name="parameters" type="byte-array" />
  3. Open the fieldtype-<db-type>.xml file (according to the database driver you use) and locate the field-type-def property for the field noted above (see example for oracle10g);

    <field-type-def type="byte-array" sql-type="LONG RAW" java-type="java.lang.Object"></field-type-def>
  4. Compare with the fieldtype-<db-type>.xml of a new installation of JIRA and add the definition for such field type;
  5. Restart JIRA;
最終更新日 2016 年 3 月 30 日


Powered by Confluence and Scroll Viewport.