Bobcares

For every $500 you spend, we will provide you with a $500 credit on your account*

BLACK FRIDAY SPECIAL

*The maximum is $4000 in credits, Offer valid till November 30th, 2024, New Customers Only, Credit will be applied after purchase and expires after six (6) months

For every $500 you spend, we will provide you with a $500 credit on your account*

BLACK FRIDAY SPECIAL

*The maximum is $4000 in credits, Offer valid till November 30th, 2024, New Customers Only, Credit will be applied after purchase and expires after six (6) months

Jira error “There are no issue type mappings for this scheme”

by | Dec 18, 2021

Wondering how to resolve Jira error “There are no issue type mappings for this scheme”? We can help you.

At Bobcares, we offer solutions for every query, big and small, as a part of our Server Management Service.

Let’s take a look at how our Support Team recently helped a customer with a Jira query.

How to resolve Jira error “There are no issue type mappings for this scheme”?

Typically, following will appear 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.

Today, let us see the steps followed by our Support techs to resolve this error:

1. Firstly, shut down Jira

2. Then, 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);
  • Always back up your data before performing any modifications to the database.

If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

  • Then, start back Jira and verify if the issue persists

[Looking for another solution to this query? We are just a click away.]

 

Conclusion

To conclude, the skilled Support Engineers at Bobcares demonstrated how to resolve this error There are no issue type mappings for this scheme.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Never again lose customers to poor
server speed! Let us help you.