Issue Key Reset

Can I reset the Issue Key for a given project, so that it starts from xxx-1?

7 answers

1 accepted

This widget could not be displayed.

I have used this procedure several times and it does the job!

(https://confluence.atlassian.com/pages/viewpage.action?pageId=211649701)

But I usually discourage my customers to do this because I think that when you have to rely on what number an issue gets your process is wrong. That should be totally irrelevant because you will always end up with special cases to maintain this requirement. Better to take that off the table from start.

I have come across one use-case when I thought it was relevant though. I had a customer with a incident reporting system in Excel (common case ;-) and the existing incidents were already given id's in a sequence. They wanted to migrate this to JIRA without changing the numbering (there were many references to these reports in other systems)

When we had created the JIRA project and tried all the scenarios the pcounter was 134. If we would have imported the spread-sheet at this time the numbering would not have been preserved. So we deleted all test-issues in the project and followed the procedure described in the documentation and when we imported the spread-sheet all existing incidents reports got their correct numbering and all refereces were intact.

In conclusion: If you have built-in values in the numbering in your JIRA project, try to remove that requirement and see the key for what it is, a unique identifier without any value. This is a more maintainable and less complex approach.

If you have specific reasons (e.g. historical) you can move on with the procedure to reset the counter, just make sure you delete all issues in the project before and that you re-start your instance afterwards.

My 2 cents to this topic!

//Svante

This widget could not be displayed.

To save you some reading.

No, you can't reset the key. Unless you delete the project completely and re-create it, or start mucking around in the database (delete all issues in the project, stop Jira, backup, change the counter on the project table with a spot of SQL, restart it)

We cannot reset the numbering through the user interface.

You can do it directly in the database. This particular SQL is relatively simple and safe compared with other things people make a mess of with SQL - you set the pcounter on each project you need to reset in the "projects" table.

Steps:

Stop the jira --> Take database backup --> run the sql --> Reindex the jira.

This widget could not be displayed.

Unfortunately there does NOT seem like a way to do this for JIRA Cloud sad

 

Really would love to be able to do this. Can Jira from their end reset in cloud?

In theory, yes, but I don't think they do it in practice. 

Raise a support request at https://support.atlassian.com/contact and see what the response is.

This widget could not be displayed.

Thanks for all of your answers, much appriciated.

This widget could not be displayed.

Hello,
    This thread is a bit old but this KB is new and may help someone.
    https://confluence.atlassian.com/display/JIRAKB/How+to+reset+the+project+counter+after+moving+issues

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

174 views 1 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you