Hi, I am using activiti 5.8 version and getting foreign key constraint violation

cancel
Showing results for 
Search instead for 
Did you mean: 
shilpi
Member II

Hi, I am using activiti 5.8 version and getting foreign key constraint violation

And at the end of the process execution, am getting below exception:

06:44:38 Exception - org.apache.ibatis.exceptions.PersistenceException:
Error updating database. Cause: com.sybase.jdbc3.jdbc.SybSQLException: Dependent foreign key constraint violation in a referential integrity constraint. dbname = 'activitidb', table name = 'ACT_RU_EXECUTION', constraint name = 'ACT_FK_VAR_EXE'.
The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline
The error occurred while setting parameters
Cause: com.sybase.jdbc3.jdbc.SybSQLException: Dependent foreign key constraint violation in a referential integrity constraint. dbname = 'activitidb', table name = 'ACT_RU_EXECUTION', constraint name = 'ACT_FK_VAR_EXE'.

Could you please suggest if this issue is specific to the activiti version which am using.

Please let me know if any other details are required,

Regards,
Shilpi

2 Replies
gdharley
Intermediate

Re: Hi, I am using activiti 5.8 version and getting foreign key constraint violation

5.8?

You need to upgrade.

Greg

sunilkumartk
Active Member

Re: Hi, I am using activiti 5.8 version and getting foreign key constraint violation

@shilpi 

There is a known bug in version 5.8 related the above error message.

Read bug ACT-955 here Activiti Readme 

We recommend and upgrade.

Thanks 

Sunil