Issue when starting a cmmn instance

ddpardo · December 19, 2019, 1:41pm

Hi all,

When starting a case definition instance i am receiving the following error:

2019-12-19 12:19:18,530 ERROR [user=,ip=][org.springframework.boot.web.servlet.support.ErrorPageFilter] (default task-1) Forwarding to error page from request [/cmmn/instances/start] due to exception [
Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: insert or update on table “act_ru_identitylink” violates foreign key constraint “act_fk_tskass_task”

Detail: Key (task_id_)=(65df7578-2251-11ea-990a-0242ac140009) is not present in table “act_ru_task”.

The error may exist in org/flowable/identitylink/service/db/mapping/entity/IdentityLink.xml

The error may involve org.flowable.identitylink.service.impl.persistence.entity.IdentityLinkEntityImpl.insertIdentityLink-Inline

The error occurred while setting parameters

SQL: insert into ACT_RU_IDENTITYLINK (ID_, REV_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_, PROC_DEF_ID_, SCOPE_ID_, SCOPE_TYPE_, SCOPE_DEFINITION_ID_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Cause: org.postgresql.util.PSQLException: ERROR: insert or update on table “act_ru_identitylink” violates foreign key constraint “act_fk_tskass_task”

Detail: Key (task_id_)=(65df7578-2251-11ea-990a-0242ac140009) is not present in table “act_ru_task”.]: org.apache.ibatis.exceptions.PersistenceException:

Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: insert or update on table “act_ru_identitylink” violates foreign key constraint “act_fk_tskass_task”

Detail: Key (task_id_)=(65df7578-2251-11ea-990a-0242ac140009) is not present in table “act_ru_task”.

The error may exist in org/flowable/identitylink/service/db/mapping/entity/IdentityLink.xml

The error may involve org.flowable.identitylink.service.impl.persistence.entity.IdentityLinkEntityImpl.insertIdentityLink-Inline

The error occurred while setting parameters

SQL: insert into ACT_RU_IDENTITYLINK (ID_, REV_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_, PROC_DEF_ID_, SCOPE_ID_, SCOPE_TYPE_, SCOPE_DEFINITION_ID_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Cause: org.postgresql.util.PSQLException: ERROR: insert or update on table “act_ru_identitylink” violates foreign key constraint “act_fk_tskass_task”

Detail: Key (task_id_)=(65df7578-2251-11ea-990a-0242ac140009) is not present in table “act_ru_task”.

The cmmn model is a single human task with the candidate groups set to admin. If I remove the candidate groups attribute the instance starts. Any pointers available why this constraint is met?

Additional background:

Database is freshly created or on an existing database.
Used both the spring boot starter and the manual spring setup
Tested on Postgres versions 9, 10
Endpoint is a simple spring controller calling the caseinstancebuilder start method.
case definition model was designed trough using the flowable-modeler.

Let me know If additional info is needed.

joram · December 20, 2019, 2:23pm

I tried to reproduce here: https://github.com/flowable/flowable-engine/commit/1e3ae15324b266a7f3f8a2a645faf220b273e3ba, but that unit test works. Can you share the cmmn xml?

ddpardo · December 21, 2019, 11:39am

Hi joram,

gist.github.com

https://gist.github.com/ddpardo/e47d841ce4e73b60ef35be036b4bf6ca

test-cmmn-david.cmmn.xml

<?xml version="1.0" encoding="UTF-8"?>
<definitions xmlns="http://www.omg.org/spec/CMMN/20151109/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:flowable="http://flowable.org/cmmn" xmlns:cmmndi="http://www.omg.org/spec/CMMN/20151109/CMMNDI" xmlns:dc="http://www.omg.org/spec/CMMN/20151109/DC" xmlns:di="http://www.omg.org/spec/CMMN/20151109/DI" targetNamespace="http://www.flowable.org/casedef">
  <case id="tcd" name="test cmmn david" flowable:initiatorVariableName="initiator">
    <casePlanModel id="casePlanModel" name="david test cmmn" flowable:formFieldValidation="true" flowable:includeInStageOverview="false">
      <planItem id="planItem1" name="Hallo wereld" definitionRef="sid-018D1A27-BEBE-49B4-AECA-9302EE8C873D"></planItem>
      <humanTask id="sid-018D1A27-BEBE-49B4-AECA-9302EE8C873D" name="Hallo wereld" flowable:candidateGroups="admin" flowable:formFieldValidation="true"></humanTask>
    </casePlanModel>
  </case>
  <cmmndi:CMMNDI>
    <cmmndi:CMMNDiagram id="CMMNDiagram_tcd">

This file has been truncated. show original

ddpardo · December 31, 2019, 2:43pm

Hi Joram,

I changed the project dependencies to spring boot starters and it now successful starts the instance. The only noticeable differences is that the priority of the engines in comparison to when manually creating the beans.

14:26:30,039 INFO [org.flowable.spring.boot.ProcessEngineAutoConfiguration$$EnhancerBySpringCGLIB$$f7e5801d] (ServerService Thread Pool – 113) No deployment resources were found for autodeployment
14:26:30,122 INFO [org.flowable.spring.SpringProcessEngineConfiguration] (ServerService Thread Pool – 113) Found 2 Engine Configurators in total:
14:26:30,122 INFO [org.flowable.spring.SpringProcessEngineConfiguration] (ServerService Thread Pool – 113) class org.flowable.idm.engine.configurator.IdmEngineConfigurator (priority:100000)
14:26:30,123 INFO [org.flowable.spring.SpringProcessEngineConfiguration] (ServerService Thread Pool – 113) class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)
14:26:30,123 INFO [org.flowable.spring.SpringProcessEngineConfiguration] (ServerService Thread Pool – 113) Executing beforeInit() of class org.flowable.idm.engine.configurator.IdmEngineConfigurator (priority:100000)
14:26:30,126 INFO [org.flowable.spring.SpringProcessEngineConfiguration] (ServerService Thread Pool – 113) Executing beforeInit() of class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)
14:26:31,510 INFO [org.flowable.spring.SpringProcessEngineConfiguration] (ServerService Thread Pool – 113) Found compatibility handler instance : class org.activiti.compatibility.spring.DefaultFlowable5SpringCompatibilityHandler
14:26:31,563 INFO [org.flowable.spring.SpringProcessEngineConfiguration] (ServerService Thread Pool – 113) Executing configure() of class org.flowable.idm.engine.configurator.IdmEngineConfigurator (priority:100000)
14:26:31,587 INFO [org.flowable.spring.SpringProcessEngineConfiguration] (ServerService Thread Pool – 113) Executing configure() of class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)
14:26:31,657 INFO [org.flowable.job.service.impl.asyncexecutor.AbstractAsyncExecutor] (ServerService Thread Pool – 113) Starting up the async job executor [org.flowable.spring.job.service.SpringAsyncExecutor].
14:26:31,658 INFO [org.flowable.job.service.impl.asyncexecutor.AcquireAsyncJobsDueRunnable] (Thread-153) starting to acquire async jobs due
14:26:31,659 INFO [org.flowable.job.service.impl.asyncexecutor.AcquireTimerJobsRunnable] (Thread-154) starting to acquire async jobs due
14:26:31,659 INFO [org.flowable.cmmn.engine.impl.CmmnEngineImpl] (ServerService Thread Pool – 113) CmmnEngine default created
14:26:31,664 INFO [org.flowable.job.service.impl.asyncexecutor.ResetExpiredJobsRunnable] (Thread-155) starting to reset expired jobs for engine cmmn
14:26:31,673 INFO [org.flowable.engine.impl.ProcessEngineImpl] (ServerService Thread Pool – 113) ProcessEngine default created
14:26:31,682 INFO [org.flowable.job.service.impl.asyncexecutor.AbstractAsyncExecutor] (ServerService Thread Pool – 113) Starting up the async job executor [org.flowable.spring.job.service.SpringAsyncExecutor].
14:26:31,684 INFO [org.flowable.job.service.impl.asyncexecutor.AcquireAsyncJobsDueRunnable] (Thread-156) starting to acquire async jobs due

