Could not create table due to missing Field Type definition


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


プラットフォームについて: Server と Data Center のみ - この記事は、サーバーおよびデータセンター プラットフォームのアトラシアン製品にのみ適用されます。


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/).


オプション 1

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

オプション 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;
Last modified on Mar 30, 2016


Powered by Confluence and Scroll Viewport.