topic Referential integrity constraint violation: 'ACT_FK_EXE_PROC in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/referential-integrity-constraint-violation-act-fk-exe-proc/m-p/9455#M3375 <HTML><HEAD></HEAD><BODY><SPAN>Following exception is caught while processing diagram (attached in zip file).</SPAN><BR /><SPAN>Most probably problem with forks (fork not allowed with temporary single outgoing connection?)</SPAN><BR /><BR /><BR /><BR /><SPAN>SEVERE: Error while closing command context</SPAN><BR /><SPAN>org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error updating database.&nbsp; Cause: org.apache.openjpa.lib.jdbc.ReportingSQLException: Referential integrity constraint violation: "ACT_FK_EXE_PROCINST: PUBLIC.ACT_RU_EXECUTION FOREIGN KEY(PROC_INST_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_)"; SQL statement:</SPAN><BR /><SPAN>insert into ACT_RU_EXECUTION (ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, ACT_ID_, IS_ACTIVE_, IS_CONCURRENT_, IS_SCOPE_, PARENT_ID_, SUPER_EXEC_)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; values (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; ) [23002-132] {prepstmnt 29189789 insert into ACT_RU_EXECUTION (ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, ACT_ID_, IS_ACTIVE_, IS_CONCURRENT_, IS_SCOPE_, PARENT_ID_, SUPER_EXEC_)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; values (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; ) [params=(String) 8, (String) 5, (null) null, (String) Portout:1:4, (String) receivetask25, (boolean) true, (boolean) false, (boolean) true, (String) 5, (null) null]} </SPAN><PRE class="language-none line-numbers"><CODE><BR />### The error may involve org.activiti.persistence.insertExecution-Inline<BR />### The error occurred while setting parameters<BR />### Cause: org.apache.openjpa.lib.jdbc.ReportingSQLException: Referential integrity constraint violation: "ACT_FK_EXE_PROCINST: PUBLIC.ACT_RU_EXECUTION FOREIGN KEY(PROC_INST_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_)"; SQL statement:<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Fri, 25 Mar 2011 14:14:00 GMT mlisiewicz 2011-03-25T14:14:00Z Referential integrity constraint violation: 'ACT_FK_EXE_PROC https://connect.hyland.com/t5/alfresco-archive/referential-integrity-constraint-violation-act-fk-exe-proc/m-p/9455#M3375 Following exception is caught while processing diagram (attached in zip file).Most probably problem with forks (fork not allowed with temporary single outgoing connection?)SEVERE: Error while closing command contextorg.apache.ibatis.exceptions.PersistenceException: ### Error updating database.&nbsp; Caus Fri, 25 Mar 2011 14:14:00 GMT https://connect.hyland.com/t5/alfresco-archive/referential-integrity-constraint-violation-act-fk-exe-proc/m-p/9455#M3375 mlisiewicz 2011-03-25T14:14:00Z Re: Referential integrity constraint violation: 'ACT_FK_EXE_PROC https://connect.hyland.com/t5/alfresco-archive/referential-integrity-constraint-violation-act-fk-exe-proc/m-p/9456#M3376 <HTML><HEAD></HEAD><BODY><SPAN>If you want the behavior as shown on the diagram, you should better use a multi instance user task.</SPAN></BODY></HTML> Mon, 28 Mar 2011 09:27:28 GMT https://connect.hyland.com/t5/alfresco-archive/referential-integrity-constraint-violation-act-fk-exe-proc/m-p/9456#M3376 jbarrez 2011-03-28T09:27:28Z