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; } } }

Reset the Issue Sequence to 0 in Jira 4.4.5

Harish19

Hi,

We have deleted all the issues created in Jira. And now we would like to start afresh.

But then when i try to create an issue, the Issue Key takes the next sequence number instead of 1.

We want the issues to start with 1 now again after cleanup.

Is there a way to re-set the sequence to 1.?

Please let me know, its pretty urgent.

Thanks,

Harish

Accepted answers

Nic Brough -Adaptavist-

Delete the project and re-create one with the same key. You'll need to re-apply all the schemes and users in the new project.

All comments

Nic Brough -Adaptavist-

Delete the project and re-create one with the same key. You'll need to re-apply all the schemes and users in the new project.

Harish19

Hi Nic,

Thanks for the response.

But it is very tedious process to delete all projects and re-create them . And more over assigning the users to each project takes more time.

May i know if there is any other workaround may be setting some configuration file.

Please advice.

Thanks,

harish

Nic Brough -Adaptavist-

No. There's no other way in the UI.

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.

But, with SQL, there is no easy option - you have to stop Jira, get a backup of the database, prove it's a good backup, run the SQL, then restart Jira and re-index. (If you are only changing the counters in the project table, you do not need to re-index, unless you've got plugins that may be storing extra data about your projects)

Harish19

Hi Nic,

Thanks a lot for the response.

It really worked for me.This was very helpful.

Thanks,

Harish.

Jason Rogers

I know I am 6 years late with my answer... but I am going to give it anyway. When I needed to reset my projects issue key, I cloned the project and gave the clone a different name/key. Checked all the notification scheme, screen scheme, workflow conditions/post actions etc copied over, then deleted the original and gave the clone the original project name/key. Worked fine. Took 5 mins. Merry Christmas. J

jvl_share

Thanks Jason for your comment, it helped me.

David Valle_4g8p3q

thanks jason

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

issue

jira

key

reset