Workflows not showing up both Active and Inactive

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.”

3 answers

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.

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.

Great! Can you please mark my answer as accepted?

Hello Teju,

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

Please help. Thank you smile



Hi Edgar,

First you're gonna have to enter into the database, I mean in which database JIRA was hosted.

Second you have to search duplicate workflow by exicuting this query [ SELECT * FROM jiraschema.jiraworkflows; ] on top of the table you will find the IDs i.e workflow ids.

Third delete the workflow using query [ DELETE from jiradraftworkflows where id = 12345; ]  

12345 is your workflow ID.

Prior to that stop JIRA services.


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



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.


  1. 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;
  2. 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>;
  3. Restart JIRA.
  4. Run a re-index of your instance.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,793 views 18 22
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you