We're updating the issue view to help you get more done. 

Bonita Server Startup fails because of irregular case usage of column names in SQL script with MSSQL Turkish Collation

Description

The errors are always related to column names that contain the letter 'i'. In Turkish collation, different than other collations the upper case of i is 'İ', while the lower case of 'I' is 'ı'.

[ERROR] Failed to execute SQL script statement #13 of URL [file:/D:/Bonita2/setu
p/platform_conf/sql/sqlserver/createTables.sql]: CREATE TABLE actormember ( tena
ntid NUMERIC(19, 0) NOT NULL, id NUMERIC(19, 0) NOT NULL, actorId NUMERIC(19, 0)
NOT NULL, userId NUMERIC(19, 0) NOT NULL, groupId NUMERIC(19, 0) NOT NULL, role
Id NUMERIC(19, 0) NOT NULL, UNIQUE (tenantid, actorid, userId, groupId, roleId),
PRIMARY KEY (tenantid, id) ) ; nested exception is com.microsoft.sqlserver.jdbc
.SQLServerException: Column name 'actorid' does not exist in the target table or
view.
[ERROR] You might get more detailed information about the error by adding '--deb
ug' to the command line, and run again

Environment

  • Windows 7

  • MSSQL Server 2014 (12.0.5207)

    • Turkish Collation (Turkish_100_CI_AS)

Steps to reproduce

1. Create database in MsSQL
2. Run startup-bonita.bat.
3. See the error on the command line.

Workaround

Replacing all inconsistent uppercase lowercase names containing 'i'. But that's not sufficient. Then you receive errors saying that Optimistic locking was unsuccessful due to invalid column name. The column name is a name containing an 'i'.

External Link

None

Status

Assignee

Antoine Mottier

Reporter

Elif Kus

Reference

BS-19044

Components

Affects versions

7.7.3