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

Error adding statuses or columns to Agile Simplified Workflow

Robert Schroede2

I've created a new project and converted it to use the Agile Simplified Workflow and be managed by JIRA Agile.

When I try to add columns or statuses, I'm getting this error:

org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][id,10004][sequence,17][description,This status is managed internally by JIRA Agile][name,Being Built][statuscategory,1][iconurl,/images/icons/subtask.gif] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus"))

It's the same error whether I'm trying "Add Status" or "Add Column". It's happening when using both Safari and Chrome.

Any ideas, please?

Accepted answers

cgauterio

Hey everybody,

This is happening due to the following bug report: JRA-35857

If you have an OnDemand instance, please raise an issue with us and we can apply the fix for you!

Cheers,

Clarissa.

All comments

Matheus Fernandes

Take a look in this KB: Duplicated Entry - Unique Constraint Violated

Matheus Fernandes

Try the following:

Create an XML backup of JIRA (always do that before modifying the database!);
Shutdown JIRA;

Run the following update against the database:

update SEQUENCE_VALUE_ITEM 
set seq_id = (SELECT max(id::integer)+1 FROM issuestatus) 
where seq_name = 'Status';

Restart JIRA and try to add it again.

Matheus Fernandes

Try the following:

Create an XML backup of JIRA (always do that before modifying the database!);
Shutdown JIRA;

Run the following update against the database:

update SEQUENCE_VALUE_ITEM 
set seq_id = (SELECT max(id)+100 FROM issuestatus) 
where seq_name = 'Status';

Restart JIRA and try to add it again.

Robert Schroede2

Thanks, Matheus. But we've got an OnDemand account. Is this something we can actually do? If so, could you direct me to directions on how to access the database like this? (Apologies for my ignorance!)

heidless

Hi, I'm experiencing the same thing. Newly created board using Simple Workflow. Attempting to add a status fails with the same exception as above.

Am using OnDemand. What are my options?

I actually would prefer to primarily use statuses that already exist but only small subset seem available within JIRA Agile board though many more listed under overall status configs.

Am new to JIRA. Been browsing through many docs so far.

Any tips or pointers to docs?

Many thanks - Rob

Error

org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][id,10003][sequence,23][description,This status is managed internally by JIRA Agile][name,qqq][statuscategory,1][iconurl,/images/icons/subtask.gif] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus"))

</fieldset></form>

<button class="button-panel-button aui-button" style="background-image: linear-gradient(#ffffff 0px, #f2f2f2 100%); border: 1px solid #cccccc; border-top-left-radius: 3.01px; border-top-right-radius: 3.01px; border-bottom-right-radius: 3.01px; border-bottom-left-radius: 3.01px; color: #333333; cursor: pointer; height: 2.1428571428571em; line-height: 20px; margin: 0px 10px 0px 0px; padding: 4px 10px; text-shadow: white 0px 1px 0px; vertical-align: baseline; white-space: nowrap;">Add</button>Cancel