more than one draft workflows associated with the workflow named

Question

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 com.atlassian.cache.memory.DelegatingCache$DelegatingLoadingCache.get(DelegatingCache.java:270)

at com.atlassian.jira.workflow.CachingDraftWorkflowStore.getDraftWorkflow(CachingDraftWorkflowStore.java:56)

at com.atlassian.jira.workflow.OSWorkflowManager.getDraftWorkflow(OSWorkflowManager.java:249)

at com.atlassian.jira.workflow.OSWorkflowManager.deleteDraftWorkflow(OSWorkflowManager.java:291)

at com.atlassian.jira.workflow.OSWorkflowManager.deleteWorkflow(OSWorkflowManager.java:501)

at com.atlassian.jira.bc.workflow.DefaultWorkflowService.deleteWorkflow(DefaultWorkflowService.java:190)

at com.atlassian.jira.web.action.admin.workflow.ListWorkflows.doDeleteWorkflow(ListWorkflows.java:114)

at sun.reflect.GeneratedMethodAccessor773.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70)

at webwork.util.InjectionUtils.invoke(InjectionUtils.java:56)

at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:438)

at webwork.action.ActionSupport.execute(ActionSupport.java:157)

at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:88)

at webwork.interceptor.DefaultIntercep

BenP · Answer

It's happened to me a couple of times as well..

I would attempt the following:

* Export the problematic workflow
* Import it again using a new name
* Replace the old workflow with the new one in the active schemes
* Delete the old workflow

Hope this helps.

In case you can recreate the same problem again, open a support request with Atlassian & submit the steps to reproduce.

Cheers,

Ben

Vasiliy Zverev · Answer

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()))

Paul Richardson3 · Answer

Vasiliy, if I do find a record with a count > 1 is it safe to get rid of that record ?