topic Violation of Primary key constraint on table ACT_HI_PROCINST in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/violation-of-primary-key-constraint-on-table-act-hi-procinst/m-p/58686#M35957 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><SPAN>The problem occur when after this manual data migration I try to start new process (in Activiti), it gives me the following error:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>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)…<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>It means Activiti tries to assign an already taken Process ID.</SPAN><BR /><SPAN>How can I tell activiti to continue assigning process IDs from for example 15100 in order to avoid coincide with the migrated processes?</SPAN><BR /><SPAN>Thanks in advance for your help.</SPAN></BODY></HTML> Wed, 28 Dec 2011 10:18:05 GMT ajucelves 2011-12-28T10:18:05Z Violation of Primary key constraint on table ACT_HI_PROCINST https://connect.hyland.com/t5/alfresco-archive/violation-of-primary-key-constraint-on-table-act-hi-procinst/m-p/58686#M35957 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 sta Wed, 28 Dec 2011 10:18:05 GMT https://connect.hyland.com/t5/alfresco-archive/violation-of-primary-key-constraint-on-table-act-hi-procinst/m-p/58686#M35957 ajucelves 2011-12-28T10:18:05Z Re: Violation of Primary key constraint on table ACT_HI_PROCINST https://connect.hyland.com/t5/alfresco-archive/violation-of-primary-key-constraint-on-table-act-hi-procinst/m-p/58687#M35958 <HTML><HEAD></HEAD><BODY><SPAN>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</SPAN></BODY></HTML> Thu, 29 Dec 2011 11:14:37 GMT https://connect.hyland.com/t5/alfresco-archive/violation-of-primary-key-constraint-on-table-act-hi-procinst/m-p/58687#M35958 ronald_van_kuij 2011-12-29T11:14:37Z