How do I delete or reuse the project key?

This question is in reference to Atlassian Documentation: Editing a project key

I ran into a problem were I composed a project which created the project key I had also changed the key. I need to delete the project key associated with this project the reason being I had to create another project with identical name but the project key was conflicting as it said I was trying to use the project key that already existed. Any help with this?

2 answers

This widget could not be displayed.

I'm afraid Ravi's answer here is not correct.

Any project keys you create are recorded and kept for historical reasons.  JIRA will prevent you from creating a project with an existing key, that makes perfect sense, as you already have a project with that key. 

But it will still prevent you from using a key that existed before, even if you change the project key or even delete the original project.  It needs a record of removed projects for the history search, so it stops you creating projects with keys that have existed before.

The only workaround is to go into the database and remove the old project key from the table it is stored in.  That is only safe to do if you have never created any issues in the dead project, or you have deleted all of the issues that have ever been in it, remembering that it is possible to move issues out of a project and into another one.  If you have moved issues out, there's another table you can remove records from, but that does break the history search.

That's true - the doc is fine for telling you how to change a key, but doesn't make it clear that there's a "hang over" of some data.

The only workaround is to go into the database and remove the old project key from the table it is stored in.

Seems like that my first-choice database place for keeping the old key (project_key table, project.originalkey field) is not the right place to look for.

Additional ref:https://jira.atlassian.com/browse/JRA-34945

Correct, it's completely the wrong place.

This widget could not be displayed.

Anandan,

The old project key will be freed only when you delete the old project.

Ravi

Confirmed this does work. If the prior project using key = PROJECTX is Deleted, all issues etc. then the key can be reused for a new project. 

If PROJECTX is simply rekeyed to, say, PROJECTZ the PROJECTX key will still be attached to the issues. You can run a JQL query "Project = PROJECTX" and it will return a list of issues still associated with the PROJECTX key. 

Tested this a couple of times as it is good to know. We could not find clear documentation on this either.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

216 views 3 0
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