topic Re: about the process instance business key in Alfresco Archive

about the process instance business key

heymjo — Tue, 22 Nov 2011 10:02:13 GMT

Hi,I think that the business key concept in Activiti needs to be clarified. Currently there are 2 restrictions in Activiti with regards to this key AFAICT:1) there cannot be 2 active process instances with the same business key:alter table ACT_RU_EXECUTION add constraint ACT_UNIQ_RU_BUS_KEY un

Re: about the process instance business key

trademak — Wed, 23 Nov 2011 12:45:02 GMT

Well, we've chosen to implement it in a flexible way in the API, but with restrictions in the database.
You're right that probably a check should be done if the business key is already available in the history table.
Most users don't pass along a self-generated business key, but let Activiti choose one. Then it's working fine.

Best regards,

Re: about the process instance business key

ronald_van_kuij — Wed, 23 Nov 2011 18:40:38 GMT

I disagree. What is the advantage of having an Activiti generated businesskey if there are other fields to use that are generated by Activiti like process instance id.

The unique constraint does not add anything in most cases and limits a lot in many… What is the problem with dropping the unique constraint. Everything seems to be still working correctly.

Re: about the process instance business key

heymjo — Thu, 24 Nov 2011 09:32:55 GMT

Hi,

We removed ACT_UNIQ_HI_BUS_KEY and everything seems to be working still. I don't think there are assumptions in the Activiti code on ACT_UNIQ_RU_BUS_KEY, but i'm not sure. I will create a few unit tests and see.

Re: about the process instance business key

heymjo — Fri, 25 May 2012 11:42:38 GMT

created http://jira.codehaus.org/browse/ACT-1230 for this.

Re: about the process instance business key

funvin — Wed, 07 Jan 2015 22:50:10 GMT

I see ACT-1230 and it's dupe ACT-997 closed as won't fix, but for my current version of activiti (5.16.4), I don't see ACT_UNIQ_RU_BUS_KEY constraint on ACT_RU_EXECUTION table. Was this constraint dropped in any of the previous releases? What was the motivation behind it?

I think having this constraint helps in ensuring we don't end up with duplicate process instances in a distributed environment. It is possible to use some kind of distributed locking mechanism when creating process instances to ensure uniqueness and avoid race conditions, but that's complicated. Having business key as unique makes it so much more easier.

Is there any other way to achieve this?

_vinay_ @ zulily

Re: about the process instance business key

trademak — Thu, 08 Jan 2015 13:04:48 GMT

Hi,

Yes the constraint was dropped. The reason was that there are some cases where the business key is not unique and some cases where you would like it to be unique. So we decided to drop the constraint, because you can always add the constraint manually or do an additional query before creating a process instance.

Best regards,

Re: about the process instance business key

funvin — Thu, 08 Jan 2015 20:12:59 GMT

The problem with doing additional query is, there is no way to avoid race condition in a distributed environment without using distributed locks. I can add the constraint, but I am always wary of changing something I don't own and control. If in the future someone upgrades our version of activiti, the constraint could be dropped again.

So the new semantic of business key is just that it provides domain specific way of efficiently querying (cause it's indexed) the workflow process?

_vinay_ @ zulily