As an Admin I want the Sprint Marker Migration to check for orphaned boards

Due to GHS-6706 it is possible for orphaned boards to exist and as such the sprint marker migration banner cannot be easily removed as it will continue to popup for orphaned boards that cannot be accessed.

Please ignore boards that have orphaned filters as they cannot be accessed to be migrated and remove the banner.

Workaround

This workaround means if the boards filter is ever restored it will not have the sprint markers migrated. If this is the case simply reverse the process below.

1. Backup JIRA.
2. Stop JIRA.
3. Identify boards with the below SQL:

   SELECT *                                                                                                                                                                FROM "AO_60DB71_RAPIDVIEW" rv                                                                                                                                                     LEFT JOIN searchrequest sr ON rv."SAVED_FILTER_ID" = sr.ID                                                                                                                        WHERE sr.ID IS NULL;
   

4. Update the boards manually to appear as if they have been migrated with the following:
   PosgreSQL:

   UPDATE "AO_60DB71_RAPIDVIEW"
   SET "SPRINT_MARKERS_MIGRATED" = 't'
   WHERE "ID" in (<ids from step 3>);
   

   Oracle:

   UPDATE "AO_60DB71_RAPIDVIEW"
   SET "SPRINT_MARKERS_MIGRATED" = 1
   WHERE "ID" in (<ids from step 3>);
   

5. Start JIRA and verify if the banner is gone.