cancel
Showing results for 
Search instead for 
Did you mean: 

Violation of Primary key constraint on table ACT_HI_PROCINST

ajucelves
Champ in-the-making
Champ in-the-making
I'm doing workflow migration from JBPM to Activiti, as there is data in JBPM tables I decided to copy this information to Activiti tables manually in order to have information about the old processes in Activiti. So far no problems.
The problem occur when after this manual data migration I try to start new process (in Activiti), it gives me the following error:
java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__ACT_HI_P__C4971C0F7167D3BD'. Cannot insert duplicate key in object 'dbo.ACT_HI_PROCINST'. The duplicate key value is (114)…
It means Activiti tries to assign an already taken Process ID.
How can I tell activiti to continue assigning process IDs from for example 15100 in order to avoid coincide with the migrated processes?
Thanks in advance for your help.
1 REPLY 1

ronald_van_kuij
Champ on-the-rise
Champ on-the-rise
Look in one of the oter tables. There is an 'id' generator stored that contains the value that should next be used for assigning ids