Issue type invalid error thrown when moving an issue to another type in Jira server

Symptom

1. In JIRA applications, when moving issues from one Issue Type to another one or even between projects, the operation fails with the below error message;

2. When moving an issue to another project, the project selection may not be correctly displayed. In this case, the below error can be seen in the browser's console;

Cause

In a Jira, the "Default Issue Type Scheme" should include all issue types present on the instance. When that's not the case, multiple problems can occur, such as the failure when moving issues.

There are two possible causes for problems related to this.

1. When the target issue type is not included in "Default Issue Type Scheme". You can determine which issue types are missing on that scheme by running the following query on the JIRA database;

2. When JIRA somehow reads another Issue Type Scheme as the default, instead of the "Default Issue Type Scheme";

This can be determined by running the following query against your database. The id returned should be 10000. If it's not 10000, then follow the workaround below.

Workaround

Cause 1

As most default schemes in JIRA the "Default Issue Type Scheme" is read-only, so we need to manually add the missing issue types through the database.

1. Shut down JIRA;

2. Identify the missing values:

   1 SELECT id, pname FROM issuetype WHERE id NOT IN (SELECT optionid FROM optionconfiguration WHERE fieldconfig = 10000 AND fieldid = 'issuetype');

3. Use the following SQL statement to add the missing entries from previous step. Repeat the query as many times as necessary until you've added all missing issue types;

   1 INSERT INTO optionconfiguration VALUES ((SELECT MAX(oc.id)+1 FROM optionconfiguration oc), 'issuetype', '<missing_issue_type_id>', 10000, (SELECT MAX(oc.sequence)+1 FROM optionconfiguration oc WHERE oc.fieldconfig=10000));

   ℹ️ Replace <missing_issue_type_id> with the ID of the missing field;

4. Fix the sequence_value_item table to avoid key violations

   1 UPDATE sequence_value_item SET seq_id = (SELECT MAX(id)+100 FROM optionconfiguration) WHERE seq_name = 'OptionConfiguration'; 

5. Start JIRA

6. Go to Administration > System > Indexing and perform a full re-index by selecting the Lock JIRA and re-build indexes option;

Cause 2

This will restore 'Default Issue Type Scheme' as the default scheme JIRA application uses

1. Shut down JIRA;

2. Run the below SQL queries in JIRA's database;

   1 DELETE FROM configurationcontext WHERE id IN (SELECT cc.id FROM configurationcontext cc WHERE cc.customfield = 'issuetype' AND project IS NULL);
   1 INSERT INTO configurationcontext VALUES (10000, NULL, NULL, 'issuetype', 10000);

3. Fix the sequence_value_item table to avoid key violations

   1  UPDATE sequence_value_item SET seq_id = (SELECT MAX(id)+100 FROM configurationcontext) WHERE seq_name = 'ConfigurationContext';

4. Start JIRA;