cancel
Showing results for 
Search instead for 
Did you mean: 

Referential integrity constraint violation: 'ACT_FK_EXE_PROC

mlisiewicz
Champ in-the-making
Champ in-the-making
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 context
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  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:
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_)
    values (
      ?,
      1,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    ) [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_)
    values (
      ?,
      1,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    ) [params=(String) 8, (String) 5, (null) null, (String) Portout:1:4, (String) receivetask25, (boolean) true, (boolean) false, (boolean) true, (String) 5, (null) null]}

### The error may involve org.activiti.persistence.insertExecution-Inline
### The error occurred while setting parameters
### 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:
1 REPLY 1

jbarrez
Star Contributor
Star Contributor
If you want the behavior as shown on the diagram, you should better use a multi instance user task.