How to increase ticket sequence

[Tomasz Nowodziński]

Hi all,

I going to migrate our tickets from old system, but before this I want to normally use Jira.

I think about:

increase "ticket number sequence" to value greater of existing number from old system
start new tickets from this value
prepare migration procedure
migrate old tickets

I tried to change project.pkey value in DB, but it doesn't give effect. After change to '3000' my new ticket have number +1 from the previous one. I also tried to change project.pkey AND pkey of the last ticket in my project in jiraissue table - also without result.

Is there any possibility to do this with MySQL backend?

Bests,

Tomek

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

What you need to update is project.pcounter. And ofcourse restart JIRA because it is cached as Nic suggests.

[Nic Brough -Adaptavist-]

Did you stop Jira before making the sql change? It caches a lot of stuff, including the project counter, so if you didn't stop and restart, you could have broken it.

[Tomasz Nowodziński]

Great, it works.

I thought, that changing values with running Jira should work. Thanks a lot.