Details
-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
7.13.1.GA
-
None
-
False
-
None
-
False
-
---
-
---
-
Moderate
Description
The DDL for jbpm + Spring Boot runtime for SQL Server has a minor syntax error and it throws the following SQL error
SQL Error [2705] [S0003]: Column names in each table must be unique. Column name 'kieSessionId' in table 'TimerMappingInfo' is specified more than once.
The following query needs to be changed from:
create table TimerMappingInfo (id bigint not null, externalTimerId varchar(255), kieSessionId bigint not null, kieSessionId bigint, timerId bigint, uuid varchar(255) not null, info varbinary(MAX), primary key (id));
to
create table TimerMappingInfo (id bigint not null, externalTimerId varchar(255), kieSessionId bigint not null, timerId bigint, uuid varchar(255) not null, info varbinary(MAX), primary key (id));
Thanks,
Nikhil