症状

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

診断

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

         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

         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

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

      4. 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

原因

The default Sprint used for default has been changed.

ソリューション