Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-4607

DDL sqlserver-springboot-jbpm-schema.sql included in the add on package throws a SQL error

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • 7.13.1.GA
    • jBPM Core
    • 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

       

       

       

      Attachments

        Activity

          People

            rhn-support-alazarot Alessandro Lazarotti
            rhn-gps-nmalvank Nikhil Malvankar
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: