topic Re: Rewind deployed processes in Alfresco Archive

Rewind deployed processes

edoshor — Thu, 15 Nov 2012 13:56:52 GMT

Hi,We've suffered from automatic re deployments of our processes (http://jira.codehaus.org/browse/ACT-736) for quite a while now.We plan to fix that by migrating to 5.10.We fear of slow queries due to tables loaded with needlessly duplicate and irrelevant process definitions.Is it possible to "colla

Re: Rewind deployed processes

jbarrez — Thu, 15 Nov 2012 19:15:44 GMT

How many process definitions are we talking about?

You can easily delete deployments through the repositoryService. When doing so, it will cascade to all involved data.

Re: Rewind deployed processes

edoshor — Sun, 18 Nov 2012 07:32:13 GMT

We've 3 process definitions over all.

No. I don't want to delete any instances or history.
We've ~2500 historic process instances spread over ~100 re deployments of the same process definition.
We would like to do something in order to make them belong to the same, single process definition.

We don't expect anything like this in the API. We are willing to write some code to do this.
We're concerned if its even possible and if so what we have to do.

Re: Rewind deployed processes

jbarrez — Mon, 19 Nov 2012 10:37:15 GMT

You could choose not to cascade when you delete a deployment. That keeps the history intact.

You will need some SQL magic queries to do it. Like with code, nothing is impossible. But the schema is not that difficult, and has no foreign keys, so it should be doable.