As the title indicates, when trying to delete a workflow named "Project Tracker Test Workflow V2.0" I get an error as show below. Note that I have purged the system of all inactive workflow schemes,and inactive workflows. I have reindexed the system and run the integrity checker as well. I cannot seem to find this offending workflow anywhere. Any guidance would be helpful
com.atlassian.cache.CacheException: java.lang.IllegalStateException: There are more than one draft workflows associated with the workflow named 'Project Tracker Test Workflow V2.0'
at sun.reflect.GeneratedMethodAccessor773.invoke(Unknown Source)
It seems to be a hardcore question.
Here is an SQL statement to get count of draft workflows. Try to execute it and find any records where count > 1
Select jiraworkflows.workflowname , count (jiraworkflows.workflowname) from jiraworkflows join jiradraftworkflows on jiraworkflows.workflowname = jiradraftworkflows.PARENTNAME group by jiraworkflows.workflowname order by count (jiraworkflows.workflowname) desc
Here is a script to delete a draft workflow related to spesified WF name.
I recommend to run it first on test instance becauce it is a not standart case.
import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.workflow.JiraWorkflow import com.atlassian.jira.workflow.WorkflowManager /** * Delte draft workflow */ WorkflowManager workflowManager = ComponentAccessor.getWorkflowManager() JiraWorkflow workflow = workflowManager.getWorkflow(workflowManager.getWorkflow("WorkflowName")) workflowManager.deleteWorkflow( workflowManager.getDraftWorkflow(workflow.getName()))
It's happened to me a couple of times as well..
I would attempt the following:
Hope this helps.
In case you can recreate the same problem again, open a support request with Atlassian & submit the steps to reproduce.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG