jbarrez / activiti-spring-boot-webinar

13 stars 33 forks source link

Getting Referential integrity constraint violation #7

Open yadavsudhir405 opened 7 years ago

yadavsudhir405 commented 7 years ago

Hi @jbarrez I cloned the same demo project and was trying to run.

I'm able to get the page that prompts for image uploads but getting Forign-key-violation issues while approving the images.

Same code was working 20 days back..I'm suspecting is this due to new version of activiti6.04-Beta version.

This is the error which I get.

org.apache.ibatis.exceptions.PersistenceException:

Error updating database. Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "ACT_FK_TASK_EXE: PUBLIC.ACT_RU_TASK FOREIGN KEY(EXECUTIONID) REFERENCES PUBLIC.ACT_RUEXECUTION(ID) ('22')"; SQL statement:

delete from ACT_RUEXECUTION where ID = ? and REV_ = ? [23503-176]

The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntityImpl.deleteExecution-Inline

The error occurred while setting parameters

SQL: delete from ACT_RUEXECUTION where ID = ? and REV_ = ?

Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "ACT_FK_TASK_EXE: PUBLIC.ACT_RU_TASK FOREIGN KEY(EXECUTIONID) REFERENCES PUBLIC.ACT_RUEXECUTION(ID) ('22')"; SQL statement:

You can go through my project for more information : https://github.com/yadavsudhir405/activiti-spring-boot-webinar