Undeploy a Process Definition

[rand]

Hi there !

A fairly simple question : how can an administrator delete a Workflow Definition once it has been deployed ? I haven't seen any command to do that through the Workflow Console (although you can delete all the instances of a workflow definition), and I end up with an (obsolete) test definition showing up in the list everytime I start a Workflow.

Thanks in advance.

Rand

PS : A quick suggestion, shouldn't a "Workflow" category be created in the forum ? No one really seems to know where to post such questions.

[pcuvecle]

Thanks for the link, the help page included in Alfresco is not up to date.
However, I managed to undeploy 1 workflow definition but for another one it fails with a constraint violation error :

java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`alfresco/JBPM_TRANSITION`, CONSTRAINT `FK_TRANS_PROCDEF` FOREIGN KEY (`PROCESSDEFINITION_`) REFERENCES `JBPM_PROCESSDEFINITION` (`ID_`))

I had no running workflows of any type of definition when I ran this undeploy command  :?

[rob562435]

That sounds familiair. For some reasons sometimes the database seems to become corrupt with respect to the workflow definitions. Could not figure this one out myself…. If you are in a test environment you could delete all by restarting Alfresco with a new (read empty) database.
For this purpose I created a backup of the database after I initiated all users I needed in my test environment and all Spaces that are always required.

Sorry, somehow you can not come around this one as far as I know. Did not put it in Jira yet since I was not sure whether it was caused by my doing or by Alfresco. But since you have the same problem it is no longer an incident.

Did you try the "undeploy definition name <workflowName>" version to undeploy all at once and did it has the same result?

Rgrds, Rob

[pcuvecle]

Did you try the "undeploy definition name <workflowName>" version to undeploy all at once and did it has the same result?
Rgrds, Rob

Yes I tried with undeploy definition name <workflowName> and undeploy definition <workflowId> on the last version and i get the same result for both.

[rob562435]

So this seems to be some bug in the way that the definitions are handled.
Wonder whether some Alfresco engineer is reaing this thread… 😞
Since it is hard to predict what and when things go wrong it is hard to put it in an issue to be solved…

Regards, Rob