問題

In the default Issue Type scheme, you will see the following error:

The following appears in the logs

/secure/admin/ConfigureIssueTypeScreenScheme.jspa [webwork.util.ValueStack] query="/issueTypeScreenSchemeEntities/empty" {[id="null" type="5" values=""]}
{[id="issueTypeScreenSchemeEntities" type="8" values=""]} {[id="empty" type="8" values=""]}
java.lang.reflect.InvocationTargetException

Caused by: java.lang.NullPointerException
at com.atlassian.jira.issue.comparator.IssueTypeKeyComparator.compare(IssueTypeKeyComparator.java:36)
at com.atlassian.jira.issue.fields.screen.issuetype.IssueTypeScreenSchemeEntityImpl.compareTo(IssueTypeScreenSchemeEntityImpl.java:156) 

診断

Run the following SQL query to determine if you are affected by this issue:

select * from issuetypescreenschemeentity where issuetype not in (select id from issuetype);

If you are affected, this should return a results, else if there are no results from the above query, then you are not affected by this issue.

原因

The issue occurs because there are issue types referenced in the issuetypescreenschemeentity table, however, they do not exist in the issuetype table.

ソリューション

1. Jira をシャットダウンします。

2. Run the following query to delete entries in the issuetypescreenschemeentity table that are invalid as they reference deleted/removed issue types.

   delete from issuetypescreenschemeentity where issuetype not in (select id from issuetype);

   データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。

3. Start back Jira and verify if the issue persists

There are no issue type mappings for this scheme Message

Jira、Jira Software、Jira Service Management