Restarting JIRA issue count

This is my first time using JIRA so I was testing out the different issues you can create and etc. After creating the issues I went ahead and deleted them to create other new issues in align with the project. The problem I am having is that the issue count is starting off from the last issue (DS10) instead of DS1. The count didnt reset after deletion of the test issues.

Could someone please walk me through resting the count? I saw few post on SQL queseries to reset the count but I am still very confuses on where to plug these queries in. I am not a global admin in JIRA if that changes anything.

2 answers

1 accepted

2 votes
Accepted answer

You can't do this in the UI, you have to either code something (script) or amend the database directly.SQL is probably the quickest and easiest approach, and it's one of the few relatively safe things to do in a Jira database.

If you're using Jira Cloud, you don't have a means to access the SQL database at all. 

However if you are using Jira Server, it might be possible to hack at the database to adjust this as described in the KB How to reset the project counter after moving issues.

thank you both for the quick responses and yes I am currently on the JIRA cloud service. So I guess the only option would be to deleting the project and restarting. 

Hi Everyone!


We are currently configuring the test project and now it is time to move it to an instant production, we import the system with the deleted incidents, but the account does not start at 1, could you indicate which would be the query to execute in the Micosoft SLQ database? server 2016 to reset the incident account?




Milena G

It's a column in the "project" table.  I can't remember the name off the top of my head, but it is pretty obvious when you look at it (Something like pcounter).

However, do not change it back to 0 without checking the other places the the issue key is used.  Specifically, in Jira without any add-ons, you need think about moved issues and all the text fields which might have had an issue key typed into them.  If you have any add-ons, you may need to consider their AO tables as well.

Hi @Nic Brough [Adaptavist]



at this time, the production site was installed and the idea now is to migrate all the configuration of the test instance, but without the incidents that were created from the tests, how could this process be carried out properly and that does not affect the configuration?



Jira does not have a way to carry configuration from one system to another, so it's either a large cup of coffee and a manual copying, or you can use one of the add-ons that can export and import config.

I'd use Project Configurator to get the configuration across from one system to the other.  I am biased on that one - I work with Pepe and the migration and development teams who are working with and on it, so it's the natural choice for me.  There are other options of course, and I am particularly fond of Bontron's Configuration manager if you want another opinion.



After importing with the add-on  Project Configurator, what is the script that must be run in the database (Microsoft SLQ server 2016 ) to resume the incident count?



It's a column in the "project" table.  I can't remember the name off the top of my head, but it is pretty obvious when you look at it (Something like pcounter).  Just set it to 0

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

808 views 3 9
Read article

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