topic Re: Undeploy a Process Definition in Alfresco Archive

Undeploy a Process Definition

rand — Fri, 03 Nov 2006 16:22:41 GMT

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 definit

Re: Undeploy a Process Definition

davidc — Fri, 03 Nov 2006 16:41:24 GMT

Oh that's annoying. Undeploy has been left out of the Workflow Console by mistake. I thought I'd added that one.

I'll raise a JIRA issue.

Don't know if you want to dive into Java, but there is a WorkflowService.undeployDefinition() method that can be called.

A sneaky workaround might be to install the JBoss jBPM starterkit, point it at the Alfresco database, and use its web console to undeploy.

As for the Workflow forum, others have asked too, so I think it's time to add one.

Re: Undeploy a Process Definition

davidc — Fri, 03 Nov 2006 17:03:19 GMT

http://issues.alfresco.com/browse/AR-1072

Re: Undeploy a Process Definition

rand — Mon, 06 Nov 2006 08:32:33 GMT

Thanks for the answer and the JIRA issue, the workaround will do allright in my case.

Rand

Re: Undeploy a Process Definition

pcuvecle — Thu, 13 Dec 2007 18:12:32 GMT

Quite an old post now, but i tried to plug the jbpm-console webapp on the JBPM tables used by Alfresco but when I try to login to the web app, a login / password is required.

Does anybody has an idea about the login / password that can be used ?

Regarding Jira AR-1072, what is the undeploy command syntax ? It does not appear in the command list returned by the workflow console help

Re: Undeploy a Process Definition

Anonymous — Fri, 14 Dec 2007 07:56:37 GMT

Try the "admin" account!

Rgrds, Rob

Re: Undeploy a Process Definition

pcuvecle — Fri, 14 Dec 2007 08:56:09 GMT

It does not work with the admin account (I try to logon to the jbpm-console webapp not the alfresco one)

Re: Undeploy a Process Definition

Anonymous — Fri, 14 Dec 2007 08:59:15 GMT

Why not use the Workflow Console from Alfresco itself? It now has the undeploy functionality the original post was complaining about.

Sorry, I have no other suggestion, Rob

Re: Undeploy a Process Definition

pcuvecle — Fri, 14 Dec 2007 09:11:48 GMT

Sure it would be easier
But i've been unable to figure out how to use the undeploy function from the workflow console (not in the help command list)

In another hand I wanted to have a look at the jbpm workflow console features to see if there are some usefull stuff that could help manage Alfresco workflows more easily

Re: Undeploy a Process Definition

Anonymous — Fri, 14 Dec 2007 09:20:03 GMT

Take a look at: http://wiki.alfresco.com/wiki/Workflow_Console
The "undeploy" command is described here. Be aware that when you undeploy the latest definition the previous definition becomes active and so on. According the WIKI starting with version 2.1 all definitions can be undeployed at once (I did not try that one yet).
Use "show definitions" to look up the definition ID needed to undeploy.
Be also aware that as long as you automatically deploy on starting Alfresco your workflow will re-appear.

Rgrds, Rob

Re: Undeploy a Process Definition

pcuvecle — Fri, 14 Dec 2007 10:04:39 GMT

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 :?

Re: Undeploy a Process Definition

Anonymous — Fri, 14 Dec 2007 10:13:00 GMT

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

Re: Undeploy a Process Definition

pcuvecle — Fri, 14 Dec 2007 11:20:15 GMT

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.

Re: Undeploy a Process Definition

Anonymous — Sun, 16 Dec 2007 15:42:05 GMT

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