Problem

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.

Cause

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

Resolution

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;