Flowable Boundary Event registry event issue Foreign key constraint violation issue

Flowable Engine
1

I am using flowable dependency 6.5.0 in spring boot application. And flowable modeler tool to generate bpmn file. I am working on the POC of “Boundary Event registry event”. I have 2 topics, input-test(“for message1”) and boundary-test(“message2”). Here as per the diagram, What I want is to
execute task1 and task2 in the main flow. And Execute task 3 when event is produced on topic “boundary-test” with the same ${userId} (process variable). Please find the bpmn file of the same.
The bean functions are just print to Console. Here while executing the whole process. I am getting the following exception after task2. Am I missing something here? Also adding to this, Is there any way where I can read from the same topic for both boundary event and start event.
Bpmn diagram:

Screenshot 2020-06-04 at 3.41.58 AM
Screenshot 2020-06-04 at 3.41.58 AM1320×562 13.9 KB

Bpmn file :

<?xml version="1.0" encoding="UTF-8"?> <definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:flowable="http://flowable.org/bpmn" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:omgdi="http://www.omg.org/spec/DD/20100524/DI" typeLanguage="http://www.w3.org/2001/XMLSchema" expressionLanguage="http://www.w3.org/1999/XPath" targetNamespace="http://www.flowable.org/processdef"> <process id="boundaryEventPOC2_5" name="boundaryEventPOC2_5" isExecutable="true"> <startEvent id="eventTask1" name="message1"> <extensionElements> <flowable:eventType xmlns:flowable="http://flowable.org/bpmn"><![CDATA[boundaryEventPOC]]></flowable:eventType> <flowable:eventName xmlns:flowable="http://flowable.org/bpmn"><![CDATA[message1]]></flowable:eventName> <flowable:eventOutParameter xmlns:flowable="http://flowable.org/bpmn" source="eventType" sourceType="string" target="eventType"></flowable:eventOutParameter> <flowable:eventOutParameter xmlns:flowable="http://flowable.org/bpmn" source="userId" sourceType="string" target="userId"></flowable:eventOutParameter> <flowable:eventOutParameter xmlns:flowable="http://flowable.org/bpmn" source="name" sourceType="string" target="name"></flowable:eventOutParameter> <flowable:eventOutParameter xmlns:flowable="http://flowable.org/bpmn" source="param1" sourceType="string" target="param1"></flowable:eventOutParameter> <flowable:eventOutParameter xmlns:flowable="http://flowable.org/bpmn" source="param2" sourceType="string" target="param2"></flowable:eventOutParameter> <flowable:channelKey xmlns:flowable="http://flowable.org/bpmn"><![CDATA[inputTopicInboundChannel]]></flowable:channelKey> <flowable:channelName xmlns:flowable="http://flowable.org/bpmn"><![CDATA[Input Topic Inbound Channel]]></flowable:channelName> <flowable:channelType xmlns:flowable="http://flowable.org/bpmn"><![CDATA[kafka]]></flowable:channelType> <flowable:channelDestination xmlns:flowable="http://flowable.org/bpmn"><![CDATA[input-test]]></flowable:channelDestination> <flowable:keyDetectionType xmlns:flowable="http://flowable.org/bpmn"><![CDATA[fixedValue]]></flowable:keyDetectionType> <flowable:keyDetectionValue xmlns:flowable="http://flowable.org/bpmn"><![CDATA[boundaryEventPOC]]></flowable:keyDetectionValue> </extensionElements> </startEvent> <serviceTask id="ServiceEvent1" name="Kafka Conversion Event" flowable:expression="${customConversionService.upperCase(name)}" flowable:resultVariableName="upperCase"></serviceTask> <sequenceFlow id="sid-10BBFB8C-2887-437E-96AC-24A5AFD4D06C" sourceRef="eventTask1" targetRef="ServiceEvent1"></sequenceFlow> <serviceTask id="serviceEvent3" name="task3 " flowable:expression="${clickhouseInteractor.execute1()}"></serviceTask> <sequenceFlow id="sid-3F992B46-0A45-4471-8FD8-4084A5351BDC" sourceRef="eventTask2" targetRef="serviceEvent3"></sequenceFlow> <endEvent id="sid-40DC2D51-5257-4B07-8076-9901207EFFB2"></endEvent> <sequenceFlow id="sid-6CBC13F0-27F1-4415-89E9-6B4B94BD9829" sourceRef="serviceEvent3" targetRef="sid-40DC2D51-5257-4B07-8076-9901207EFFB2"></sequenceFlow> <serviceTask id="serviceEvent2" name="task2 " flowable:expression="${clickhouseInteractor.execute()}"></serviceTask> <sequenceFlow id="sid-3526C396-C9FB-4CB3-B972-73F5A1EC72CB" sourceRef="ServiceEvent1" targetRef="serviceEvent2"></sequenceFlow> <endEvent id="sid-522B5CE8-871E-4CF7-9AED-1AA646D98543"></endEvent> <sequenceFlow id="sid-46EC484B-BEBC-42C0-A342-AD5C4397F4F2" sourceRef="serviceEvent2" targetRef="sid-522B5CE8-871E-4CF7-9AED-1AA646D98543"></sequenceFlow> <boundaryEvent id="eventTask2" name="message2" attachedToRef="serviceEvent2"> <extensionElements> <flowable:eventType xmlns:flowable="http://flowable.org/bpmn"><![CDATA[boundaryEvent]]></flowable:eventType> <flowable:eventOutParameter xmlns:flowable="http://flowable.org/bpmn" source="eventType" sourceType="string" target="eventType"></flowable:eventOutParameter> <flowable:eventOutParameter xmlns:flowable="http://flowable.org/bpmn" source="userId" sourceType="string" target="userId"></flowable:eventOutParameter> <flowable:eventOutParameter xmlns:flowable="http://flowable.org/bpmn" source="name" sourceType="string" target="name"></flowable:eventOutParameter> <flowable:eventOutParameter xmlns:flowable="http://flowable.org/bpmn" source="param1" sourceType="string" target="param1"></flowable:eventOutParameter> <flowable:eventOutParameter xmlns:flowable="http://flowable.org/bpmn" source="param2" sourceType="string" target="param2"></flowable:eventOutParameter> <flowable:eventCorrelationParameter xmlns:flowable="http://flowable.org/bpmn" name="userId" type="string" value="${userId}"></flowable:eventCorrelationParameter> <flowable:channelKey xmlns:flowable="http://flowable.org/bpmn"><![CDATA[boundaryChannelKey]]></flowable:channelKey> <flowable:channelName xmlns:flowable="http://flowable.org/bpmn"><![CDATA[Boundary Channel Name]]></flowable:channelName> <flowable:channelType xmlns:flowable="http://flowable.org/bpmn"><![CDATA[kafka]]></flowable:channelType> <flowable:channelDestination xmlns:flowable="http://flowable.org/bpmn"><![CDATA[boundary-test]]></flowable:channelDestination> <flowable:keyDetectionType xmlns:flowable="http://flowable.org/bpmn"><![CDATA[fixedValue]]></flowable:keyDetectionType> <flowable:keyDetectionValue xmlns:flowable="http://flowable.org/bpmn"><![CDATA[boundaryEvent]]></flowable:keyDetectionValue> </extensionElements> </boundaryEvent> </process> <bpmndi:BPMNDiagram id="BPMNDiagram_boundaryEventPOC2_5"> <bpmndi:BPMNPlane bpmnElement="boundaryEventPOC2_5" id="BPMNPlane_boundaryEventPOC2_5"> <bpmndi:BPMNShape bpmnElement="eventTask1" id="BPMNShape_eventTask1"> <omgdc:Bounds height="30.0" width="30.5" x="30.0" y="191.0"></omgdc:Bounds> </bpmndi:BPMNShape> <bpmndi:BPMNShape bpmnElement="ServiceEvent1" id="BPMNShape_ServiceEvent1"> <omgdc:Bounds height="80.0" width="100.0" x="150.0" y="166.0"></omgdc:Bounds> </bpmndi:BPMNShape> <bpmndi:BPMNShape bpmnElement="serviceEvent3" id="BPMNShape_serviceEvent3"> <omgdc:Bounds height="80.0" width="100.0" x="325.6291835759413" y="166.0"></omgdc:Bounds> </bpmndi:BPMNShape> <bpmndi:BPMNShape bpmnElement="sid-40DC2D51-5257-4B07-8076-9901207EFFB2" id="BPMNShape_sid-40DC2D51-5257-4B07-8076-9901207EFFB2"> <omgdc:Bounds height="28.0" width="28.0" x="572.0" y="192.0"></omgdc:Bounds> </bpmndi:BPMNShape> <bpmndi:BPMNShape bpmnElement="serviceEvent2" id="BPMNShape_serviceEvent2"> <omgdc:Bounds height="80.0" width="100.0" x="315.0" y="15.0"></omgdc:Bounds> </bpmndi:BPMNShape> <bpmndi:BPMNShape bpmnElement="sid-522B5CE8-871E-4CF7-9AED-1AA646D98543" id="BPMNShape_sid-522B5CE8-871E-4CF7-9AED-1AA646D98543"> <omgdc:Bounds height="28.0" width="28.0" x="566.0" y="41.0"></omgdc:Bounds> </bpmndi:BPMNShape> <bpmndi:BPMNShape bpmnElement="eventTask2" id="BPMNShape_eventTask2"> <omgdc:Bounds height="30.0" width="30.0" x="360.6291835759413" y="80.15469350911151"></omgdc:Bounds> </bpmndi:BPMNShape> <bpmndi:BPMNEdge bpmnElement="sid-10BBFB8C-2887-437E-96AC-24A5AFD4D06C" id="BPMNEdge_sid-10BBFB8C-2887-437E-96AC-24A5AFD4D06C"> <omgdi:waypoint x="60.44999919788482" y="206.0"></omgdi:waypoint> <omgdi:waypoint x="149.99999999997436" y="206.0"></omgdi:waypoint> </bpmndi:BPMNEdge> <bpmndi:BPMNEdge bpmnElement="sid-3F992B46-0A45-4471-8FD8-4084A5351BDC" id="BPMNEdge_sid-3F992B46-0A45-4471-8FD8-4084A5351BDC"> <omgdi:waypoint x="375.6291835759413" y="110.10469202208384"></omgdi:waypoint> <omgdi:waypoint x="375.6291835759413" y="166.0"></omgdi:waypoint> </bpmndi:BPMNEdge> <bpmndi:BPMNEdge bpmnElement="sid-6CBC13F0-27F1-4415-89E9-6B4B94BD9829" id="BPMNEdge_sid-6CBC13F0-27F1-4415-89E9-6B4B94BD9829"> <omgdi:waypoint x="425.5791835758144" y="206.0"></omgdi:waypoint> <omgdi:waypoint x="572.0" y="206.0"></omgdi:waypoint> </bpmndi:BPMNEdge> <bpmndi:BPMNEdge bpmnElement="sid-3526C396-C9FB-4CB3-B972-73F5A1EC72CB" id="BPMNEdge_sid-3526C396-C9FB-4CB3-B972-73F5A1EC72CB"> <omgdi:waypoint x="200.0" y="166.0"></omgdi:waypoint> <omgdi:waypoint x="200.0" y="55.0"></omgdi:waypoint> <omgdi:waypoint x="314.99999999997044" y="55.0"></omgdi:waypoint> </bpmndi:BPMNEdge> <bpmndi:BPMNEdge bpmnElement="sid-46EC484B-BEBC-42C0-A342-AD5C4397F4F2" id="BPMNEdge_sid-46EC484B-BEBC-42C0-A342-AD5C4397F4F2"> <omgdi:waypoint x="414.95000000000005" y="55.0"></omgdi:waypoint> <omgdi:waypoint x="566.0" y="55.0"></omgdi:waypoint> </bpmndi:BPMNEdge> </bpmndi:BPMNPlane> </bpmndi:BPMNDiagram> </definitions>

ChannelDefinitions:

{ "type": "kafka", "channelType": "inbound", "deserializerType": "json", "topics": [ "boundary-test" ], "channelEventKeyDetection": { "fixedValue": "boundaryEvent" }, "name": "Boundary Channel Name", "key": "boundaryChannelKey" }
And
{ "type": "kafka", "channelType": "inbound", "deserializerType": "json", "topics": [ "input-test" ], "channelEventKeyDetection": { "fixedValue": "boundaryEventPOC" }, "name": "Input Topic Inbound Channel", "key": "inputTopicInboundChannel" }
eventDefinitions:

`{
“correlationParameters”: [{
“name”: “userId”,
“type”: “string”
}],

“payload”: [
{
“name”: “eventType”,
“type”: “string”
},
{
“name”: “param1”,
“type”: “string”
},
{
“name”: “param2”,
“type”: “string”
},
{
“name”: “name”,
“type”: “string”
},
{
“name”: “userId”,
“type”: “string”
}

],
“name”: “Input Topic Event”,
“key”: “boundaryEvent”
}`
And

`{
“correlationParameters”: [],
“payload”: [
{
“name”: “eventType”,
“type”: “string”
},
{
“name”: “param1”,
“type”: “string”
},
{
“name”: “param2”,
“type”: “string”
},
{
“name”: “name”,
“type”: “string”
},
{
“name”: “userId”,
“type”: “string”
}

],
“name”: “Input Topic Event”,
“key”: “boundaryEventPOC”
}`

Exception:

`2020-06-04 03:38:16.540 ERROR 16824 — [ task-1] o.f.c.e.impl.interceptor.CommandContext : Error while closing command context

org.apache.ibatis.exceptions.PersistenceException:

Error updating database. Cause: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Referential integrity constraint violation: “ACT_FK_EVENT_EXEC: PUBLIC.ACT_RU_EVENT_SUBSCR FOREIGN KEY(EXECUTION_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_) (‘b9323db6-a5e6-11ea-902d-46d84484c406’)”; SQL statement:

insert into ACT_RU_EVENT_SUBSCR (
ID_,
REV_,
EVENT_TYPE_,
EVENT_NAME_,
EXECUTION_ID_,
PROC_INST_ID_,
ACTIVITY_ID_,
CONFIGURATION_,
CREATED_,
PROC_DEF_ID_,
SUB_SCOPE_ID_,
SCOPE_ID_,
SCOPE_DEFINITION_ID_,
SCOPE_TYPE_,
TENANT_ID_
)
values (?,
1,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?
) [23506-200]
The error may exist in org/flowable/eventsubscription/service/db/mapping/entity/EventSubscription.xml
The error may involve org.flowable.eventsubscription.service.impl.persistence.entity.EventSubscriptionEntityImpl.insertGenericEventSubscription-Inline
The error occurred while setting parameters
SQL: insert into ACT_RU_EVENT_SUBSCR ( ID_, REV_, EVENT_TYPE_, EVENT_NAME_, EXECUTION_ID_, PROC_INST_ID_, ACTIVITY_ID_, CONFIGURATION_, CREATED_, PROC_DEF_ID_, SUB_SCOPE_ID_, SCOPE_ID_, SCOPE_DEFINITION_ID_, SCOPE_TYPE_, TENANT_ID_ ) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

Cause: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Referential integrity constraint violation: “ACT_FK_EVENT_EXEC: PUBLIC.ACT_RU_EVENT_SUBSCR FOREIGN KEY(EXECUTION_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_) (‘b9323db6-a5e6-11ea-902d-46d84484c406’)”; SQL statement:

insert into ACT_RU_EVENT_SUBSCR (
ID_,
REV_,
EVENT_TYPE_,
EVENT_NAME_,
EXECUTION_ID_,
PROC_INST_ID_,
ACTIVITY_ID_,
CONFIGURATION_,
CREATED_,
PROC_DEF_ID_,
SUB_SCOPE_ID_,
SCOPE_ID_,
SCOPE_DEFINITION_ID_,
SCOPE_TYPE_,
TENANT_ID_
)
values (?,
1,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?
) [23506-200]
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.5.3.jar:3.5.3]
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199) ~[mybatis-3.5.3.jar:3.5.3]
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184) ~[mybatis-3.5.3.jar:3.5.3]
at org.flowable.common.engine.impl.db.DbSqlSession.flushRegularInsert(DbSqlSession.java:509) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.db.DbSqlSession.flushInsertEntities(DbSqlSession.java:490) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:473) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:358) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:192) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.interceptor.CommandContext.close(CommandContext.java:61) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:81) [flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.spring.SpringTransactionInterceptor.lambda$execute$0(SpringTransactionInterceptor.java:56) [flowable-spring-common-6.5.0.jar:6.5.0]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:56) [flowable-spring-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:51) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.job.service.impl.asyncexecutor.ExecuteAsyncRunnable.executeJob(ExecuteAsyncRunnable.java:128) ~[flowable-job-service-6.5.0.jar:6.5.0]
at org.flowable.job.service.impl.asyncexecutor.ExecuteAsyncRunnable.run(ExecuteAsyncRunnable.java:116) ~[flowable-job-service-6.5.0.jar:6.5.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_242]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_242]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_242]
Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Referential integrity constraint violation: “ACT_FK_EVENT_EXEC: PUBLIC.ACT_RU_EVENT_SUBSCR FOREIGN KEY(EXECUTION_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_) (‘b9323db6-a5e6-11ea-902d-46d84484c406’)”; SQL statement:
insert into ACT_RU_EVENT_SUBSCR (
ID_,
REV_,
EVENT_TYPE_,
EVENT_NAME_,
EXECUTION_ID_,
PROC_INST_ID_,
ACTIVITY_ID_,
CONFIGURATION_,
CREATED_,
PROC_DEF_ID_,
SUB_SCOPE_ID_,
SCOPE_ID_,
SCOPE_DEFINITION_ID_,
SCOPE_TYPE_,
TENANT_ID_
)
values (?,
1,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?
) [23506-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:459) ~[h2-1.4.200.jar:1.4.200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2-1.4.200.jar:1.4.200]
at org.h2.message.DbException.get(DbException.java:205) ~[h2-1.4.200.jar:1.4.200]
at org.h2.message.DbException.get(DbException.java:181) ~[h2-1.4.200.jar:1.4.200]
at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:319) ~[h2-1.4.200.jar:1.4.200]
at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:261) ~[h2-1.4.200.jar:1.4.200]
at org.h2.table.Table.fireConstraints(Table.java:1057) ~[h2-1.4.200.jar:1.4.200]
at org.h2.table.Table.fireAfterRow(Table.java:1075) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.dml.Insert.insertRows(Insert.java:211) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.dml.Insert.update(Insert.java:151) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.CommandContainer.update(CommandContainer.java:198) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.Command.executeUpdate(Command.java:251) ~[h2-1.4.200.jar:1.4.200]
at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:240) ~[h2-1.4.200.jar:1.4.200]
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-3.4.2.jar:na]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.2.jar:na]
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47) ~[mybatis-3.5.3.jar:3.5.3]
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) ~[mybatis-3.5.3.jar:3.5.3]
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) ~[mybatis-3.5.3.jar:3.5.3]
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) ~[mybatis-3.5.3.jar:3.5.3]
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) ~[mybatis-3.5.3.jar:3.5.3]
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197) ~[mybatis-3.5.3.jar:3.5.3]
… 19 common frames omitted

2020-06-04 03:38:16.544 ERROR 16824 — [ task-1] ltAsyncRunnableExecutionExceptionHandler : Job b54bdbb2-a5e6-11ea-902d-46d84484c406 failed

org.apache.ibatis.exceptions.PersistenceException:

Error updating database. Cause: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Referential integrity constraint violation: “ACT_FK_EVENT_EXEC: PUBLIC.ACT_RU_EVENT_SUBSCR FOREIGN KEY(EXECUTION_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_) (‘b9323db6-a5e6-11ea-902d-46d84484c406’)”; SQL statement:

insert into ACT_RU_EVENT_SUBSCR (
ID_,
REV_,
EVENT_TYPE_,
EVENT_NAME_,
EXECUTION_ID_,
PROC_INST_ID_,
ACTIVITY_ID_,
CONFIGURATION_,
CREATED_,
PROC_DEF_ID_,
SUB_SCOPE_ID_,
SCOPE_ID_,
SCOPE_DEFINITION_ID_,
SCOPE_TYPE_,
TENANT_ID_
)
values (?,
1,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?
) [23506-200]
The error may exist in org/flowable/eventsubscription/service/db/mapping/entity/EventSubscription.xml
The error may involve org.flowable.eventsubscription.service.impl.persistence.entity.EventSubscriptionEntityImpl.insertGenericEventSubscription-Inline
The error occurred while setting parameters

SQL: insert into ACT_RU_EVENT_SUBSCR ( ID_, REV_, EVENT_TYPE_, EVENT_NAME_, EXECUTION_ID_, PROC_INST_ID_, ACTIVITY_ID_, CONFIGURATION_, CREATED_, PROC_DEF_ID_, SUB_SCOPE_ID_, SCOPE_ID_, SCOPE_DEFINITION_ID_, SCOPE_TYPE_, TENANT_ID_ ) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

Cause: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Referential integrity constraint violation: “ACT_FK_EVENT_EXEC: PUBLIC.ACT_RU_EVENT_SUBSCR FOREIGN KEY(EXECUTION_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_) (‘b9323db6-a5e6-11ea-902d-46d84484c406’)”; SQL statement:

insert into ACT_RU_EVENT_SUBSCR (
ID_,
REV_,
EVENT_TYPE_,
EVENT_NAME_,
EXECUTION_ID_,
PROC_INST_ID_,
ACTIVITY_ID_,
CONFIGURATION_,
CREATED_,
PROC_DEF_ID_,
SUB_SCOPE_ID_,
SCOPE_ID_,
SCOPE_DEFINITION_ID_,
SCOPE_TYPE_,
TENANT_ID_
)
values (?,
1,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?
) [23506-200]
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.5.3.jar:3.5.3]
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199) ~[mybatis-3.5.3.jar:3.5.3]
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184) ~[mybatis-3.5.3.jar:3.5.3]
at org.flowable.common.engine.impl.db.DbSqlSession.flushRegularInsert(DbSqlSession.java:509) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.db.DbSqlSession.flushInsertEntities(DbSqlSession.java:490) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:473) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:358) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:192) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.interceptor.CommandContext.close(CommandContext.java:61) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:81) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.spring.SpringTransactionInterceptor.lambda$execute$0(SpringTransactionInterceptor.java:56) ~[flowable-spring-common-6.5.0.jar:6.5.0]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:56) ~[flowable-spring-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:51) ~[flowable-engine-common-6.5.0.jar:6.5.0]
at org.flowable.job.service.impl.asyncexecutor.ExecuteAsyncRunnable.executeJob(ExecuteAsyncRunnable.java:128) [flowable-job-service-6.5.0.jar:6.5.0]
at org.flowable.job.service.impl.asyncexecutor.ExecuteAsyncRunnable.run(ExecuteAsyncRunnable.java:116) [flowable-job-service-6.5.0.jar:6.5.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_242]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_242]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_242]`

2

@martin.grofcik Sir, Can you please help here. Thanks

3

I see the async executor in the stacktrace - how are you running this, as I don’t see any async step in your process xml?

4

I am running this in spring-boot application. I have just created 2-3 beans for the service task and registered the provided definitions using .channel, .event files and .bpmn20.xml.

5

Having a similar issue, same sql exception. In our case we are also using spring-boot application and the service tasks call an expression, I’ve also tested this with an http task. The events we are catching are published on to an ActiveMQ queue. Boundary event registry event causing same issue.
I’ve attempted to debug the process but have been unable to isolate the cause.

6

if the task that the boundary event is attached to a task that is marked as triggerable the execution is recorded accurately - the sql exception is not raised.

This appears to be a bug in the modeler, surely the model validator should pickup that the boundary event is mis-configured?

7

Can you share a (simplified) example, so we can see what we’re talking about exactly?

8

Hi @AjayChowdhary/@joram ,

Do you find the root cause of the issue? We are also facing the same issue and we thought of changing the exception to a clear exception message.

Thanking you in advance!!!

10

No, my last comment was for a reproducible example, but that wasn’t posted.