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

Regards,

Edgar

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.

Thanks


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

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.

 

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

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

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

    1
    SELECT count(*), workflowname FROM jiraworkflows group by workflowname having count(*) > 1;
  2. Delete one of the Id which have the same parentname.

     
    1
    SELECT id, parentname from jiradraftworkflows;
    2
    DELETE from jiradraftworkflows where id = <chosen_id_with_duplicated_parentname>;

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

    1
    SELECT id,workflowname FROM jiraworkflows;
    2
    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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Posted 13 hours ago in Jira

We want to know what Jira Service Desk apps you're using!

Hi Community! My name is Amir and I’m on the Jira Service Desk product marketing team at Atlassian. Our team would love to understand how you’re leveraging our ecosystem for Jira Service Desk. Wha...

36 views 0 5
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