topic Re: Getting Unique constraint error randomly in Alfresco Archive

Getting Unique constraint error randomly

susubhas — Thu, 25 Jul 2013 09:20:43 GMT

Hi,I am getting below error randomly. Is this a known issue?EVERE: Error while closing command contextorg.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SDP30D14_4.SYS_C001981724) vi

Re: Getting Unique constraint error randomly

trademak — Thu, 25 Jul 2013 09:44:45 GMT

No don't think so. Which database are you using? Do you have a lot of process instances being created at once? Can you provide a bit more background about how you are using Activiti?

Best regards,

Re: Getting Unique constraint error randomly

susubhas — Thu, 25 Jul 2013 10:38:07 GMT

Hi
I am using activiti with oracle database. Basically i am trying to do bulk operations which is sequential so there will be one process instance at any time. If i try to perform a operation 500 times, midway i get the above mentioned exception.

Rgds,
Sujata

Re: Getting Unique constraint error randomly

trademak — Thu, 25 Jul 2013 12:04:25 GMT

Okay. What does the process instance itself do? Do you also set variables there etc?
Which version of Activiti are you using? Did you do customization or additional configuration of any kind?

Best regards,

Re: Getting Unique constraint error randomly

susubhas — Thu, 25 Jul 2013 17:09:35 GMT

Yes, process instance will set some variables in the execution context. I am using V5.11.
I am using spring way of starting process engine. I havn't done any customizations to the process engine as such.
I am passing the transaction manager which is used by my application the to the activiti engine also.

Re: Getting Unique constraint error randomly

jbarrez — Thu, 01 Aug 2013 12:19:28 GMT

Could you find out on which column the unique constraint violation is happening?

Re: Getting Unique constraint error randomly

uprooter — Fri, 20 Sep 2013 11:46:42 GMT

I get the same exception and for me its the primary_key which is violated. I am using version 5.13

Sometimes it is also the table ACT_RU_EXECUTION or ACT_HI_ACTINST also with the primary_key being violated.

Re: Getting Unique constraint error randomly

trademak — Fri, 20 Sep 2013 11:59:02 GMT

Do you have a way to reproduce the issue in every case? Or is it a random issue?
Which database are you using?

Best regards,

Re: Getting Unique constraint error randomly

uprooter — Fri, 20 Sep 2013 12:00:31 GMT

Database is Oracle 11 and it is a random issue.

Re: Getting Unique constraint error randomly

brunopalaoro — Fri, 27 Sep 2013 19:04:52 GMT

Uprooter did you find what was the problem? I'm having the same situation here, but running activiti 5.12.

Re: Getting Unique constraint error randomly

trademak — Mon, 30 Sep 2013 09:57:59 GMT

Under high load it's better to use a StrongUuidGenerator like described in the user guide here:

http://www.activiti.org/userguide/#advanced.uuid.generator

Did you try that?

Best regards,

Re: Getting Unique constraint error randomly

rajesh1gupta — Mon, 27 Oct 2014 13:40:53 GMT

HI @trademak . I am also facing same issue with activiti 5.11 and oracle 11..is there any other solution apart from using http://www.activiti.org/userguide/#advanced.uuid.generator..

### The error may involve org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntity.insertHistoricActivityInstance-Inline
### The error occurred while setting parameters
### SQL: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
DuplicateKeyException: ORA-00001: unique constraint (SYS_C0034718) violated

Re: Getting Unique constraint error randomly

jbarrez — Tue, 28 Oct 2014 10:28:19 GMT

Depends if SYS_C0034718 refers to the same problem as above?

Why would the UUID generator not be a solution?

Re: Getting Unique constraint error randomly

rajesh1gupta — Wed, 29 Oct 2014 17:54:35 GMT

hi ,
Exception is not only on ACT_HI_ACTINST..it varies and its intermittent issue.

problem with UUID is jar dependency ..its need below jar..which is not avaialble in our nexus repository..getting this available for use is bit tedious process…can you suggest some other quick solution please

<dependency>
    <groupId>com.fasterxml.uuid</groupId>
    <artifactId>java-uuid-generator</artifactId>
    <version>3.1.3</version>
</dependency>

Re: Getting Unique constraint error randomly

trademak — Thu, 30 Oct 2014 16:00:53 GMT

So you are saying you are unable to get this UID dependency? That's not something we can solve…..

Best regards,