topic duplicated key in act_ru_variable_pkey in Alfresco Archive

duplicated key in act_ru_variable_pkey

aachkar — Tue, 16 Aug 2011 18:26:45 GMT

We are using activiti engine in a singleton Ejb, running in Glassfish3 against PostgreSQL. Sometimes we get an error when completing a task.### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricción de unicidad «act_ru_variable_pkey»### The error

Re: duplicated key in act_ru_variable_pkey

ronald_van_kuij — Tue, 16 Aug 2011 23:13:38 GMT

Activiti 1.9 is not supported anymore…

Re: duplicated key in act_ru_variable_pkey

aachkar — Wed, 17 Aug 2011 13:59:01 GMT

We are using Activiti 5.3

Re: duplicated key in act_ru_variable_pkey

ronald_van_kuij — Wed, 17 Aug 2011 15:58:21 GMT

can you try with 5.7?

Re: duplicated key in act_ru_variable_pkey

aachkar — Wed, 17 Aug 2011 16:57:56 GMT

I'll try it and let you know.

Thanks

Re: duplicated key in act_ru_variable_pkey

aachkar — Tue, 30 Aug 2011 15:52:36 GMT

Same problem with 5.7, any ideas?

Re: duplicated key in act_ru_variable_pkey

ronald_van_kuij — Tue, 30 Aug 2011 15:56:27 GMT

did you also use a new config? afaik, 5.7. can use a new way of generating id's but not sure how/when it is used

Re: duplicated key in act_ru_variable_pkey

aachkar — Tue, 30 Aug 2011 16:47:30 GMT

What do you mean with a new config?

If you mean to the activiti.cfg.xml, the answer is no, I've used the same config.

Re: duplicated key in act_ru_variable_pkey

ronald_van_kuij — Tue, 30 Aug 2011 17:17:23 GMT

Yep, that is what I meant.

http://jira.codehaus.org/browse/ACT-789