How to change projectKey if before this key was used by other project

Alexander Yu

Hello!

I have project with

SSD key name "SSD private project" 

SDD key name "SSD public project"

And I shuld change keys:

SSD -> SSDP

SDD -> SSD

First (SSD -> SSDP) was sucsessfully changed re-indexed, but the second (SDD -> SSD) not changed. I have error message: Project 'SSD private project' uses this project key.  But it's impossible I changed this project key.

After restart JIRA have the same situation.

What should I do?

 

Vasiliy Zverev

All project keys are stored into table project_key. Use this SQL to get a record for requared project key:

select
	project_key.*
from
	project_key
where
	project_key.PROJECT_KEY = 'ED'

The you need to delete this record. Be very careful when delete somethink via SQL.

ATTENTION:

1. MAKE A BACK UP OR TRY THIS ON TEST JIRA INSTANCE FIRST
2. DO NOT DO ANY DELETE FROM DATABASE IF YOU ARE NOT SURE WHAT ARE YOU DOING