Raise project counter from 100 to 7000

Question

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 Answer

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)