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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,183 views 13 19
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot