Empty Backlog Even Though Issue Exist

Summary

Symptoms

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

Diagnosis

1. Sprint field is applicable in Global Project and Issue Type

2. Total number of issues are shown via Tools > Configure > Columns

3. In the database, run following queries:

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

         1 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. check if issue has value in this custom field

         1 select * from customfieldvalue where customfield=<Customfield_ID>;

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

      3. check if there any Sprint type customfield

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

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

         1 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

Cause

The default Sprint used for default has been changed.

Solution

Resolution

1. Backup Jira database

2. Update database manually

   1 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