Raise project counter from 100 to 7000

[Benjamin Mahler]

Hi,

in our new Jira enviroment we d like to start the projekt counter where to old one stopped.

For example: The last Ticket key in the od Jira setup is XXX-6580. In our new Jira we d like to start with XXX-7000 and not again with XXX-. Is there a possibility to raise the projekt counter to 7000?

To create 7000 Tickets manually and delete them afterwards is not an option :)

Greetings

Benjamin

[Nic Brough [Adaptavist] · Accepted solution]

Two basic options:

1. Create lots of issues and delete them. Not manually, but a CSV import, or a simply Jelly script would be easy to generate in a spreadsheet to create them, and bulk-edit to delete. If you've got the script-runner plugin, that could be used to do it as well.

2. Stop Jira, take a backup of the database, change the field "pcounter" on table "project" and restart Jira. (This will NOT work if Jira is running, you must stop it)

[Benjamin Mahler]

Hi Nic,

thanks for the quick reply! We are going with option 2.