JIRA Agile Documentation

Jira Agile 6.3
GreenHopper 6.2
GreenHopper 6.1

More...

Agile Knowledge Base Resources

Skip to end of metadata
Go to start of metadata

Symptoms

It is currently not possible to rename a closed Sprint. In case you need to rename a closed Sprint, there are a couple ways to go about it. See below for examples.

The information contained in this KB does not apply to JIRA Cloud.

 

Resolution

Method 1:

(info) This method is preferred since there is no need to restart JIRA.

  • Determine the <Sprint ID> that needs to be renamed by going to an issue that has been assigned to the sprint and highlight over the Completed Sprint section: <sprint name>. Look at the link that appears in the lower left hand of the browser and the sprint number is the sprintID at the end of the URL string. Alternatively, use the browsers developer tools to inspect the attribute value, as seen here:

  • Use JIRA's REST API to update the Sprint name, either using curl via the command line or a browser extension. Examples below:

    JIRA Server
    curl -u admin:admin 'http://localhost:8080/623/rest/greenhopper/1.0/sprint/<SprintID>' -X PUT -H 'Accept: application/json' -H 'Content-Type: application/json; charset=UTF-8' --data '{"name":"Sprint1 - Renamed","startDate":"06/Apr/14 8:00 PM","endDate":"06/Apr/15 8:00 PM"}'
     

     

     

Method 2:

(warning) This method involves direct database manipulation. Please backup JIRA database prior to making any changes at this level.

  • Run the following SQL against JIRA database to fetch all closed Sprints:
select * from "AO_60DB71_SPRINT" where "CLOSED" = 't';
  • Shutdown JIRA
  • Update the NAME column for the Sprint you wish to rename.
  • Start JIRA
Help us improve!

  • No labels

7 Comments

  1. How can I do this without a DB query? I.e. see the list of names, rename them...

  2. Hi,

    I'm getting 403 - Forbidden while trying to use REST approach to rename old sprints.

    I'm using PUT method and the same message as described above.

    We are using JIRA Agile 6.6.41

    Any ideas?

    1. Found the problem. At least for the version we have the URL to be used is:

      https://jira.example.com/rest/greenhopper/1.0/sprint/{sprintID}

      and not 

      http://localhost:8080/623/rest/greenhopper/1.0/sprint/4

       

  3. Any chance this functionality will be moved into the User Interface in the future? It is entirely too easy to mess up the name/date and realize after it's closed.

  4. To generate the final project reports it would be good to be able to rename old sprints to a common nomenclature.

    But what I've got using the curl approach was: {"errorMessages":["Cannot update closed sprint"],"errors":{}}

    Using JIRA v6.3.15 + JIRA Agile v6.7.11

    Is that because I was using project admin credentials or it just no longer works with newer JIRA versions?

  5. For me the same and it worked some month ago. I read elsewhere that it does not work any more with current JIRA versions.

  6. I experienced the same error as Gabriel.

    When I ran the curl command on a test server which had JIRA Agile 6.7.7 installed I was able to rename closed sprints, but running the same command on a Production instance with JIRA Agile 6.7.11 installed I received the error.

    To workaround this I removed the 6.7.11 plug-in (all the settings are retained) and installed 6.7.7 manually via the jar file.

    I was then able to rename closed sprints via the curl method.

    Once I had finished updating all of the sprint names, then updated the plug-in back to version 6.7.11 via the automatic installer.