Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-13557

Unable to delete/reopen orphan sprint

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Low Low (View bug fix roadmap)
    • None
    • 2016-04-18 Cloud
    • None
    • None

      Summary:
      Users are not able to reopen a sprint when its original board does not exist anymore (with or without tickets on it).

      Steps to Reproduce:

      1. Create a Scrum board/project
      2. Start a sprint ("Sprint A")
      3. Delete/Remove all tickets from this sprint
      4. Delete the board/project
      5. Create another board/project
      6. Add this sprint into the board/project (via board filter)
      7. Try to delete/reopen the sprint (via Sprint Report)

      Expected Results:
      The report should show-up the sprint ("Sprint A") with option to reopen it.

      Actual Results:
      Nothing shows up on the report related to this sprint. Even though the sprint is still available on JIRA (search issues page).

      Workaround:
      For JIRA Server, users can manually delete this entry from the database. For Cloud customers, please raise a support ticket with us.

      • Find the sprints you have: 
        select * from "AO_60DB71_SPRINT";
      • Delete the sprint: 
        DELETE FROM "AO_60DB71_SPRINT" where "ID" = <SPRINT-ID>;

      Affects Version:
      JIRA SW 7.2.0-OD-05-030
      JIRA Agile v7.2.6-D20160330T044439

          Form Name

            [JSWSERVER-13557] Unable to delete/reopen orphan sprint

            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2851072 ] New: JAC Bug Workflow v3 [ 2934176 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v7 - Restricted [ 2543750 ] New: JAC Bug Workflow v2 [ 2851072 ]
            Ignat (Inactive) made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - Restricted [ 1552204 ] New: JIRA Bug Workflow w Kanban v7 - Restricted [ 2543750 ]
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 1304156 ] New: JIRA Bug Workflow w Kanban v6 - Restricted [ 1552204 ]
            Kiran (Inactive) made changes -
            Resolution New: Duplicate [ 3 ]
            Status Original: Open [ 1 ] New: Resolved [ 5 ]
            Kiran (Inactive) made changes -
            Link New: This issue is duplicated by JSW-11263 [ JSW-11263 ]
            Elisa [Atlassian] made changes -
            Affects Version/s New: 2016-04-18 Cloud [ 61704 ]
            Elisa [Atlassian] made changes -
            Description Original: *Steps to Reproduce:*
            # Create a Scrum board/project
            # Start a sprint ("Sprint A")
            # Delete/Remove all tickets from this sprint
            # Delete the board/project
            # Create another board/project
            # Add this sprint into the board/project (via board filter)
            # Try to delete/reopen the sprint (via Sprint Report)

            *Expected Results:*
            The report should show-up the sprint ("Sprint A") with option to reopen it.

            *Actual Results:*
            Nothing shows up on the report related to this sprint. Even though the sprint is still available on JIRA (search issues page).

            *Workaround:*
            For JIRA Server, users can manually delete this entry from the database. For Cloud customers, please raise a support ticket with us.

            *Add-on Version:*
            JIRA SW 7.2.0-OD-05-030
            JIRA Agile v7.2.6-D20160330T044439             		New: *Summary:*
            Users are not able to reopen a sprint when its original board does not exist anymore (with or without tickets on it).

            *Steps to Reproduce:*
            # Create a Scrum board/project
            # Start a sprint ("Sprint A")
            # Delete/Remove all tickets from this sprint
            # Delete the board/project
            # Create another board/project
            # Add this sprint into the board/project (via board filter)
            # Try to delete/reopen the sprint (via Sprint Report)

            *Expected Results:*
            The report should show-up the sprint ("Sprint A") with option to reopen it.

            *Actual Results:*
            Nothing shows up on the report related to this sprint. Even though the sprint is still available on JIRA (search issues page).

            *Workaround:*
            For JIRA Server, users can manually delete this entry from the database. For Cloud customers, please raise a support ticket with us.

            - Find the sprints you have:
            {code:sql}select * from "AO_60DB71_SPRINT";{code}

            - Delete the sprint:
            {code:sql}DELETE FROM "AO_60DB71_SPRINT" where "ID" = <SPRINT-ID>;{code}

            *Affects Version:*
            JIRA SW 7.2.0-OD-05-030
            JIRA Agile v7.2.6-D20160330T044439
            Elisa [Atlassian] created issue -

              Unassigned Unassigned
              ediel Elisa [Atlassian]
              Affected customers:
              1 This affects my team
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: