Hi, I have imported bugs from bugzilla into a new jira project. Now I would like to change the issue keys to make them the same as the bugs ids in bugzilla. Here's what I did on a test instance: * Stop Jira * Update the column ISSUENUM in the table JIRAISSUE * Update the column PCOUNTER in the table PROJECT * Start and reindex Jira It seems to work perfectly, but before I do that in my production instance, I would like to be sure that it won't have side effects. Did anybody already try to update the column ISSUENUM? I am Using Jira 6.1 with Oracle.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Change Issue keys

Pierre Cattin

Hi, I have imported bugs from bugzilla into a new jira project. Now I would like to change the issue keys to make them the same as the bugs ids in bugzilla. Here's what I did on a test instance:

Stop Jira
Update the column ISSUENUM in the table JIRAISSUE
Update the column PCOUNTER in the table PROJECT
Start and reindex Jira

It seems to work perfectly, but before I do that in my production instance, I would like to be sure that it won't have side effects. Did anybody already try to update the column ISSUENUM?

I am Using Jira 6.1 with Oracle.

Accepted answers

Pierre Cattin

The only problem we got was the link between issues and attachments. The attachment location depends on the issue key. Therefore if you manually change issue keys, the attachments are not reachable from an issue. To fix this we had to write a batch file to reorganise the structure of our attachment directory.