Also another question:

Is it still possible to use a JTA datasource (ex. managed by wildfly) in combination with schemaupdate set to true / false? The current implementation commits the transaction resulting in “java.sql.SQLException: IJ031019: You cannot commit during a managed transaction”.

joram · January 6, 2020, 9:32pm

Do you still have the way you had set them up before? The cmmn engine should indeed go after the bpmn engine (and if the app engine is used, they both should go after that one), so maybe that was the problem.

Which database are you using? Do you have a stacktrace? We’re not committing during schema creation (I think), so not sure what’s going on here.

ddpardo · January 7, 2020, 5:39pm

Hi joram,

You can find a slim downed version here: https://github.com/ddpardo/flowable-engine-order-prototype
It uses spring boot to start datasource & tomcat.The engines are manually created. Additional instructions in the readme how to create the error.

For the JTA issue, the error is caused by the commit call, when deploying the engine on a wildfly where the datasource is managed by wildfly itself. I have only tested with postgresql:

github.com

flowable/flowable-engine/blob/master/modules/flowable-engine-common/src/main/java/org/flowable/common/engine/impl/db/LiquibaseBasedSchemaManager.java#L139-L146


// A commit is needed here, because one of the things that Liquibase does when acquiring its lock
// is doing a rollback, which removes all changes done so far.
// For most databases, this is not a problem as DDL statements are not transactional.
// However for some (e.g. sql server), this would remove all previous statements, which is not wanted,
// hence the extra commit here.
if (!jdbcConnection.getAutoCommit()) {
    jdbcConnection.commit();
}

joram · January 17, 2020, 10:59pm

Thanks for the excellent example app, this made testing it a breeze!
I did encounter the same problem. However, just for testing I upgraded to the 6.5.0-SNAPSHOT (latest build done from master) and the problem is gone. Most likely it has been fixed on master.
Can you try building the latest version (clone the repo and then do mvn -Pdistro clean install -DskipTests) and giving it a go to double check?

Topic		Replies	Views
Case Example Fails in Oracle Flowable Engine	8	948	February 25, 2019
Strange question - startProcessInstanceById() cause error Flowable Engine	10	809	November 16, 2020
Duplicate SQL insert primary key error in ACT_HI_* tables in workflow Flowable Engine	11	2649	October 12, 2020
Compensation Boundary Event Flowable Engine	1	231	August 30, 2023
Error when querying for cases by caseDefinitionId and caseInstanceId Flowable Engine	1	524	February 17, 2020

Issue when starting a cmmn instance

Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: insert or update on table “act_ru_identitylink” violates foreign key constraint “act_fk_tskass_task”

The error may exist in org/flowable/identitylink/service/db/mapping/entity/IdentityLink.xml

The error may involve org.flowable.identitylink.service.impl.persistence.entity.IdentityLinkEntityImpl.insertIdentityLink-Inline

The error occurred while setting parameters

SQL: insert into ACT_RU_IDENTITYLINK (ID_, REV_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_, PROC_DEF_ID_, SCOPE_ID_, SCOPE_TYPE_, SCOPE_DEFINITION_ID_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Cause: org.postgresql.util.PSQLException: ERROR: insert or update on table “act_ru_identitylink” violates foreign key constraint “act_fk_tskass_task”