Wondering how to resolve Jira Empty Backlog Even Though Issue Exist? 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 Empty Backlog Even Though Issue Exist?

Backlog is empty with “There are currently no issues in the backlog” message is shown even though there are issues exist.

In order to diagnose the issue, please check the below:

• Sprint field is applicable in Global Project and Issue Type
• Total number of issues are shown via Tools > Configure > Columns
• In the database, run following queries:

1.Firstly, check what is the Sprint type custom field used as the default

select * from propertynumber where id in (select id from propertyentry where property_key like '%GreenHopper.Sprint.Default%');

Take note of the propertyvalue column as this is the Custom Field ID

2.Then, check if issue has value in this custom field

select * from customfieldvalue where customfield=<Customfield_ID>;

if there is no result return, proceed with the next SQL query

3.Then, check if there any Sprint type customfield

SELECT * FROM customfield where customfieldtypekey like '%sprint%';

4. Next, check if the other Sprint Type custom field has value:

select ISSUE from customfieldvalue where customfield=<Other_customfield_ID>;

If there any result return, take note of the customfield column and proceed to Resolution section

Issue occurs if the default Sprint used for default has been changed.

Today, let us see the steps followed by our Support Techs to resolve it:

1. Firstly, backup JIRA Software database

2. Then, update database manually

update propertynumber set propertyvalue=<customfield> where id=<property_id>;

customfield should referring to Sprint type custom field that has value. The property_id is referring to the ID return in the First SQL query

3. Restart JIRA Software

[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 Jira Empty Backlog Even Though Issue Exist.