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

Workflows not showing up both Active and Inactive

Teja

Jira System administration -->Issues --> Workflows, when I click on workflows and when the page loads, all of the workflows are missing. the projects are working correctly, but I cannot see or edit them.

the error received is “The JIRA server was contacted but has returned an error response. We are unsure of the result of this operation.”

Accepted answers

All comments

Andrea Carl_fjmjbu

Check your version/browser compatability. For example, IE9 is not compatable with Cloud.

Petar Petrov _Appfire_

This could happen if a "broken" workflow has somehow ended up in the database. Check the atlassian-jira.log file - there should be an error with more information.

Teja

Hi Petar,

Thanks for your comment.

java.lang.IllegalStateException: There are more than one workflows associated with 'Dply V1' in the database!

I Tried these steps in my jiradatabase

Step 1: Searched all workflow in JIRA by executing this query

SELECT * FROM jiraschema.jiraworkflows;

and found duplicate workflow.

Step2: Deleted duplicate workflow by getting id

DELETE from jiradraftworkflows where id = 13125;

It worked well.

Petar Petrov _Appfire_

Great! Can you please mark my answer as accepted?

unknown

Hello Teju,

I'm having this same problem. How can I know what workflow needs to be deleted?

Please help. Thank you smile

Regards,

Edgar

unknown

Resolution

Always back up your data before performing any modifications to the database. If possible, test any insert, update, or delete SQL commands on a staging server first.

Run the following SQL query on the database (to identify the drafts with more than one entry):

SELECT count(*), parentname FROM jiradraftworkflows group by parentname having count(*) > 1;

For the workflows(not draft), run the following query :

SELECT count(*), workflowname FROM jiraworkflows group by workflowname having count(*) > 1;

Delete one of the Id which have the same parentname.

SELECT id, parentname from jiradraftworkflows;

DELETE from jiradraftworkflows where id = <chosen_id_with_duplicated_parentname>;

For the workflows(not draft), run the following query :

SELECT id,workflowname FROM jiraworkflows;

DELETE from jiraworkflows where id = <chosen_id_with_duplicated_workflowname>;

Restart JIRA.
Run a re-index of your instance.

Welcome!

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

Quick Links

Find more posts tagged with

jira

adaptavist

workflow