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

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

Accepted answers

Jobin Kuruvilla [Adaptavist]

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

All comments

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.

Jobin Kuruvilla [Adaptavist]

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

Tomasz Nowodziński

Great, it works.

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

Welcome!

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

Quick Links

Find more posts tagged with

jira